Answered

Update a SharePoint list item column once another column of that item is modified

(0) Share

Report

Posted on by BogdanVlad

Hello

I have an issue tracker SP list with that is used by end users. I want to build a flow that does the following:
once an item list column is updated ( from in progress to closed) I want to update another column of the same item with the name of the user that made the last update.

Is this doable?

Thank you

Bogdan Vlad

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Andrew_J 1,962 Moderator on at

Like (0)

Report

@BogdanVlad

Try the below. It might help you out.

https://www.youtube.com/watch?v=TsmwWMQIfF0

It may need some modification for your instance.

Regards,

Andrew

Was this reply helpful? Yes No
BogdanVlad 7 on at

Like (0)

Report

Thanks Andrew. With some tweaks made, this works now!
Below is the flow steps, in case others need the same

Below flow only works if "Create a version each time you edit an item in the list" in the Versioning settings is enabled.

Step 1

Step 2

For the expression:
sub(int(triggerOutputs()?['body/{VersionNumber}']),1)
Basically this is taking the last version and substract 1.

Step 3

Step 4

Was this reply helpful? Yes No
Andrew_J 1,962 Moderator on at

Like (0)

Report

@BogdanVlad

Thanks for the feedback, glad I could have helped.

Andrew

Was this reply helpful? Yes No