I was exploring MS Flow and working on an article series for SharePoint based action in flow and I accidentally found something interesting.
On the below trigger, go to Settings windows using the below buttons. Please note that this option is available in all the trigger points and not specific to below one.
I found a new configuration option, i.e., 'Trigger Conditions'. My first thought is that this is something we are waiting for a long time - To specify a trigger condition which can decide whether it should be triggered or not. To my surprise, it was :)
I tested it immediately and it is working perfectly but it requires knowledge of expressions and we have to type manually. We cannot use dynamic content selection window or expression builder as of now. So, we have to build expression manually. So, this article is to describe how to use these options and see how it works.
Scenario
List Name - Custom List
Column - Status (choice)
Flow Trigger Point - When an item is created or modified.
Use case - Trigger flow only when the Status column is 'Pending'
Click on Add button in the screenshot below 'Trigger Conditions'. Add the below formula.
- @equals(triggerBody()?['Status']?['value'],'Pending')
Click Save and test the flow by modifying or creating an item in List and set Status column value = 'Pending'. As this is a choice column, we need to read its actual value by using ['Value'].
I saved it, went to flow run history, and it showed that it ran successfully.
For getting a better understanding of expressions which can be used here, I will explain some scenarios to give you an idea of how to build formulas for your requirement.
Two conditions where both must be true
You can simply add multiple expressions like below.
Two conditions where anyone can be true
What if you need to check OR between 2 conditions? Again, here, we cannot do it using 2 expression boxes, We would have to do it utilizing single expression with 'OR' keyword. Let us check if status is pending or ID is 42; then only run the flow. Modify the condition to below.
- @or(equals(triggerBody()?['Status']?['Value'],'Pending'), equals(triggerBody()?['ID'],42))
We can use the combination of And and OR like below. Here, we are checking (if the status is pending or completed) and (ID is 42).
- @or(equals(triggerBody()?['Status']?['Value'],'Pending'), equals(triggerBody()?['Status']?['value'],'Completed'))
- @equals(triggerBody()?['ID'],42))
Please note that we can use one or more logical expressions inside a single condition for any complex triggering point. Before this, we used to put condition branch to check value but it still triggers flow and shows in run history. I think this reduces the instance of running flow history by a lot.
I am sure we can expect a good UI in the near future and option to select dynamic content and usage of expression builder as we do with actions.
In this article, we have learned how to create MS flow trigger on certain conditions and how to build an expression for the same.
This option is available for all the triggers in MS flow, it can effectively be used for designing some advanced use cases.
Yunier RodriguezPosted May 11, 2021, 5:54 PM
Are yes or no columns special. I receive an error when running that says that Value cant be ran in Boolean
Guilleni GalindoPosted Jul 15, 2020, 5:22 AM
Hello is there any way to trigger the run only when text is added to an item
Stephan StephanPosted Oct 17, 2019, 5:07 AM
Can we trigger bases upon completion of a specific task Id within planner itself?
Madhan ThuraiPosted Aug 8, 2019, 1:06 AM
Great Work (y)