Power Automate Conditional Trigger based on SharePoint List Dropdown Value

This video will walk the process of how to add conditional trigger in Power Automate Flow based on SharePoint list choice column value.
Imagine you want to trigger a power automate flow only when a specific value is selected from a SharePoint list choice column while creating new record in SharePoint list.
One way to achieve this is to create power automate flow on item created SharePoint trigger and add a logic in the flow to check if a particular value from the choice column is selected, if that is the case then proceed with the rest of flow logic, otherwise terminate the flow.
Better option is by setting up the conditional trigger in power automate flow. We can tell the flow that only get trigger if following value from a choice column is selected or when a certain condition is met.

🔴 *** BE OUR FRIEND ***

🔎 HASHTAGS 🔎
#PowerAutomate
#SharePoint
#Triggers

[TeddyZ]

Thank you so much! This is exactly what I've been searching for! You've helped me big time.

[RebellionSiam]

Hi! Thank you this is so helpful!
I used it with the trigger "When an item is created or modified" and it worked! Here's my formula if people want to copy/past :)
@equals(triggerBody()?['Status']?['Value'], 'In Progress')

Thank you again for this trick!

[andrewfoncette]

Thank you so much! This is a great video, wonderful content.

[johanvandyk]

Thanks for sharing. Will the same (triggerBody) work for the 'When an item is created or modified' trigger, or should (triggerOutputs) be used? If yes, how will it be formatted, i.e. @equals(triggerOutputs()?['body/Status/Value'], 'Pending')

[ChristineYam]

Very useful video! Thank you so much for creating this content and sharing this.

[hannagolingi]

hi I want to a very similar conditional trigger to send an email based on the value in a certain column in the item list . but the email to automatically send needs to be the email listed a column in that corresponding item list (which will be unique each time). So the email I want to auto-send is to the customer, not anyone internal.

[jaybrowning]

Fantastic This helped me out a lot. Thank you

[creativedecor]

I have a SPList and am unable to get the flow right on a column change. There are 4 options in this list and basically the manager will change this column value to "In Progress" or "Completed". This is an item delivery list. All i want is to send out an email to the person who created the item when the manager selects in progress and when the job is completed so they are aware.

[umarahul]

I need help to send an email notification when a revenue column consists of figures and it should intimate the Manager what was the old figure and what is the new figure updated. Basically, it should list the changed figure and the new figure

[victoriachan]

I was wondering how you could do this with multiple conditional statements? For example, I have question 1 with answer 1 and now I need to create another condition statement with question 1 and answer 2 or question 2 with answer 1.

[asihasih]

Very useful. But when I setting trigger based on Microsoft Form drop down option, not work . There is another solution ?

[bavajidoriginti]

Hi Sir i have one doubt i have status columns 10 values like this a, b, c, d, e, f, .... when user select status 'a' flow will trigger or when user select status 'b' flow will trigger or when user select status 'c' flow will trigger

[llamanking]

You saved my life. Hope I can save yours someday. Peace

[AhmadTayser]

can we do it on FORMS, rather than SharePoint?

[tvenkatesh]

Very useful. But I have a list with choice column. I would like to trigger the flow when the column value is changed from Pending to Resolved. Is that possible

[ComplianceChronicles]

Great video this helped me a lot. I have one question request you to please help me

I wanted to add a condition or formula in my sharepoint list as like - column1 has two drop downs yes/no. If person is selecting column1 as yes then system should show column2 as mandatory. If column1 is selected as NO then column2 can be left blank

Please advise how can I add this condition or is there any of your video answer my question if yes please share the video link

[chrisfinneran]

can you copy the expression into the notes so I can copy out and use?

[AD]

Can you share how to create an outlook event with Conditional Trigger based on SharePoint List Dropdown Value

[papaandoh]

what about two expression which must be true