Sharepoint List - Log/History column

(0) Share

Report

Posted on by TJO

230

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)

All responses (1)

Answers (0)

Nived_Nambiar 17,497 Super User 2025 Season 1 on at

Like (0)

Report

Re: Sharepoint List - Log/History column

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 !