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
Copy link

Link copied!

@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
Copy link

Link copied!

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
Copy link

Link copied!

@BogdanVlad

Thanks for the feedback, glad I could have helped.

Andrew

Was this reply helpful? Yes No