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

How to group by a sharepoint list and transform it into table

Hi team,


I have built an app in Powerapps where employees order lunch menu and saves data into a sharepoint list. The list contains the following information:




I'd like to build a build a flow which sends an automatic email every day. At the moment, the email we are sending manually contains the following information grouped by Dish.




The automatic email should contain the same information grouped by Dish, with the sum of the total people ordering the dish and the initials of the people who ordered (just as you can see in the above picture).


NOTICE: Sometimes employees order 2 First courses and dessert or 2 Main courses and dessert. So there are some cases when a dish is saved in the First course column and other times the same dish can be saved on the Main Course column.



I can't figure out how to do this on Power Automate, so any help would be appreciated. 


Many thanks,







Hi there.  Take a look at this article, I think it gets pretty close to what you are trying to do:


Group By and Sum in Power Automate / Flow


It picks up where the "list" already exists, so you could tack this at the end of your "Get Items" from your SharePoint action.


Keep us posted.



If you liked this reply, please give it a thumbs up! If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.

Helpful resources

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

New Process Advisor Capabilities carousel.png

Read the blog for the latest news

Read the latest about new experiences and capabilities in the Power Automate product blog.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

PA Survey Carousel Image.png

We want to hear from you!

If you are a small business ISV/Reseller, share your thoughts with our research team.

Users online (1,833)