Capture Date When the Status Gets Changed

(0) Share

Report

Posted on by AkshayManke

Hello All,

I saw some of the similar posts but i have a different requirement hence subitting this.

I have a SP List in which there are two columns as: 'Overall Status' and 'Status'.

Bot the fields are mapped with each other hence i have created a different List and added all the required fields using cascading dropdown as below.

Overall Status	Status
In Progress	Started
In Progress	Ended
Testing	Started
Testing	Ended

I want to capture the date stamp when the 'Status' gets changed of the respective 'Overall Status' value.

Can anyone please help on how to achieve this?

Kind Regards,

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (2)

Verified answer

MarconettiMarco 3,812 Super User 2024 Season 1 on at

Like (2)

Report

Hello @AkshayManke ,

you should follow these steps:

1. Add the SharePoint "Get changes for an item or a file (properties only)" action and put the ID grabbed from the trigger:

2. Add a "Condition" control

- first parameter: the list column you want to monitor

- operator: is equal to

- second parameter: true

3. If Yes, add a "Compose" action in which put the "Modified" value:

So, in this case you're able to get the time stamp if the column value is changed.

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

My blog site about Power Automate: https://powerautomatejoy.com/

BR,

Marco

Was this reply helpful? Yes No
Verified answer

GeorgiosG 1,013 Super User 2024 Season 1 on at

Like (1)

Report

Hi @AkshayManke ,

first of all you can simply use Version History in your Source List. That allows you to track changes.

If you want to track this via an extra list you can use a simple flow to do so.

Consider to create in the "history list" two new columns

- Comment

- SourceID

Comment will be used to track your changes as you want with the timestamp (Modified)

SourceID will be used to identify the item you want to update, if you do not use this a new item will be created after each change in your source list... This will mess up you list. We will store the ID of the Source List item in this column.

You need to create a flow and check if there is already an Item with the ID.

If not --> Create new item

If yes --> Update Item

To not lose the history, we store the input in a text variable and append the new value to it.

History List (Tracker)

Flow:

Was this reply helpful? Yes No
AkshayManke 2 on at

Like (2)

Report

Hi @GeorgiosG and @MarconettiMarco,

Used both of your suggestions and got the expected outcome. Many thanks for your help. Accepting your solutions.

Warm Regards,
Akshay

Was this reply helpful? Yes No
Abhishek_M 3 on at

Like (0)

Report

Perfect! I was struggling with this part and now I'm getting the expected output.. Very helpful..

Was this reply helpful? Yes No