Unanswered

Adding a "All" option to a dropdown with items from a table

(0) Share

Report

Posted on by mrwilliams

I want to create a drop down list with the top option being "All Pupils" and then the other items being generated from a table called 'Groups'. I've read different posts saying this is the correct code to use, where you make a temporary table, add the "All" option, then add the other items, then ungroup it.

Ungroup(
 Table(
 {pupilOptions: ["All Groups"]},
 {pupilOptions: Groups}
 ),
 "pupilOptions"
)

However, when I run this I do not get the top option:

What am I doing wrong?

If I add the column name in to make it this:

Ungroup(
 Table(
 {pupilOptions: ["All Groups"]},
 {pupilOptions: Groups.'Group Name'}
 ),
 "pupilOptions"
)

I get a drop down, with the top "All groups" option, and three records, but they are all blank:

I must be missing something simple...? But what?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Ethan_009 4,838 Moderator on at

Like (0)

Report

Hi @mrwilliams ,

Can you use "All Groups" instead of ["All Groups"]. Don't put brackets

When you add brackets then that is considered as grouped value

Hope this helps

Was this reply helpful? Yes No
mrwilliams 50 on at

Like (0)

Report

Thanks @Ethan_R - I had tried that but it just causes and error in the formula:

Was this reply helpful? Yes No
Akser 1,546 Moderator on at

Like (0)

Report
Hi @mrwilliams,

Can you provide more information about this 'Groups' table? Is 'Group Name' a single line text or a lookup for example?

Edit: I think I found it:

Ungroup( Table( {pupilOptions: ["All Groups"]}, { pupilOptions: RenameColumns( Groups.'Group Name', "Group Name", "Value" ) } ), "pupilOptions" )

Was this reply helpful? Yes No
mrwilliams 50 on at

Like (0)

Report

Hi @Akser the Group Name field is just a simple text field. I will give your edits a go and see what happens! Thanks.

Was this reply helpful? Yes No