cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bjdshp
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.

1 REPLY 1
S_B1
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

Announcements
Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Top Kudoed Authors
Users online (1,560)