Trigger Condition

[asmith36]

I am trying to build a flow that will send an email daily but only when certain criteria is met. I have tried setting trigger conditions on my recurrence trigger, however I keep getting an error message. 

Criteria: Days Since Last Email greater than or equal to 60 AND Days Since Last Phone Call greater than or equal to 60

Error message: Request to Azure Resource Manager failed with error: '{"error":{"code":"WorkflowTriggerHistoryNotFound","message":"The workflow '77482b21-91a7-428d-9f6d-b1de81352ec5' trigger 'Recurrence' history 'null' could not be found."}}'.

I have tried writing the trigger conditions a few different ways, but still receive the same error message. I have also confirmed that the 2 fields I'm using do not have null data. I've also deleted the recurrence trigger and created a new one, so there is no trigger history. When I remove the trigger conditions, my flow works just fine. 

Any insight would be helpful so I don't have to manually send these emails every day and the flow doesn't send a blank email either.

Thanks!

[creativeopinion]

@asmith36 You are using the item() function in your trigger condition. The item() function is designed to be used within an Apply to Each action where it loops through a collection of items. 

In the recurrence trigger there are no items to loop through. Can you share a screenshot of your full flow?

In the meantime, you may be interested in these YT Tutorials: 

4 Ways You Can Use Trigger Conditions in Your Microsoft Power Automate Flow

If you are using an Automated Cloud flow trigger in your flow—you need to consider adding trigger conditions.

Do YOU 🫵 know what a trigger condition is? 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

----

For more flow troubleshooting tips—check out this YT Tutorial: 5 Power Automate Troubleshooting FAQs and Helpful Tips for Creating Better Flows

In this Power Automate tutorial, I explore 5 frequently asked questions that pop up when troubleshooting a flow. If you’d like to to level up your Power Automate flow skills and learn how to troubleshoot your Power Automate flow—this tutorial is for you!

IN THIS VIDEO:

✅ How to troubleshoot a false Condition action result

✅ How to get dynamic content when it isn’t selectable from the list of dynamic content

✅ How to troubleshoot an Apply to Each action that isn’t looping through

✅ How to troubleshoot a skipped Apply to Each action

✅ How to troubleshoot a Filter Query

✅ How to use a SharePoint yes/no column in a Filter Query

✅ How to use Compose actions to troubleshoot a Power Automate flow

✅ How to troubleshoot multiple emails being sent

✅ How to troubleshoot multiple Teams messages being sent

Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
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

[asmith36]

@creativeopinion Thank you for the response. 

I used Filter Array to generate the expression, and was given @greaterOrEquals(item()?['corpsale_ofdayssincelastemail'], 60). When I change the expression to triggerOutputs, I am still getting the same error message.

As you can see, it's a very simple flow. I'm trying to send a daily email to each CRM user with a list of their leads that have not been contacted in 60 days. This flow should fire as soon as Days Since Last Email is greater than or equal to 60 AND Days Since Last Phone Call is greater than or equal to 60 (calculated fields in CRM). I want to use a trigger condition to ensure they are not receiving a blank email on days the conditions are not met. 

[creativeopinion]

@asmith36 As mentioned in my previous post. You can't use that expression in your trigger condition as the item() function is designed to be used within an Apply to Each action. 

In the List Rows action you should insert a query into the Filter Rows field to filter out the rows that match your criteria. I don't personally use dataverse so I can't offer any advice as to what to put there. After you've filtered out the rows that meet your criteria, you can then use the Apply to Each action to loop through the filtered items.

Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
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