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!
