How to get previous column value in "When an item is modified" SharePoint flow?

(0) Share

Report

Posted on by CU01100710-1

How can I retrieve the previous value of a field in a Power Automate flow triggered by "When an item or file is modified" in SharePoint?

Hi everyone,

I’ve set up a Power Automate flow using the "When an item or file is modified" trigger in a SharePoint list. My goal is to capture the previous value of a specific column (for example, "Status") before it was modified.

Specifically, I’m trying to:

Access the column’s value before the modification so I can save it in another column (like "PreviousStatus").
Or, if that’s not possible, retrieve the last saved version of that specific column or even the entire item.

I’ve tried a few approaches, but they all seem to return only the current (post-modification) values. Is there any way to access the previous value, perhaps by using the SharePoint REST API or another method within Power Automate?

Thanks so much for any help!

Categories:

Business Process Flows

All responses (2)

Answers (0)

tom_riha 9,930 on at

Like (1)

Report

How to get previous column value in "When an item is modified" SharePoint flow?

Hello,

you can use either the action as mentioned in the previous post, or you can use an http request as explained in this article.
lbendlin 7,835 on at

Like (0)

Report

How to get previous column value in "When an item is modified" SharePoint flow?

Use the "Get changes" action.