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 not displayin...
Power Apps
Unanswered

Dropdown not displaying choices from SharePoint list properly

(0) ShareShare
ReportReport
Posted on by 11

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:
I have the same question (3)
  • Fredrik_A Profile Picture
    3,570 Super User 2026 Season 1 on at

    Try swapping the following in the properties of your dropdown:

     

    StretchFredrik_0-1713288147176.png

     

  • v-qiaqi@microsoft.com Profile Picture
    Microsoft Employee on at

    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.

  • Ayoub Profile Picture
    11 on at

    hello,

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

    blanc.png
    destinct.png
  • Ayoub Profile Picture
    11 on at

    Hello,

    thanks for reply

    BTW I can't find the same screen.

     

    screen.png
  • v-qiaqi@microsoft.com Profile Picture
    Microsoft Employee on at

    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.

  • Ayoub Profile Picture
    11 on at

    hi @v-qiaqi-msft,

    i use a classsic control but can't import data colomn 

    Ayoub_0-1713366883786.png

     

  • Ayoub Profile Picture
    11 on at

    Hi @StretchFredrik ,

    I can't find DisplayName 

    Ayoub_1-1713367880842.png

     

  • Fredrik_A Profile Picture
    3,570 Super User 2026 Season 1 on at

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

  • v-qiaqi@microsoft.com Profile Picture
    Microsoft Employee on at

    HI @Ayoub,

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

  • Ayoub Profile Picture
    11 on at

    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.

    Ayoub_0-1713429742499.png

     

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 505

#2
WarrenBelz Profile Picture

WarrenBelz 502 Most Valuable Professional

#3
Haque Profile Picture

Haque 324

Last 30 days Overall leaderboard