cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PabloRoldan
Resolver I
Resolver I

How Fill Drop down control?

Hi, in a Table1 that table has some columns one of it is called Country. but all countries are repeated, I need to display those countries in a drop down and add a first option that says "All".  

I just place the formula Distict(table1,Country) but I don't know how to add the "All" option at first.

 something like this.

 

PabloRoldan_0-1633620726446.png

(above image has  hardcoded values)

Thanks.

1 ACCEPTED SOLUTION

Accepted Solutions
lcimon
Resolver I
Resolver I

Hello @PabloRoldan,

 

To add an "All" option, you need to use an extra collection. You can create it as following:

ClearCollect(
    colCountries,
    Distinct(Table1, Country),
    {Result: "All"}
)

 This formula must be in OnSelect or OnVisible property according to your need.

 

Then use the colCountries collection in Items property of your dropdown.

View solution in original post

1 REPLY 1
lcimon
Resolver I
Resolver I

Hello @PabloRoldan,

 

To add an "All" option, you need to use an extra collection. You can create it as following:

ClearCollect(
    colCountries,
    Distinct(Table1, Country),
    {Result: "All"}
)

 This formula must be in OnSelect or OnVisible property according to your need.

 

Then use the colCountries collection in Items property of your dropdown.

Helpful resources

Announcements
Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (1,902)