Answered

Comparing list item versions in a Recurrence flow

(0) Share

Report

Posted on by Power_Automater

351

I have a Recurrence flow setup that checks once per day if certain items in a SharePoint List have been modified and compiles these into a single email. I use a filter array to compare the modified date with the current date:

formatDateTime(item()?['Modified'], 'yyyy-MM-dd') Is Equal To formatDateTime(utcNow(), 'yyyy-MM-dd')

I would like to add another check (perhaps second filter array?) to compare whether the current and previous versions of the item is the same so that I'm not sending updates if it hasn't changed. If I was using the "When an item or file is modified" trigger this would be straight forward, but I need the recurrence in place to be able to compile the changes rather than send emails for each one separately. Is there an Action or Expression I could use to check for this?

Categories:

Using flows

I have the same question (0)

All responses (4)

Answers (1)

Pstork1 69,026 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

You could use a REST call to get the previous version of the item.

Get Previous Versions of SharePoint List Items in Flow (catapultsystems.com)

Was this reply helpful? Yes No
Power_Automater 351 on at

Like (0)

Report
Copy link

Link copied!

Going through the link it suggests to use a Compose to get the previous version number but it doesn't explain how to check if the value of the two versions matches. Could you add a bit more detail on this part please.

Was this reply helpful? Yes No
Verified answer

Pstork1 69,026 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
You have to retrieve the metadata for the previous version and then compare the specific fields you want to compare. There is no way that I know of to compare the actual records directly. To retrieve the values in the previous version it would be the following REST call

_api/web/Lists/getbytitle('MyListName')/items(ITEMID)/versions/{version-id}?expand=fields

That should return JSON that you can Parse to get the individual field values.

Was this reply helpful? Yes No
Power_Automater 351 on at

Like (0)

Report
Copy link

Link copied!

Sorry I'm not quite sure how to use what you have suggested, but thank your response. I have instead decided to use a choice field to control whether or not the changes should be ignored. This works for my purposes

Was this reply helpful? Yes No