Category: Micrsoft Flow

Microsoft Flow User Interface is quite simple and intutive but it still gives you an advanced mode to write scripts, we are going to have a glimpse of it.

Advanced mode is available when you have applied condition.

One example is below, lessorequals is the conidion, Budget is the column name and 100000 is the compare value

@lessOrEquals(triggerBody()?[‘Budget’], 100000)

More complex conditions can be written using Workflow Defintion Language.

More examples

@contains(triggerBody()?[‘Budget’], 100000)

Bascially advanced mode needs to be used when you want to satisfy multiple conditions as User Interface only allows Single condition

One example is below, here we are matching Tweet text with multiple hashtags which uses an OR condition

@or(contains(triggerBody()[‘TweetText’], ‘SharePoint’), contains(triggerBody()[‘TweetText’], ‘Office 365’), contains(triggerBody()[‘TweetText’], ‘OneDrive’))

In case you need more help on this or other SharePoint issues please contact us via our Contact Us page or via our Facebook page or via Twitter

Like us on Facebook and follow us on Twitter

Microsoft Flow is a powerful visual workflow creator which helps to create processes and tasks. User Interface is simple and intuitive, let’s see an example

In this example I am going to create Flow from Scratch and not use any template. Template usage has already been shown in another Post.

Example we are going to implement is quite simple, user will add a item with Budget and Description. Based on the budget we will send email to different set of users for approval.

First step is to create a simple list with column Title, Budget (Currency), and Description (Multiline text). To create flow from scratch click menu “See your flows” and not Create a flow as it will ask you to select a template.

Here you can see all your flows and also create from blank, click on it and you will get to flow creation page, next step is to select a trigger for the Flow. You have ample trigger points available but in this case we will select List item creation

Now you need to enter your SharePoint site URL and select the list for which you want to create flow and add next step which will be a condition in case but for yourself you can select any step as per your needs.

Here we added a condition that if Budget is greater 100000 Kr then send email to another person and if less than to send another person. There are mutiple things happening here, you add condition and you also look for actions based on that. You can also Dynamic content like column values from List like Budget

Since we are trying to keep it simple our flow is done and we will Create flow on top to publish it and then we can see it in action

You also have some options of Advance edit and also add further conditions, apply to each , do until and a new scope which we will explore in another post.

Once create click Done and your will flow is ready to use.

Now let’s see this in action!

Add a new item which has budget more than 100000 Kr. Once added I should get email on my Gmail as described in Flow.

Wallah! I got an email and also unsubscribe option is already added which is kind of cool!

You can also how your flow in doing my going to My Flows and see details if it has succedeed. If you clock information icon on right you will see more details, also click on any flow which has run and it will show which steps has been a success or failure.

So that’s it for now, you can see how easy and intutive is to create Flow.