I have a sharepoint list with 1827 items in it. I want to do a scheduled flow to run at 0015 each morning to check certain columns in the list. One column is Follow-up due date and the other is Result of Review. The purpose of the flow is to check the follow up due date to see if it is before today's date (late) and then to get the status of the Result of Review (choice field) of status "Pending Review". If these conditions are met, then I will update the list with a different status. (Which I know how to do). I am stuck on trying to use trigger conditions to make my flow run more quickly, but it doesnt work when I use the @equals(triggerbody()?['ResultofReview']?['Value'], 'Pending Review'). It does work when I use OData filter of ResultofReview eq 'Pending Review'. But doing the OData route makes the flow at least 17s because there is 1827 records. I tried a condition after the get items to look for the follow-up date and then do a less than UTCNOW() and in the true column is my results, but it still returns the same amount that is prior to this condition. Any help would be appreciated. Thanks!
Could you add a compose action step and use the below expression
See what value is returning?
Not sure you need the value attribute here. Try the expression without the value.
I didn't get that. What value it is returning for the below expressions?
Add two compose actions and add the above two expressions.
Remove the current trigger expressions. I want to see what values are returning. You mentioned its the date which I am not very clear.
So I think I have a half work around. I just did a get future time in Odata since my column I was trying to point to is a calculated column. It works, but the flow is kinda slow. Around 1-2 min total.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Read the latest about new experiences and capabilities in the Power Automate product blog.
If you are a small business ISV/Reseller, share your thoughts with our research team.