PowerApps Drop Down List

[Meerkat]

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.  

[pNabin · Accepted solution]

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]

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:

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

[Imke]

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

[sludgeza]

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

[Tony_Dempewolf]

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)

[Tobi_O]

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

[Tony_Dempewolf]

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.

[ThimiosSp]

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?

[imthiyaz]

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