Power Automate SharePoint Get Column Changes
#PowerAutomate #SharePoint
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-...
Pieter Veenstra Get Changes to SharePoint Item Blog Post - https://sharepains.com/2020/09/24/cha...
Table of Contents:
00:00 - Intro
00:50 - Use Case
01:35 - Setting up the Flow Trigger
02:20 - Setting up the Get Changes Action
03:40 - Enabling Versioning
04:21 - Setting up the HTTP Action
07:35 - Check if a field has changed
08:28 - Getting the previous value
11:45 - Testing and wrap up
