cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Meerkat
New Member

PowerApps Drop Down List

I have a simple power app that I developed using Excel as the data source.  But how do I convert one of the fields to a drop down box so users can select a choice.  

1 ACCEPTED SOLUTION

Accepted Solutions
pNabin
Advocate V
Advocate V

Hi @Meerkat,

Could you explain in details about your scenario?

I assume you are trying to add new record where one of the field is dropdown but that field is not dropdown in the excel.
Steps:

1. Select the Datacard for the field you want to make dropdown. In advanced properties, unlock to change properties.

2. Delete the DataCardValue (Input control) of that Datacard. Or hide text input control.

3. Insert New dropdown control inside that datacard.

4. Change new dropdown's property Items as array of your options : Items = ["MIS","Marketing","HR"]
5. Change Update property of the datacard  : Update = Dropdown1.Selected.Value where Dropdown1 is tha name of newly added dropdown control.

6. If you hide the text input datacard, this step is not required. ErrorMessage of that Datacard may so error. change the Y-axis property of ErrorMessage name of old DatacardValue into the new Dropdown control name.like: Y= Dropdown1.Y + Dropdown1.Height. 

7. If you see any error message, update it with the name of newly added dropdown control name.

I hope it is helpful.

Thanks,

Nabin

View solution in original post

9 REPLIES 9
pNabin
Advocate V
Advocate V

Hi @Meerkat,

Could you explain in details about your scenario?

I assume you are trying to add new record where one of the field is dropdown but that field is not dropdown in the excel.
Steps:

1. Select the Datacard for the field you want to make dropdown. In advanced properties, unlock to change properties.

2. Delete the DataCardValue (Input control) of that Datacard. Or hide text input control.

3. Insert New dropdown control inside that datacard.

4. Change new dropdown's property Items as array of your options : Items = ["MIS","Marketing","HR"]
5. Change Update property of the datacard  : Update = Dropdown1.Selected.Value where Dropdown1 is tha name of newly added dropdown control.

6. If you hide the text input datacard, this step is not required. ErrorMessage of that Datacard may so error. change the Y-axis property of ErrorMessage name of old DatacardValue into the new Dropdown control name.like: Y= Dropdown1.Y + Dropdown1.Height. 

7. If you see any error message, update it with the name of newly added dropdown control name.

I hope it is helpful.

Thanks,

Nabin

View solution in original post

v-xida-msft
Community Support
Community Support

Hi @Meerkat,

Could you please share a bit more about your scenario?

Do you want to convert the Text Input box into a Drop down box within the Edit form of your app?

If you want to convert the Text Input box into a Drop down box within the Edit form of your app, please check the following GIF screenshot:Test1.gif

 

On your side, after converting a Text Input box into a Drop down box, please unlock the corresponding Data card, then set the Items property of the Drop down box (Dropdown control) to a Table value consists of available options you want to choose from this Drop down box.

Note: The mac_familia and mac_tipo are both Excel tables in my OneDrive for Busines folder.

 

Best regards,

Kris

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

I had a problem with this solution, but thats solved now (cannot delete my post...)

Hi. Your point 5 returns an error. It says "Expected Text Value". I don't understand whats going on hear.

Try putting in the Data Card's Update setting Dropdown3.Selected.Result (obviously replace the dropdown name with the name of the dropdown in your app)

Hi Kris,

 

I have seen your reply to this elder post as I was searching for a similar solution on how to limit choices in a drop down for a  datacardvalue in a form. 

I tried the exact steps you showed in the GIF. I am able to change to a drop down and choose the dropdown values from my excel table. However the DataCard always shows an error: Name isn`t valid. This identifier isn´t recognized.  

Any Ideas what is wrong here

 

Thansk in Advance

 

Tobi

You probably still are referencing some property from the original datacard which has been deleted, e.g. Y might be set to DataCardValue1.Y + DataCardValue1.Height. Click on the red circle and it should take you to the erroneous property entry. Clear out the value and it should fix it, There will probably be multiple properties to clear out like Height or X, etc.

Hi @pNabin,

Applied your solution and works great but not in case where dropdown contain person info. 

Any ideas on how should I change properties and Items field?

1.png

imthiyaz
Frequent Visitor

I m trying the similar solution with sharepoint list as datasource , somehow my update property gives me the following error . Any idea 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Microsoft Ignite 768x460.png

Find your focus

Explore the latest tools,training sessions,technical expertise, networking and more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (2,384)