Unanswered

Selected dropdown option not displayed on edit form

(0) Share

Report

Posted on by ShanP

143

I have a form application app, the user creates a form and can then view it and edit it after. The form has a few dropdown options. The selected option shows up when on the view screen of the form, but when the user wants to edit the form, the dropdown displays blank. How can I make it so the dropdown displays the option that the user selected during the edit screen?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Community Power Pla... on at

Like (0)

Report
Can you show us your setup?

What data source you are using? Are the unique values enforced in the datasource or in app?

I have an app where I have a string type in SQL Server but I enforce only several option in PowerApps.
In order to show the selected item in ViewForm and EditForm I do the following.

In EditForm, connect it with your datasoure
Item, select it which item to display (usually it’s something like Gallery1.Selected)
Add the card for the dropdown, it will be added as text input, while the card is still locked select for it to be allowed values.
Unlock the card, under AllowedValues property put in hard coded values or link to database table which has all allowed values.
Under Default property put the field name (if Item is connected to gallery it’s going to be something like Gallery1.Selected.MyField)
This way the EditForm dropdown will always have selected the option which already is selected in a database for this record

Was this reply helpful? Yes No
ShanP 143 on at

Like (0)

Report

Data source is excel file on onedrive. The values are from the excel file.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

The default value of the Card which holds the dropdown, or the default property of the dropdown should be changed to whatever you want to show.

The form you are showing appears to be NewForm not EditForm (because of lack of entries in other fields)

Where does user enter a value, for the dropdown to understand which value to show?
You have to connect user Input field with the DropDown.Default or Card.Default parameter.

Was this reply helpful? Yes No
ShanP 143 on at

Like (0)

Report

Sorry, the list is an editform list, but it is not populated as I just have the problem with the drop down, not any of the other fields.

The drop down has 5 options, these options are chosen by me and stored on an excel file. The options are pulled from excel using distinct(Dropdown, Protection). Dropdown is the table name and Protection is the header of the column.

So the problem is that when a user wants to edit their form, all the other entries display properly, but the drop downs do not show the selection of the user. They are actually blank, so for the time being I filled it in with default values.

Was this reply helpful? Yes No