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

Unpivot collection for HTML Table

I have spent way too many hours trying to solve this problem.


I have build a collection with the following columns: Name, Date, Amount.  The Name column can have 1-5 names.


I need to unpivot this data and display it in HTML for an email.


The unpivoted data should have a table that has the first column as the date, and then each of the next columns are the Amounts based on the Name (as the header).  Headers would be Date, Name1, Name2, etc.


I have tried all sorts of options with forall and concat and cant get this to work.  Would love to have a solution.

Regular Visitor

Many years later 🙂 - I'm having the exact issue. Did you find a solution?

Or is there somebody else here with an idea?

Helpful resources

Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,308)