Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Power Platform Community / Blogs / Power Automate Community Blog / Trigger flow on specific co...

Trigger flow on specific column modification in SharePoint- Adding trigger conditions-Power Automate

Gopala_Krishna Profile Picture Gopala_Krishna 1,314
 When we try to implement SharePoint actions in Power Automate, many-a-times we want to implement conditions or make the flow trigger only based on specific column modification.
 

In this blog post, I would like to share you a method on how to trigger flows only on specific column modification in SharePoint.

 

Recently, there has been a new addition to the SharePoint trigger actions in power automate, namely trigger conditions using these we can specify conditions and the flow will trigger only when the specified condition is met.

 

Consider a scenario where I want my flow to trigger only when the value in name column is "test", In flow I will specify the trigger condition as if name equals test and save it. Now the flow will trigger only when the condition is met.

 

If the condition is not met, the flow will not trigger and you will not be able to see any run for the same.

 

Benefits of using this approach

- Reduced number of API calls from Power Automate

- Minimizing the flow runs for better flow performance

Specifying trigger conditions in Power Automate.

Let's consider the scenario shared above and we will try to implement a trigger condition for the same.

 
Step 1: Open Power Automate --> Create Flows --> Automated from Blank, Select the trigger when an item is created and click on create.
Gopala_Krishna_12-1634173925019.png 
Step 2: Once you click on create you will be navigated to flow editor where in you can modify the flow and add actions to be performed below the trigger.
Gopala_Krishna_13-1634173999968.png
Step 3: Click on three ellipses on the trigger action, this will open a side pane click on settings here.
Gopala_Krishna_14-1634174052366.png

 

After clicking on settings you will be able to see multiple options for the trigger scroll down to bottom and you will have the option "Trigger Condition"
Gopala_Krishna_15-1634174107260.png

 

Here in the trigger condition we will specify our condition for checking the information in name column as follows
@equals(triggerBody()?['Name'],'Test')
 
Gopala_Krishna_16-1634174149326.png

 

Step 4: After specifying the condition click on done, Add a compose action below the trigger and select name from the dynamic content.
Gopala_Krishna_17-1634174200199.png

 

This will help us to confirm that when a flow runs it is running only when the name is set to Test and not for other values.
 
To reference column names, specify triggerBody()?['Column name'] this will extract the value coming from the specific column
 
For adding multiple conditions you can click on the add button present below the text area for the condition, this will enable you a new text area where you can add a new condition.
 
When the add multiple conditions they are evaluated based on AND operator which means the flow will trigger only when both of them are true.
 
Please refer to the documentation for more information and examples related to implementing trigger conditions.
 
#PowerAutomate #TriggerConditions #SharePoint

Comments

*This post is locked for comments

  • mc_chick Profile Picture mc_chick 80
    Posted at
    Trigger flow on specific column modification in SharePoint- Adding trigger conditions-Power Automate

    What did you try? Change the value of a column after the first value of the column triggers a flow?

  • mlaveri Profile Picture mlaveri 7
    Posted at
    Trigger flow on specific column modification in SharePoint- Adding trigger conditions-Power Automate

    I tried this exactly and it does not work. 

  • mc_chick Profile Picture mc_chick 80
    Posted at
    Trigger flow on specific column modification in SharePoint- Adding trigger conditions-Power Automate

    right - because the trigger condition is also "true" in this case ... my solution (the only solution for now) is to change the column after the trigger "back" to another value ... https://powerusers.microsoft.com/t5/Building-Flows/Trigger-Workflow-only-on-one-Sharepoint-list-column-entry/m-p/2037654

  • Vincent5 Profile Picture Vincent5 37
    Posted at
    Trigger flow on specific column modification in SharePoint- Adding trigger conditions-Power Automate

    Hello, 

     

    I follow your advices but when I modified an other column the trigger start again and again.