Forum Discussion
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
- Anonymous3 years ago
Thank you for directing me to the right platform.
2 Replies
- AnonymousNot 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 TeamIf 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
- AnonymousNot applicable
Thank you for directing me to the right platform.