You’re offline. This is a read only version of the page.
Announcements
1,512
I have a gallery with a nested gallery inside, I need to be able to rollup all comments by individual in one view similar to this.
All of the data is in a SharePoint list I just dont know how to consolidate, concat to make it work.
Any direction would be appreciated.
So, it sounds like you could use GroupBy to do what you want. Something like this as the Items property of your gallery may work
Share
Report
All responses (
Answers (
GroupBy(
yourListName,
"FullName",
"IndividualGrp"
)Then, add a label into your gallery:
ThisItem.FullNameThen add a second gallery into your gallery and set it's Items to
Filter(
yourListName,
FullName = ThisItem.FullName
)Then add another label inside the second gallery
ThisItem.Comments
Resize your galleries to suit.
Assumptions:
- FullName is the name given to the column that holds the individual's name
- Comments is the column that holds all of the above data
Note: GroupBy isn't delegable, meaning if your list is larger than 2000 records it won't work correctly and you'll need to look into how you can do things slightly differently
