cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Nagaraja
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
Community Support
Community Support

Re: How to get the Drop down list while editing?

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
bean Continued Contributor
Continued Contributor

Re: How to get the Drop down list while editing?

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

Nagaraja
Frequent Visitor

Re: How to get the Drop down list while editing?

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

Re: How to get the Drop down list while editing?

Hi @Nagaraja

 

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

Re: How to get the Drop down list while editing?

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

 

Sean

Community Support
Community Support

Re: How to get the Drop down list while editing?

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.
Nagaraja
Frequent Visitor

Re: How to get the Drop down list while editing?

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.

Community Support
Community Support

Re: How to get the Drop down list while editing?

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

Nagaraja
Frequent Visitor

Re: How to get the Drop down list while editing?

Thanks a lot @v-micsh-msft

 

It worked really well.

Helpful resources

Announcements
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Top Solution Authors
Top Kudoed Authors
Users online (9,537)