Forum Discussion

y2kardell's avatar
y2kardell
Copper Contributor
Feb 16, 2022

Copy One Column to Another Column in the same SharePoint Item

Hello- Maybe someone can help me with this scenario. I have a currency column (Column A) in a SharePoint item list that I would like to duplicate the values from Column A to Column B. I know that I ...
SharePoint Online
y2kardell's avatar
y2kardell
Copper Contributor
Feb 16, 2022

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

RobElliott's avatar
RobElliott
Silver Contributor
Feb 17, 2022
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.
  • y2kardell's avatar
    y2kardell
    Copper Contributor
    Feb 17, 2022
    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
    • RobElliott's avatar
      RobElliott
      Silver Contributor
      Feb 17, 2022

      y2kardell I think we're going round in circles here. The way I demonstrated how to do it used a number colyumn for "column B", not a calculated column. 

       

      Rob
      Los Gallardos
      Microsoft Power Automate Community Super User

      • y2kardell's avatar
        y2kardell
        Copper Contributor
        Feb 17, 2022

        RobElliott if you look at this portion of my flow maybe I can explain.

        I have a column under Update Item #1 that pulls data from Get items. The user is going back and manually entering the "Actual Amt" which is a non calculated column.

        My goal is to take the user input (from when the user enters the value for "Actual Amt" and replicate that specific value into the "Payroll Amt" column that is also not calculated so that I can display the sum for "Payroll Amt and Actual Amt" without either being a calculated column in SharePoint.

        Sorry for the repetitiveness but I wanted to show you the actual flow so that maybe it becomes clearer.

        I think it would work but I don't have an "output" value for "Actual Amount" coming in from the Update item #1 connector, or perhaps I may need to change the flow? Where you see the Start and wait for approval (Routed to AP) is where the "Actual Amt" value would be entered by the user on the second SharePoint list being "Ship Tickets." Perhaps you may have a better suggestion.

        Thanks again,

        y2kardell

         

         

         

Resources