Hi
I am trying to run a scheduled Power Automate Flow every day to check a SharePoint list, it is supposed to check 2 criteria, that todayDate = OverdueInspectionDate (this part is working) but I want to track has a DateInspected field changed as well.
Is this impossible to configure? Everything I have been reading is related to using the Get changes for an item or a file (properties only) with a When an item is created or modified step. My scheduled flow might not work on this basis.
The flow should check has DateInspected changed and then check today = Overdueinspectiondate.
If these conditions are true it will email.
Any assistance or advice is greatly appreciated.
Thanks
Nooice, mate!
Just remember that you can for sure put a condition in the flow, but you can use actual Trigger conditions in the trigger's settings. 👍
Hi eliotcole, thanks for your reply. I have versioning working on my list and it works checking if a field has changed when I use the "when an item is changed or modified" trigger but I was hoping I could check it daily using a schedule. Not to worry, I can rework it the original way to look at "when an item is changed or modified" and then follow your advice and set an additional condition that the Date column has changed.
Thanks
Hi Pstork1, thanks for your advice, I will re-work the flow to use the original trigger and can check the date within that.
Briefly up front, displaying what you've got so far (and obfuscating any sensitive information) in a screenshot is really assistive to working towards a cool solution (if we can).
However, also, have you got any versioning setup on the SharePoint list in question? If not, it *really* helps in tracking changes to the values of columns in SharePoint. Check the list settings (from the cog), or go to the following URL, where; DOMAIN is your company's domain, SITE_NAME is the site the list is on, and LIST_ID is the ID of the list.
https://DOMAIN.sharepoint.com/sites/SITE_NAME/_layouts/15/LstSetng.aspx?List=%7BLIST_ID%7D
Also, yes, tracking based on a trigger like you mentioned would be the norm for this kind of thing. Off the top of my head, if you were worried about a high volume of responses to this, you could mitigate it with a Trigger Condition that only looks for either of these columns being changed.
The Get Changes functionality only works with a specific trigger. It won't work with a recurrence trigger. So you can't check whether DateInspected has changed. But you can look at how long ago DateInspected was. If its older than a certain date then the inspection is due.
Michael E. Gernaey
497
Super User 2025 Season 2
David_MA
436
Super User 2025 Season 2
Riyaz_riz11
244
Super User 2025 Season 2