@ecombs You'll need to use a trigger condition.
For testing purposes, create a flow with the When an Item or File is modified trigger and a single Compose action. A flow needs at least one trigger and one action to run.
In the Compose action insert the dynamic content from the Yes/No column.
In the flow trigger, click on the three dots and select Settings. Insert a trigger condition.
@or(equals(triggerOutputs()?['body/[replace with your internal column name]'], true), equals(triggerOutputs()?['body/[replace with your internal column name]'], false))
My internal column name is YesNo. Keep in mind that the internal column name may not always match the name displayed in your Sharepoint list. Not sure how to write a filter query? Check out
this YT short.
My expression is:
@or(equals(triggerOutputs()?['body/YesNo'], true), equals(triggerOutputs()?['body/YesNo'], false))
If you aren't familiar with Trigger Conditions, you might be interested in the YT Tutorial linked below. I cover how to build the trigger condition expression by using a Filter Array action.
Trigger conditions can be set in most flow triggers. These conditions you set must be true for the trigger to fire.
In this Power Automate tutorial, I’m going to show you how to use trigger conditions in your flows to control when your Power Automate flows trigger. If your plan has flow run limits—you can avoid triggering your flows unnecessarily by using trigger conditions.
I’ll cover four different flow examples that would benefit from trigger conditions:
⚡️ Triggering a flow when a column is changed to a specific value
⚡️ Triggering a Flow When an Event Updated or Deleted
⚡️ Triggering a Flow When a New Folder is Created
⚡️ Triggering a Flow When a Specific Email is Received
I’ll also show you a trick on how to easily create the expressions needed and give you a few tips on how to troubleshoot your flow.
IN THIS VIDEO:
✓ Four different flows that would benefit from trigger conditions
✓ What is a trigger condition?
✓ How to add a trigger condition to your flow
✓ How to trigger a flow when a column is changed to a specific value
✓ How to trigger a flow when an event is updated or Deleted
✓ How to trigger a flow when a new folder is created
✓ How to trigger a flow when a specific email is received
✓ How to troubleshoot a trigger condition
✓ How to prevent case sensitivity issues with a trigger condition
✓ How to use the filter array action to easily compose an expression that can be used in a trigger condition
Hope this helps!
Consider giving me a
❤️ if you liked my response!
👉 Level up your Power Automate skills by checking out my tutorials on
YouTube
👉 Tips and Tricks on
TikTok and
Instagram
