Answered

Use Get changes for an item or a file (properties only)

(0) Share

Report

Posted on by alan_user

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

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (3)

Verified answer

Pstork1 68,717 Most Valuable Professional on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Verified answer

eliotcole 4,363 Moderator on at

Like (1)

Report

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.

Was this reply helpful? Yes No
alan_user 62 on at

Like (0)

Report

Hi Pstork1, thanks for your advice, I will re-work the flow to use the original trigger and can check the date within that.

Was this reply helpful? Yes No
Verified answer

alan_user 62 on at

Like (1)

Report

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

Was this reply helpful? Yes No
eliotcole 4,363 Moderator on at

Like (0)

Report

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. 👍

Was this reply helpful? Yes No