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

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
PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Top Solution Authors
Top Kudoed Authors
Users online (3,311)