cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
HWib
Helper II
Helper II

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

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!

1 ACCEPTED SOLUTION

Accepted Solutions

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.

View solution in original post

5 REPLIES 5
manuelstgomes
Super User II
Super User II

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

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.

View solution in original post

manuelstgomes
Super User II
Super User II

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

RobEllis
Frequent Visitor

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:

RobEllis_0-1617729153958.png

 

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.

 

See here: https://powerusers.microsoft.com/t5/Building-Flows/New-Trigger-for-Changes-to-a-Column-in-an-Item-in...

 

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.

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (2,029)