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)
- Thank you RobElliott, this worked very well.
RobElliott- I just realized that I was able to accomplish what you have by just adding a calculated field in one of the SharePoint columns, the issue I am having is that I need BOTH columns to display the total/sum. Any ideas?
Thanks again,
y2kardell- It's not possible out-of-the-box to display the total of a calculated column. And you said this yourself in your first post. That's why I made the suggestion I did of using a separate column and a flow.
- RobElliott - thanks for the feedback as I really appreciate it, but is there anyway to accomplish this? The scenario is that the user will go in and input the dollar amount into Column A. I need to find a way to get that amount replicated to Column B without there being a calculated field. Seems there should be a way through Power Automate.
Thanks again,
y2kardell
