Hi All,

Greetings for the day!!!

I learned something new in Power Automate and so this article.

Background / Use Case

• We have SharePoint list having column “status” with possible values
  • New
  • In Progress
  • Completed
• On every status change we need to send an email to respective teams
• For status – New its very easy, on item creation we can send an email
• For update on status column we need to send an email so looking for solution

Solution – SharePoint trigger – “When an item or a file is modified”

• In Power Automate we have a trigger in “SharePoint” call “When an item or a file is modified“
• This trigger made lot easier to get the changes / updates when item or file is updated

• We need to specify details
  • Site Address
  • List or Library Name

• Now, next thing is how to get updates
• We have an SharePoint action “Get changes for an item or a file (properties only)“
  • This action returns information about columns that have changed within a given time window

Note : This action requires versioning is enabled for list or library

• Add the action “Get changes for an item or a file (properties only)”
• This action requires following details
  • Site Address
  • List or Library Name
  • Id – Id of the item for which we need to get the changes
  • Since – Possible values are
    • Trigger Window Start Token OR
    • an item version label OR
    • ISO 8601 date , for ex – YYYY-MM-DDhh:mmz
  • Until – Possible values are
    • Trigger Window End Token OR
    • an item version label OR
    • ISO 8601 date , for ex – YYYY-MM-DDhh:mmz

• Trigger Window Start Token and Trigger Window End Token returns the changes since last update

• Based on “Since” and “Until” values, updates are returned

• The action outputs tokens such as “Has Colum Changed:<Column name>” for every column
• These tokens can be used to filter the column which we want to use in our flow
• As shown in below fig, we are checking if item title is changed – “Has Column Changed: Title“

Complete Demo

Thanks for reading. If its worth at least reading once, kindly please like and share !!! SHARING IS CARING 🙂

Enjoy the beautiful life !!! Have a FUN !!! HAVE A SAFE LIFE !!! TAKE CARE 🙂