Power Automate SharePoint Get Column Changes

With the Get Changes Action in Power Automate we can determine if a column has changed in your SharePoint list or library. But how do we determine what the value was before it changed? Learn how you can leverage the SharePoint HTTP Action in Power Automate to get column changes in your list item using the version history. I'll walk you through all the steps needed to run a flow when an item is modified in SharePoint, tell if a field has changed and get it's previous and current value.

⚠ Code Used

Expression for SharePoint HTTP Action URI Property: _api/web/lists/getByTitle('Asset manager')/items(@{triggerOutputs()?['body/ID']})/versions(@{outputs('Get_changes_for_an_item_or_a_file_(properties_only)')?['body/SinceVersionId'] })

Expression used to get the previous value from the HTTP request: body('Send_an_HTTP_request_to_SharePoint')['d']['Status']

🔗 Links 🔗

Download the Flow: https://github.com/aprildunnam/Power-Automate/blob/master/GetItemChanges_20210512003702.zip

Pieter Veenstra Get Changes to SharePoint Item Blog Post - https://sharepains.com/2020/09/24/changes-sharepoint-items-power-automate/