Power Platform Community Forum Thread Details

I am trying to add a row to Excel (stored on SharePoint) when any one of three columns (Stage, Status, Estimated Cost) change in a SharePoint list.

I am having issues with setting the Add a row into a table to add the old value for any/all of the 3 columns and then the new value.

For the Since, I did the current version minus 1 -

sub(int(triggerOutputs()?['body/{VersionNumber}']),1)
 
I would like to update the Excel table to have old and new value columns that match each of the SP list columns in the condition (Stage, Status, Estimated Cost)
 
Any advice on how to add the old value and new value to an Excel table if any/all 3 columns (Stage, Status, Estimated Cost) of a SharePoint list is updated?

Categories:

Building flows

You can accomplish this in Power Automate by using the "When an item is modified" trigger in SharePoint and then retrieving both the current version and the previous version of the list item. Here’s how you can do it step by step:

Steps to Capture Old and New Values and Add Them to Excel

Trigger: Use "When an item is modified" (SharePoint).
Get previous version: Use the "Get changes for an item or file (properties only)" action.
- Set Since to:
  
  sub(int(triggerOutputs()?['body/{VersionNumber}']),1)
- This will retrieve the previous version of the item.
Check if specific columns have changed:
Use the condition block to check if Stage, Status, or Estimated Cost has changed by looking at the output of "Get changes for an item or file".
Get previous values:
- If any column has changed, use the "Get Item" action with VersionNumber -1 to fetch the old values.
Insert into Excel:
- Use "Add a row into a table" (Excel connector).
- Map old values (from "Get Item" for the previous version).
- Map new values (from the trigger output).

Example of How to Structure the Flow

Trigger: "When an item is modified"
Action: "Get changes for an item or file (properties only)"
- Site Address: Your SharePoint Site
- List Name: Your SharePoint List
- ID: Trigger Output - ID
- Since:
  
  sub(int(triggerOutputs()?['body/{VersionNumber}']),1)
Condition Block: Check if Stage, Status, or Estimated Cost changed:
- Has Column Changed: Stage is equal to true
- OR
- Has Column Changed: Status is equal to true
- OR
- Has Column Changed: Estimated Cost is equal to true
If True:
- Action: "Get Item" (to retrieve old values)
  - Set the ID to the trigger output's ID
  - Retrieve properties from VersionNumber - 1
- Action: "Add a row into a table" (Excel)
  - Map:
    - Old Stage: Get Item → Stage
    - New Stage: Trigger Output → Stage
    - Old Status: Get Item → Status
    - New Status: Trigger Output → Status
    - Old Estimated Cost: Get Item → Estimated Cost
    - New Estimated Cost: Trigger Output → Estimated Cost
    - Modified Date: Trigger Output → Modified Date

Notes:

The Get changes for an item action will return true if a column has changed, so you only trigger the Excel update when needed.
The Get Item action ensures you retrieve the previous values correctly.
If multiple columns change, all old and new values will be logged in Excel.
Ensure the Excel table has columns for Old Stage, New Stage, Old Status, New Status, Old Estimated Cost, and New Estimated Cost.