Get changes for an item or a file (properties only) not getting all the changes made

(0) Share

Report

Posted on by HWib

103

Hello everyone,

I am trying to create an audit trail to capture changes to items in SharePoint list.

To do this I am using 'Get changes for an item or a file (properties only)' action in Power Automate.

Upon testing this, I notice not all changes were captured during my flow run.

For example I made 4 changes to an item in SharePoint (4 versions were registered) in the version history, but flow only run once.

I made all 4 changes within one minute. Is there a limitation that I am not aware of, or is this a bug?

See screenshot below:

Versioning in Sharepoint.png

Flow run history.png

Flow Run Success.png

Thanks in advance!

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (1)

manuelstgomes 6,625 on at

Like (0)

Report
Copy link

Link copied!

HI @HWib

I just stumbled on this request, but it's been a while that you submitted it. Were you able to fix it?
If so, how did you do it so that the community can benefit from your findings?

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

Was this reply helpful? Yes No
Verified answer

HWib 103 on at

Like (0)

Report
Copy link

Link copied!

hi @manuelstgomes ,

unfortunately, I was not able to resolve this.
my workaround is the following:
1. Create a new SharePoint list which have the following columns:
- The ID of the record being changed
- Field Name
- Previous Value
- New Value
- Person who did it
- Email of the person who did it
2. I pass along the information into flow (triggered by PowerApps), for each field that is being modified, create a line item. in SharePoint in step 1.

Hope that helps.

Was this reply helpful? Yes No
manuelstgomes 6,625 on at

Like (0)

Report
Copy link

Link copied!

Hi @HWib

That's awesome, thanks for sharing.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

Was this reply helpful? Yes No
ee61re on at

Like (0)

Report
Copy link

Link copied!

I'm seeing a similar issue - it seems to be down to the fact that Flows can only run once a minute - so if multiple changes are being made inside of 1 minute, the Flow will only get run once.

I am currently working through this, and I've had some success by configuring the 'get changes' action to check for changes in the last 5 minutes:

Expression is:

formatDateTime(addMinutes(utcNow(),-5),'yyyy-MM-ddTHH:mm:ssZ')

That said, I'm having issues with that, in terms of seems inconsistent in whether it identifies changes or not. I've opened a case with Microsoft - will update here when I've spoken with them.

Was this reply helpful? Yes No
TM888 2 on at

Like (0)

Report
Copy link

Link copied!

See here: https://powerusers.microsoft.com/t5/Building-Flows/New-Trigger-for-Changes-to-a-Column-in-an-Item-in-SharePoint/m-p/674988#M90926

You need to use a specific trigger - When an item or file is modified - and then for the Since and Until on the Get Changes action, you can use Trigger Window Start Token and Trigger Window End Token. That should work to check for changes since the Flow last ran.

Was this reply helpful? Yes No