Unanswered

Track Status change date when item is change

(0) Share

Report

Posted on by Scherodan1

Hi Community,

I stuck in a automation where I like to track the different status change date to an excel file base on an sharepoint list item. So in every case the Status field on sharepoint is change the flow should put the current date to an excel column that refer to the status that is choosen - the row is determinate by an already existing ID or even is set up as a new row with a new ID (eq to title from Sharepoint list item).

Example of Excel file:

ID	New	Stage 1	Progress	Send to Approver	Stage 2	Completet
123
321
555
666

Here the start of the flow - but how I get the right Column to enter the change date?

Thx a lot in advance

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Expiscornovus 33,874 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Scherodan1,

It looks like you are using the Get changes for an item or a file (properties only) action. That action only retrieves which columns have changed. It does not retrieve when the column has changed or what the previous or current values are.

If you want to include that in your automation you would have to interact with the version history of the list item. @tom_riha has a nice blog about this approach:

https://tomriha.com/get-previous-values-of-modified-sharepoint-columns-in-power-automate/

Was this reply helpful? Yes No
Scherodan on at

Like (0)

Report
Copy link

Link copied!

@Expiscornovus - thx a lot. I will have a look in detail on the Blog. I guess in total I already archive this. May major issues / challeange is - to store the time stamp of the change of status in a dedicate cell on the excel matrix.

Was this reply helpful? Yes No
Expiscornovus 33,874 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Scherodan,

Yes, have a look at that blog.

Make sure you add a Send an HTTP request to SharePoint action to your setup which interacts with the version history of the changed item. That would be with an URI like below:

_api/web/lists/getByTitle('<listName>')/items(<itemID>)/Versions(<versionID>)

Was this reply helpful? Yes No