cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

How to get the Drop down list while editing?

 Hi everyone,

 

One of the columns in my dataset contains categorical values,

 

I want to have a "Drop down list" for those valuse, in the edit window of Power App.

 

Is it possible in Power App? If yes please guide me how?

 

 

Thanks.

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @Anonymous,

 

You may just use single table in the items property:

["true", "false"]

Or if you would like to work with distinct value, take a look at the distinct function:

Distinct function in PowerApps

"

Syntax

Distinct( Table, Formula )

  • Table - Required. Table to evaluate across.
  • Formula - Required. Formula to evaluate for each record.

"

Regards,

Michael

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

8 REPLIES 8
bean
Continued Contributor
Continued Contributor

If I'm understanding you correctly..

All you need to do is simply:

> connect the datasource that has the data you want to display

>add  a dropdown control

>in the dropdown properties, under Data, set the Items field to that datasource you just added

>select the value to the column you wish to populate the dropdown with

 

picture for reference:

dropdowneg.png

 

Sean

Anonymous
Not applicable

Thanks for your time @bean 

 

I tried to follow the steps you  mentioned but I'm unable to select the drop down field in the under "Data", by default it shows "DropDownSample". 

Anonymous
Not applicable

Hi @Anonymous

 

You have to type out the datasource you added. So replace that DropDownSample with whatever the name of your data source is.

bean
Continued Contributor
Continued Contributor

@Anonymous As @Anonymous said, you need to replace that sample with your own data source. 

 

Sean

Hi @Anonymous,

 

Please take a look at the thread below, follow posts of PowerApps Staff CarlosFigueira:

Edit Form -AllowedValues

 

Besides, we could change the Data Card type to allowed Value, which then will switch the value input into a dropdown automatically.

Check the DataCard for more details:

Understand data cards

 

Regards,

Michael

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Hey guys, thanks for the help,

 

I'm able to get the "Drop down" and also assign the Column to it.

 

But the problem is the drop down list is showing all the values (not the distinct values) in the Column.

 

For instance, if my column has two values "True" and "False", I would like to see only "True" and "False" (just two values) not the number of times of records of "True" or "False".

 

The scenario is to edit the records that I have, selecting "True" or "False" from the drop down list (just like the drop down in Excel)  and update.

 

If it is possible in Power Apps, Please help me.

 

 

Thanks again.

Hi @Anonymous,

 

You may just use single table in the items property:

["true", "false"]

Or if you would like to work with distinct value, take a look at the distinct function:

Distinct function in PowerApps

"

Syntax

Distinct( Table, Formula )

  • Table - Required. Table to evaluate across.
  • Formula - Required. Formula to evaluate for each record.

"

Regards,

Michael

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Thanks a lot @v-micsh-msft

 

It worked really well.

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Power Apps Ideas

Check out the New Ideas Site

We are excited to announce a new way to share your ideas for Power Apps!

Top Solution Authors
Top Kudoed Authors
Users online (4,153)