Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

update a secondary sharepoint list and group columns subtotal using flow

Hi! I am trying to build a flow that will take individual line items from a sharepoint list and group them into a 2nd sharepoint list and sum a second column. 

I found a website to build the flow (can't seem to find it again 😞 ) The flow runs successfully, but I don't get any data in my 2nd sharepoint list. 



Community Support
Community Support

Hi @aprilhorwitz,


Could you please share more details about your sharepoint lists?

Could you please share more details about the expression union() inside the Compose in your flow?


I afriad that there is something wrong on the input field of your Compose 2 action,please check if you should add an expression instead of insert the expression inside the Input field directly.



Best regards,


Hey, @aprilhorwitz!


It appears as though @v-yuazh-msft would like some more information in order to further assist you properly with your issue. Please share any additional information that was requested in order to decrease the amount of time that it will take for you to be assisted!


Thank you for being an active member of the Flow Community!

Flow Community Manager

- Gabriel
Community Manager
Power Automate | Power Virtual Agents
Super User Program Manager

Frequent Visitor



I also have replicated this flow for my needs and also have the flow running without error, but no results copied to the second list.

Any update on this?



Helpful resources

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Users online (3,021)