cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
ShanP
Level: Powered On

Selected dropdown option not displayed on edit form

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?

4 REPLIES 4
Anonymous
Not applicable

Re: Selected dropdown option not displayed on edit form

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.

 

  1. In EditForm, connect it with your datasoure
  2. Item, select it which item to display (usually it’s something like Gallery1.Selected)
  3. 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.
  4. Unlock the card, under AllowedValues property put in hard coded values or link to database table which has all allowed values.
  5. Under Default property put the field name (if Item is connected to gallery it’s going to be something like Gallery1.Selected.MyField)
  6. This way the EditForm dropdown will always have selected the option which already is selected in a database for this record

 

ShanP
Level: Powered On

Re: Selected dropdown option not displayed on edit form

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

datasource.png

 

Anonymous
Not applicable

Re: Selected dropdown option not displayed on edit form

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.

 

 

 

ShanP
Level: Powered On

Re: Selected dropdown option not displayed on edit form

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.

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (3,903)