Power Platform Community Forum Thread Details

I've got a sharepoint list with a column named 'Status', which is a dropdown of 3 choices (Open, in progress, completed).

Now i'd like to track changes of 'Status' in a second column (multiline text with appending changes). So basically i'd like to track who, at which time, changed the status.

I assume this requires a flow. But i don't know how to start (from which templates)

Categories:

Using flows

Hi @TJO

Use item/file is modfiied , this will trigger cloud when any changes are made in item.

But to detect changes, in which column changes has been made, we need to use get changes in item action

there we will use get changes in item/file like below

Expression used: concat(string(sub(int(first(split(triggerOutputs()?['body/{VersionNumber}'],'.'))),1)),'.0')

The output of this action is the boolen whether each column has changed or not. In our case we will check it for status column like below

if it is true, then it means status column was updated and thus you can do the appropriate actions in yes branch acocrdingly.

to get the details of who modfiied the item use this variable from when item or file is modified

Hope this helps !

Mark it as solution if it resolves your query !

Community site session details

Sharepoint List - Log/History column

Helpful resources

News and Announcements

Quick Links

Forum hierarchy changes are complete!

Ajay Kumar Gannamaneni – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Power Automate

Featured topics

Product updates