web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / DropDown Values Show B...
Power Apps
Unanswered

DropDown Values Show Blank

(0) ShareShare
ReportReport
Posted on by 11

I have a dropdown on a custom datacard. This drop down gets its text and values from a seperate datatable. (via SQL Connection)

 

- I have a count function that shows me the datatable contains  records.

- If I select an 'empty' item when using the dropdown, the form stores the info that it should, I just cant read what I am selecting.

- In the designer, the app works and displays the dropdown values correctly.

 

It is very frustrating. There are no errors I can find.

PhonePhoneDesignerDesigner

 

Each of these photos is from the same records, same build of the app.

Categories:
  • RCWade Profile Picture
    11 on at

    For additional information: 

    The rows display blank in all 'live' situations. I have tested it on a Windows machine, iPhone and iPad.

     

    The dropdown entries only display correctly when running it from the editor.

  • prajyot Profile Picture
    132 on at

    If I understood your issue correctly, you are not able to see the items of the drop down list.

    Set the DisplayMode to DisplayMode.Edit

    Make sure your Items property is populating the values correctly if it is getting from SQL Data Source

     

    Thanks

  • RCWade Profile Picture
    11 on at

    @prajyot wrote:

    If I understood your issue correctly, you are not able to see the items of the drop down list.

    Set the DisplayMode to DisplayMode.Edit

    Make sure your Items property is populating the values correctly if it is getting from SQL Data Source

     

    Thanks


    Thank you for the input.

    - DisplayMode: I misspoke. This is not on an actual 'datacard', but the DropDown control is set to Edit for DisplayMode option.

    - The SQL datasource IS returning exactly what is expected, otherwise the designer would not work.

    - The bug is ONLY present for 'published' versions of the app. It works 100% of the time when running it from within the designer.

    - If I select on the of the resulting 'blank' rows from the drop down, and commit the change, then the app store the correct information, so the VALUES in the the drop-down rows are there, despite not displaying the text on the control.

     

    See the attached snippet, running the app in the designer or on a device, the row count is correct.

    13 rows.PNG

  • mick_swartz Profile Picture
    184 on at

    Ever figure this one out? I'm experiencing something similar right now.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 360 Super User 2026 Season 2

#2
M Bilal Khan Profile Picture

M Bilal Khan 325

#3
Mohsin Ali Profile Picture

Mohsin Ali 232

Last 30 days Overall leaderboard