Search code examples
powerappspowerapps-canvaspowerapps-formulapowerapps-collectionpowerapps-selected-items

Convert Columns to Rows in collection power apps

How to convert from this collection:

enter image description here

to like this:

enter image description here

Solution

  • (Only because I had the data already mocked from a previous answer :) )

    UI: Nested Gallery

    enter image description here

    PowerFX: Exactly as @carlosfigueira mentioned

    Assuming colData is the data shown in original post

    • Set galParent to GroupBy(colData, "principalDisplayName", "group")
    • Set galChild to ThisItem.group

    Visual

    enter image description here