Forum Discussion
Copy One Column to Another Column in the same SharePoint Item
y2kardell you can do this with a simple flow in Power Automate as shown below. BUT first you MUST turn on item versioning in your list settings as the flow compares the current version to the previous one.
The expression in the Since field is:
sub(int(triggerOutputs()?['body/{VersionNumber}']),1)
...and that is what compres the current version of the item with the previous one.
Next, add a condition and select Has Column Changed: Total (or whatever your column is called):
Leave the red if no channel empty and in the green if yes channel add a SharePoint update item action and in (in my case) the FlowTotal column I have selected the calculated Total column.
It will take a few seconds for the flow to run but the result is as shown below and the column total has been updated.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)