cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

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
Highlighted

Hi @Nagaraja,

 

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
Highlighted
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

Highlighted
Frequent Visitor

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". 

Highlighted
Anonymous
Not applicable

Hi @Nagaraja

 

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

Highlighted
Continued Contributor
Continued Contributor

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

 

Sean

Highlighted

Hi @Nagaraja,

 

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.
Highlighted

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.

Highlighted

Hi @Nagaraja,

 

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

Highlighted

Thanks a lot @v-micsh-msft

 

It worked really well.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (7,404)