Hi All,
I'm looking to generate below excel data into below shown format data by using nested galleries.
It would have been great if PowerApps would have allowed three level nested galleries as there is only 2 level nested galleries currently
Currently by using two level nested galleries I can make up to below format but I want to group category data as well, for example I want to show two
Agenda Topics in one Nomination
Category
I did by using first gallery(gly_pivot_1) items as below with selection filters

Distinct(Sort(
Filter(
INGRollingAgenda,
MBB_Meeting >= dt_strtdate_2.SelectedDate && MBB_Meeting <= dt_enddate_2.SelectedDate,
DropdownPivotOrganisation_1.Selected.Value in Organisations.Value || DropdownPivotOrganisation_1.Selected.Value = Blank()
),MBB_Meeting),
Text(
DateTimeValue(MBB_Meeting),
And second Gallery(gly_agenda_1) Items as below
Sort(
Filter(
INGRollingAgenda,
ThisItem.Value = MBB_Meeting
),
MBBCategory.Value
),
And then later I added two labels Category and AgendaItems under second gallery and date(laebel25) under first gallery
Now I want to group category data as well, for example I want to show two
Agenda Topics in one Nomination
Category for 14August