Skip to main content
Community site session details

Community site session details

Session Id : 5IiMYMMNdEvDBabOgN/4Vg
Power Automate - Building Flows
Answered

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

Like (0) ShareShare
ReportReport
Posted on 28 Oct 2021 14:58:42 by 62

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

 

  • eliotcole Profile Picture
    4,266 Moderator on 29 Oct 2021 at 12:12:53
    Re: Use Get changes for an item or a file (properties only)

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

     

  • Verified answer
    alan_user Profile Picture
    62 on 29 Oct 2021 at 08:15:56
    Re: Use Get changes for an item or a file (properties only)

    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

  • alan_user Profile Picture
    62 on 29 Oct 2021 at 08:12:55
    Re: Use Get changes for an item or a file (properties only)

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

     

     

  • Verified answer
    eliotcole Profile Picture
    4,266 Moderator on 28 Oct 2021 at 15:12:49
    Re: Use Get changes for an item or a file (properties only)

    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.

  • Verified answer
    Pstork1 Profile Picture
    67,129 Most Valuable Professional on 28 Oct 2021 at 15:04:20
    Re: Use Get changes for an item or a file (properties only)

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2

Loading complete