Unanswered

Dropdown not displaying default value

(0) Share

Report

Posted on by krupa4

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

Categories:

Building Power Apps

All responses (2)

Answers (0)

Sort by

v-yuxima-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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

'[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
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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

Thank you,

@Anonymous