cancel
Showing results for 
Search instead for 
Did you mean: 
Gopala_Krishna

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

 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.
 
Comments
Meet Our Blog Authors
  • Experienced Consultant with a demonstrated history of working in the information technology and services industry. Skilled in Office 365, Azure, SharePoint Online, PowerShell, Nintex, K2, SharePoint Designer workflow automation, PowerApps, Microsoft Flow, PowerShell, Active Directory, Operating Systems, Networking, and JavaScript. Strong consulting professional with a Bachelor of Engineering (B.E.) focused in Information Technology from Mumbai University.
  • I am a Microsoft Business Applications MVP and a Senior Manager at EY. I am a technology enthusiast and problem solver. I work/speak/blog/Vlog on Microsoft technology, including Office 365, Power Apps, Power Automate, SharePoint, and Teams Etc. I am helping global clients on Power Platform adoption and empowering them with Power Platform possibilities, capabilities, and easiness. I am a leader of the Houston Power Platform User Group and Power Automate community superuser. I love traveling , exploring new places, and meeting people from different cultures.
  • Blog site: https://ganeshsanapblogs.wordpress.com/ MCT | SharePoint, Microsoft 365 and Power Platform Consultant | Contributor on SharePoint StackExchange, Techcommunity
  • Encodian Owner / Founder - Ex Microsoft Consulting Services - Architect / Developer - 20 years in SharePoint - PowerPlatform Fan
  • Founder of SKILLFUL SARDINE, a company focused on productivity and the Power Platform. You can find me on LinkedIn: https://linkedin.com/in/manueltgomes and twitter http://twitter.com/manueltgomes. I also write at https://www.manueltgomes.com, so if you want some Power Automate, SharePoint or Power Apps content I'm your guy 🙂
  • I am the Owner/Principal Architect at Don't Pa..Panic Consulting. I've been working in the information technology industry for over 30 years, and have played key roles in several enterprise SharePoint architectural design review, Intranet deployment, application development, and migration projects. I've been a Microsoft Most Valuable Professional (MVP) 15 consecutive years and am also a Microsoft Certified SharePoint Masters (MCSM) since 2013.
  • Big fan of Power Platform technologies and implemented many solutions.
  • Passionate #Programmer #SharePoint #SPFx #M365 #Power Platform| Microsoft MVP | SharePoint StackOverflow, Github, PnP contributor
  • Web site – https://kamdaryash.wordpress.com Youtube channel - https://www.youtube.com/channel/UCM149rFkLNgerSvgDVeYTZQ/