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
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Users online (64,199)