Unanswered

PowerApps Drop Down List

(2) Share

Report

Posted on by 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.

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

Verified answer

pNabin 249 on at

Like (17)

Report

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

1 people found this reply helpful.

Was this reply helpful? Yes No
v-xida-msft on at

Like (3)

Report

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

Was this reply helpful? Yes No
Imke 281 on at

Like (2)

Report

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

Was this reply helpful? Yes No
sludgeza 27 on at

Like (3)

Report

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

Was this reply helpful? Yes No
Tony_Dempewolf 21 on at

Like (1)

Report

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)

Was this reply helpful? Yes No
Tobi_O 13 on at

Like (1)

Report

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

Was this reply helpful? Yes No
Tony_Dempewolf 21 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
ThimiosSp 113 on at

Like (1)

Report

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?

Was this reply helpful? Yes No
Imthi 21 on at

Like (1)

Report

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

Capture1235.PNG

Was this reply helpful? Yes No