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
DropdownPivotOrganisation_1.Selected.Value in Organisations.Value || DropdownPivotOrganisation_1.Selected.Value =Blank()
),MBB_Meeting),
Text(
DateTimeValue(MBB_Meeting),
"dd mmmm yyyy"
)
)
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
Though I didn't find way to group the columns inside second nested gallery and there is no option to nest third level nested gallery, I found turn around solution to hide the column when it gets repeated as shown below
You can write below formula on text field to hide when it's not needed
mysolution8 is collection name of datasourceand field_26 and field_7 are columns within in it and this compares with ID which has been created in sharepoint for every row
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
17
Share
Report
All responses (
Answers (
