Unanswered

Dropdown not displaying choices from SharePoint list properly

(0) Share

Report

Posted on by Ayoub

Hi everyone,

I'm encountering an issue with a dropdown control in my Power Apps app that retrieves data from a SharePoint list. When I run the app, the dropdown control displays blank options instead of the choices from the SharePoint list.

Categories:

Building Power Apps

I have the same question (3)

All responses (11)

Answers (0)

StretchFredrik 3,395 Super User 2025 Season 2 on at

Like (0)

Report

Try swapping the following in the properties of your dropdown:

Was this reply helpful? Yes No
v-qiaqi@microsoft.com on at

Like (0)

Report

HI @Ayoub,

If you mean a dropdown control inside a data card from the Edit Form, I think you need to tell us how you set the Items property of this dropdown control, which is the key to your issue.

And check how you set the Default/DefaultSelectedItems property of this dropdown control.

BTW, if the dropdown control you mentioned is a Dropdown box, I suggest you replace it with a ComboBox.

Was this reply helpful? Yes No
Ayoub 11 on at

Like (0)

Report

hello,
I want to export a column data from a sharepoint liste.
thanks for reply

blanc.png

destinct.png

Was this reply helpful? Yes No
Ayoub 11 on at

Like (0)

Report

Hello,
thanks for reply
BTW I can't find the same screen.

screen.png

Was this reply helpful? Yes No
v-qiaqi@microsoft.com on at

Like (0)

Report

HI @Ayoub,

Is it a modern control?

If so, I strongly suggest you use a classic instead.

Modern controls are not that stable, it displays blank dropdown menu from time to time.

Was this reply helpful? Yes No
Ayoub 11 on at

Like (0)

Report

hi @v-qiaqi-msft,
i use a classsic control but can't import data colomn

Was this reply helpful? Yes No
Ayoub 11 on at

Like (0)

Report

Hi @StretchFredrik ,
I can't find DisplayName

Was this reply helpful? Yes No
StretchFredrik 3,395 Super User 2025 Season 2 on at

Like (0)

Report

Since you are using Distinct, the only column available will be Value, which in this case is your Typologie column

Was this reply helpful? Yes No
v-qiaqi@microsoft.com on at

Like (1)

Report

HI @Ayoub,

The Distinct() function expect a column name, just a column without double quotes.

Was this reply helpful? Yes No
Ayoub 11 on at

Like (0)

Report

Hi @v-qiaqi-msft,
I try it it works but dosn't show me any choice when i run the app.
The erreur is : Table doesn't contain any column of text type.

Was this reply helpful? Yes No