Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Power Automate_ Getting "calculated value columns" from multiple SharePoint Lists to new SPoint List

Hello experienced Power Automate users,

 

I have two SharePoint lists, each with multiple columns and one of them a "calculated value". I am looking for assistance to set up the following three (3) action items

 

1) how to create a separate SharePoint list (C) that is picking the following - using Power Automate

  • Country (same across the two list) - so can pick from either SharePoint List A or B
  • "calculated value" from SharePoint list (SharePoint List A = column G4) 
  • "calculated value" from SharePoint list (SharePoint List B = column G13)

quick example in Excel

 

 

 

2) Being able to add the rows for each Country in SharePoint List C  = eg Adding B23 + C23 to get the Grand total for Japan - that will appear in D23

 

3) Hoping SharePoint List C - will appear as normal in Power Bi so that i can carry out a range of analysis. 

 

Thank you in advance for your assistance

  • Anonymous's avatar
    Anonymous
    3 years ago

    Thank you for directing me to the right platform.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous ,

     

    You seem to post a Power Automation question to the Power BI forum, please consider post  it to the Power Automation forum.😅 There you will get faster answers.

    General Power Automate Discussion - Power Platform Community

    Similarly, if you have questions about Power BI, you are welcome to ask questions under this thread or reopen a new thread, and we will be very pleased to answer your questions. Thanks in advance!

     

    Best Regards,
    Gao

    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly -- How to provide sample data

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thank you for directing me to the right platform.