By 103,653 total views, 7 views today
In this conditional trigger power automate tutorial, we will learn how to trigger a Power Automate (Microsoft Flow) conditionally (based on certain conditions) in the SharePoint Online list.
Key-Highlights: Conditional trigger power automate
- Introduction – benefits of conditional trigger in Power Automate
- Demo – how to trigger a Power Automate with the conditioning step by step?
- How to configure the conditional trigger in Power Automate?
- Various Expression in Power Automate Trigger condition
- Various configurations in Power Automate (Flow) trigger
- Verify the conditional triggering in Power Automate from the SharePoint Online list – positive testing
- Verify the conditional triggering in Power Automate from the SharePoint Online list – negative testing
Introduction – benefits of conditional trigger in Power Automate
The trigger conditions in Power Automate (Microsoft Flow) were a great addition released in mid-2019. Prior to this being released, the flow (Power Automate) would run every time whenever any items were added or created based on the trigger action template you select (on item creation or modification) – then, inside the Power Automate (flow) we had to add if condition to control the execution of subsequent actions or flows down the line. This costs an extra burden or licensing in terms of executing the number flow per tenant for a certain period. Now, after this release – the power automate will not get triggered until a certain condition is met true. So, before coming to the particular Power Automate we have the option to check the trigger condition. In the world of workflow automation, the other counter-part big-name “Nintex” has had this conditional trigger option to configure, in this perspective, the Power Automate lagged in comparison to Nintex workflow.
Demo – how to trigger a Power Automate with the conditioning step by step (Conditional trigger power automate)?
As part of the demo, below is the employee list structure where one of the columns is “IsADUser” with the (Yes/No) type – in this demo, we will see if “IsADUser” is “Yes” then only the Power Automate should get triggered, otherwise not, now let’s begin with this step by step.
I have created a test Power Automate named “Conditional Flow Trigger Test”.
And below are the configuration of the Power Automate.
In the above Power Automate, I have selected the trigger template as “When an item is created or modified”, then created a variable named “var_IsFlow_Triggered_Check” with a boolean type whose default value is set to false, once the Power Automate gets executed successfully this boolean “var_IsFlow_Triggered_Check” variable will be set to “true”.
Conditional trigger power automate – how to configure the conditional trigger in Power Automate?
Go to the first trigger template “When an item is created or modified”, click on the three dots, then click on the settings as shown below:
Once we click on the “Settings”, we will go to the “Settings for ‘When an item is created or modified'” screen as shown below:
By default, Split On will be in disabled mode, make it enable. Once we enable the split on we can see that @triggerBody()?[]’value’] is displayed in the array dropdown list.
Then go to the “Trigger Conditions” section located at the bottom of the screen.
Click on the “+ Add” button shown above.
Add the below trigger condition to the box.
@equals(triggerBody()?['IsADUser'],True)
Then click on the “Done” button.
Notes:
- The above trigger condition is checking if “IsADUser” is equal to “Yes” for a certain item in the SharePoint list, then this will get triggered for that item.
- In the above expression “True” shouldn’t be in lower case i.e. instead of “True” if we write “true” it won’t trigger, I have experienced this.
- The general rule of thumb is – in order to trigger the PowerAutomate, the expression outcome must be a “True“.
- In the above example, I have used the “When an item is created or modified” trigger action, however the conditional trigger configuration in all the trigger actions like “When an item is created in SharePoint list” or “When an existing item is modified in SharePoint list”.
- Apart from the “Split On” and “Trigger Conditions” configuration we can keep the rest of the configurations as is.
- We can add multiple trigger conditions by clicking on the “+ Add button“.
Various Expression in Power Automate Trigger condition (Conditional trigger power automate)
| Expression | Result Type | Valid Condition |
| @add(1, 0)
|
Integer | No |
| @true
|
Boolean | Yes |
| @equals(1, 1)
|
Boolean | Yes |
| @json(triggerBody()) | Object | No |
Various configurations in Power Automate (Flow) trigger (conditional trigger power automate)
Though the “Split On” and “Trigger Conditions” are sufficient to run the conditional Power Automate (flow).
For our own knowledge, we should know about the rest of the configurations, so let’s know about those configurations.
Custom Tracking Id:
Set the tracking id for the run. For split-on, this tracking id is for the initiating request.
Secure Inputs (Preview)
Secure inputs of the operation.
Secure Inputs – Enable/Disable Toggle
Retry Policy
A retry policy applies to intermittent failures, characterized as HTTP status codes 408, 429, and 5xx, in addition to any connectivity exceptions. The default is an exponential interval policy set to retry 4 times. The retry policy can be selected as one of the below choices:
- Default
- None
- Exponential Interval
- Fixed Interval
Concurrency Control
Limit the number of concurrent runs of the flow, or leave it off to run as many as possible at the same time.
Concurrency control changes the way new runs are queued. It cannot be undone once enabled.
Limit – Enable/Disable Toggle
Conditional trigger power automate – verify the conditional triggering SharePoint Online list – Positive testing
Go to the “Employee” list and for an item change the “IsADUser” value to “Yes” from “No”.
Now, the power automate , should be triggered.
Go to the “28-day run history” of the Power Automate log report, we can see that a few minutes ago, the Power Automate (Microsoft Flow) ran successfully.
Now, click on the “Oct 31, 8:06 AM (6 min ago)” link from the above report.
In the next screen, we can see the message – “Your flow ran successfully” with all green ticked which confirmed all the actions in the flow have been executed successfully.
By now we have tested the positive scenario that is when the “IsADUser” value is set to “Yes” in the SharePoint Online list for the configured site and list (Employee), the flow should get triggered, and we have seen this worked.
Conditional trigger power automate – Verify the conditional triggering SharePoint Online list – negative testing
In this section, we will perform the negative testing that is we will set the “IsADUser” value to “No” again for the same item in the SharePoint list, and this time the flow should not get triggered as the trigger condition will fail.
Now, if we go to the “28-day run history” report, we can see that the flow didn’t get triggered as the condition was not met true (“IsADUser”=No).
Summary: Conditional trigger power automate
Thus, in this article, we have learned about how to trigger a Power Automate (Microsoft Flow) conditionally that is based on certain value changes in the SharePoint Online list. We can summarize the learning as below:
- Introduction – benefits of conditional trigger in Power Automate
- Demo – how to trigger a Power Automate with the conditioning step by step?
- How to configure the conditional trigger in Power Automate?
- Various Expression in Power Automate Trigger condition
- Various configurations in Power Automate (Flow) trigger
- Verify the conditional triggering in Power Automate from the SharePoint Online list – positive testing
- Verify the conditional triggering in Power Automate from the SharePoint Online list – negative testing
See Also: Conditional trigger power automate
You may also like the below Power Automate tutorials:
- Power Automate: Difference between Send an email notification (V3) Send an email (V2)
- Learn HTML table formatting using Microsoft Power Automate step by step
- Power Automate: How to Export and Import Microsoft Team Flows across environment
- Get started with Power Automate
Hope you have enjoyed reading this article and helped you. If you would like to appreciate our efforts or if you have a better solution or a different opinion, please write to the below comment section and do share this with your friends and colleagues. 🙂
About Post Author
2 comments on “Conditional trigger power automate: Trigger Power Automate (Flow) based on condition in SharePoint Online – Verified”