Youtor
Power Automate SharePoint Get Column Changes
>> YOUR LINK HERE: ___ http://youtube.com/watch?v=DT6BpixFbHY
#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
#############################
