SharePoint List - track changes with color highlighted when send through email using Power automate.

[GRPBKS]

Hi, when we receive an email through Power automate flow for any changes done to the SharePoint list columns, is there a way that all changes (only changed values) can be highlighted with color. Please let me know.

example: something similar like this one below.

[yashag2255]

Hi @GRPBKS 

By default, we cannot get the details of the changed column on the data when the flow is triggered based on item modified. 

There is a tedious process as a workaround which involves enabling versioning on the list and then when the flow is triggered, get the previous version using the SharePoint REST api, compare every single column and then highlight the changed ones and send in the email. 

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[GRPBKS]

Actually, we can get the changes of the changed column value with color coding from the SharePoint manage rules feature, but it triggers as an individual email notification hence looking for power automate flow as an alternate. However, thanks for the reply.

[yashag2255]

Hi @GRPBKS 

Yes, that is correct. With the alert rules, you get the highlighted information. However, on Power Automate, you will have to manually setup the flow to get the similar functionality. 

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[GRPBKS]

Thanks, working on it. Will wait for someone to reply with easy solution.

[GRPBKS]

Unable to process template language expressions in action 'Compose' inputs at line '0' and column '0': 'The template language expression 'if(outputs('Get_changes_for_an_item_or_a_file_(properties_only)')?['body/ColumnHasChanged/ID'],'#FFFF00','#ffffff')' cannot be evaluated because property 'body/ColumnHasChanged/ID' cannot be selected. Array elements can only be selected using an integer index. 

i am getting this error when tried to use compose for the above query. can anybody help me on this?

[MrDoudou]

HI @GRPBKS,
...and an happy new year 2024!
Did you find a solution to set changes in Highlight?
I'd like to reproduce the sharepoint alerts in powerautomate and I'm having the same problem as you.

Thanks in advance,

Ed'

[GRPBKS]

Hi @MrDoudou yes we found the solution but its very tedious one like using both dynamic content and the expressions together in the flow.

[MrDoudou]

Thanks for your feedback @GRPBKS !
If you ever have an example of your solution I would be interested, if not thanks for informing that it is possible.
Ed'

[GRPBKS]

ok, let me look into how can i setup an example for you from our case.