Answered

Best way to display long list of items

(0) Share

Report

Posted on by JR-BejeweledOne

5,836 Moderator

I am looking for suggestions. In my app I have a nested gallery setup of distribution groups. I have a button that is visible if the group has members. Some are dynamic groups and do not contain other groups. The data source is SharePoint and the group members column is multi-select. When the button is clicked a 'popup' displays the member groups. This is working correctly but the list can be quite long and sometimes is larger than the app.

I don't particularly want a gallery here with a scroll bar. I am hoping that there is a way that I can display these member groups in a multi-column format if the count of groups exceeds a certain number. Currently they are being displayed in a label with auto-height turned on, with this formula, which works very well. I thought about a table, but wasn't sure how to accomplish populating the list across two cells.

Concat(LookUp(Ungroup(colGroups, "Details"), Title = varTitle).Members, Value, Char(13))

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

BCBuizer 22,833 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @JR-BejeweledOne ,

Try these settings for the label:

Label.AutoHeight = false Label.Overflow = Overflow.Scroll Label.Height = With( { _Height: (CountRows( Split( Self.Text, Char(13) ) ) * 20) + 10 }, If( _Height > 200, 200, _Height ) )

Basically this acts like as if AutoHeight were turned on, but with a maximum of 200 after which a scrollbar can be used to watch the rest of the items. Of course the Label.Height property can be tweaked in many ways, but I hope you get the gist of it.

Was this reply helpful? Yes No
JR-BejeweledOne 5,836 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

I can use that if it comes down to it, but I am hoping to avoid the scroll bar altogether. I would prefer to have it displayed in multiple columns or maybe two labels, but I might need to create a temporary collection to do it that way.

Was this reply helpful? Yes No
Verified answer

JR-BejeweledOne 5,836 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
I solved this. The solution was to add a second label and modify the formula on the first label to limit the number of groups shown and then use the other formula to capture the remaining rows in the second label.

OnSelect of the button:

Set(varTitle, GalleryLocatonDetails.Selected.Title); Set(varMemberCount, CountRows(LookUp(Ungroup(colGroups, "Details"), Title = varTitle).Members))

First Label:

Concat( FirstN( Sort( LookUp( Ungroup( colGroups, "Details" ), Title = varTitle ).Members, Value ), 30 ), Value, Char(13) )

Second label:

If(varMemberCount >30, Concat( LastN( Sort( LookUp( Ungroup( colGroups, "Details" ), Title = varTitle ).Members, Value ), varMemberCount - 30 ), Value, Char(13) ) )

Was this reply helpful? Yes No