Unanswered

Group Columns

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi everyone,

I have a question, Is it possible to make a dropdown by groups? for example, in excel i can group many rows, like the pics.

I would like to do that in a table, like this:

Is it possible? also group the same names in the column "Supervisor"

I'm going to waiting for your comments,

Best regards.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

In your first request, I suggest you use 2 Galleries. One for the Group and the other for the expansion.

Gallery 1 Items
Distinct (Datasource,ColumnName)

Gallery 2 items
Filter (Datasource,ColumnName=Gallery1.Selected)

On the second request on the Datatable, just sort the Datasource on the item property of the Datatable;
Sort(Datasource, supervisor)
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, thank you for your soon reply,

like a subgallery?

Was this reply helpful? Yes No
eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes two galleries side by side
One as the Group Head and the other for Details.

Try the formula and give feedback
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous

You may want to check out the GroupBy() function to create a Gallery and Subgallery. @PaulD1 has a nice video that may help your design. https://powerusers.microsoft.com/t5/Webinars-and-Video-Gallery/PowerApps-Gallery-SubGallery-using-GroupBy-and-Flexible-Height/m-p/74193

Was this reply helpful? Yes No