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

Dropdown not displaying default value

I have an app using SQL datasources.  I created a gallery displaying a few employee interview questions which are answered by selecting a value from a dropdown; yes, no, satisfied, etc.  The answers are saved (patched) to a SQL table.  When recalling the employee's questions and answers, the default should be what is in the SQL table, with the ability to change via the items on the dropdown.  The default value is not showing even though the app knows what the value is.  I have attached a screen print showing the dropdown, its definition to the right and a label containing the default dropdown text below the dropdown.  Thanks in advance for all help.
john  

2 REPLIES 2
Community Support Team
Community Support Team

Re: Dropdown not displaying default value

Hi @krupa4 ,

 

What is the Items of your Dropdown control in your Gallery?

Do you want to it shows the Default value of this Item?

You can try this:

Dropdown.Items:Filter('[dbo].[Tab_20190517GalleryDropDownTest]',ID=ThisItem.ID).Nam

20190517DropDownDefaultValue1.PNG

 

'[dbo].[Tab_20190517GalleryDropDownTest]' is my sql table name,ID is one int Column and is the PK, Nam is Char.

You can change to your datasource and column names on your side.

 

Hope this could be helpful.

 

Best Regards.

Yumia

 

 

Administrator
Administrator

Re: Dropdown not displaying default value

Hi @krupa4 can you review the above reply and update the thread if it was helpful? 

 

Thank you,

 

@TopShelf-MSFT 

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
Users Online
Currently online: 212 members 6,424 guests
Please welcome our newest community members: