Power Platform Community Forum Thread Details

I have a collection that is created from a reasonably complex (for me) SQL pivot query with dynamic column headers.

This is so that I can show a matrix type table to my users - what we are trying to show is that for any CATEGORY and SERVICE there is a specific MATRIX entry, category names and services change on a regular basis so these are maintained in different joined tables.

The collection is small, but I don't know how many columns or rows will be in the collection, not looking at many more than 10 columns and 20/30 rows, but the column names will change, hence dynamic.

What I need help with is how can I extract the number of and names of my columns to create the HTML table dynamically.

Here is some samples from the collection:

Thanks

Categories:

Building Power Apps

hi steven,

here is an idea us can use this code and change the parameters:

ClearCollect(
 MatrixCollection,
 {
 SID: 1,
 Service: "JJJJ",
 CategoryA: "Matrix1",
 CategoryB: "Matrix2",
 CategoryC: "Matrix3",
 CategoryD: "Matrix4"
 },
 {
 SID: 2,
 Service: "KKKK",
 CategoryA: "Matrix6",
 CategoryB: "Matrix7",
 CategoryC: "Matrix8",
 CategoryD: "Matrix9"
 },
 {
 SID: 3,
 Service: "LLLL",
 CategoryA: "Matrix11",
 CategoryB: "Matrix12",
 CategoryC: "Matrix13",
 CategoryD: "Matrix14"
 },
 {
 SID: 4,
 Service: "MMMM",
 CategoryA: "Matrix16",
 CategoryB: "Matrix17",
 CategoryC: "Matrix18",
 CategoryD: "Matrix19"
 }
);

ClearCollect(
 HTMLTable,
 "<table border='1'>",
 "<tr>",
 "<th>SID</th>",
 "<th>Service</th>",
 "<th>Category A</th>",
 "<th>Category B</th>",
 "<th>Category C</th>",
 "<th>Category D</th>",
 "</tr>",
 ForAll(
 MatrixCollection,
 "<tr>",
 "<td>" & ThisRecord.SID & "</td>",
 "<td>" & ThisRecord.Service & "</td>",
 "<td>" & ThisRecord.CategoryA & "</td>",
 "<td>" & ThisRecord.CategoryB & "</td>",
 "<td>" & ThisRecord.CategoryC & "</td>",
 "<td>" & ThisRecord.CategoryD & "</td>",
 "</tr>"
 ),
 "</table>"
);

If this is the answer for your question, please mark the post as Solved.
If this answer helps you in any way, please give it a like.

Thanks!