Grouping tabulated data into nested tables

Hi All,

Is there an easy way to do a group by on my table that will result in a table within a table similar to my diagram below?


For example in Powerapps this is the behavior of the Group by function

Solution

Hi Anthony Phan,

There's no easy way of doing that using standard database queries. You can achieve the same behaviour (using one query for the main table and a second query for each internal grouping.

Adding Table Records inside other Table Records is also tricky, the platform won't allow it directly, but you can place a web block in a Table Records cell, and have that web block have the other Table Records inside.

Solution