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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Dropdown form field no...
Power Apps
Answered

Dropdown form field not using the correct sharepoint list choices

(1) ShareShare
ReportReport
Posted on by 45

Hello,

When I add a dropdown form field from a sharepoint list choices field, instead of showing the choices it showsa big list of numbered items, none of them present in the sharepoint list choices field.
This only happen with newly added form dropdowns, the ones that were added prior to this problem are working fine.

The first image is the form field, the second is the sharepoint list column config.

Thanks for any help!

Screenshot 2022-08-19 151430.pngScreenshot 2022-08-19 151515.png

Categories:
I have the same question (0)
  • Drrickryp Profile Picture
    Super User 2024 Season 1 on at

    @IT-AKF 

    I avoid choices fields in SharePoint. They offer little advantage in PowerApps and make things much more complicated when analyzing data.  You can change the column type to a single line of text without losing data.  In PowerApps, limit the choices by using a dropdown control in the card with the Items property ["Programada","Nao Programada"].  As long as you are not going to add more choices later, this is the simplest solution.  After making the change in SharePoint remember to save them and refresh the browser.  Then, in PowerApps, refresh the data source.

  • Drrickryp Profile Picture
    Super User 2024 Season 1 on at

    @IT-AKF 

    I avoid choices fields in SharePoint. They offer little advantage in PowerApps and make things much more complicated when analyzing data.  You can change the column type to a single line of text without losing data.  In PowerApps, limit the choices by using a dropdown control in the card with the Items property ["Programada","Nao Programada"].  As long as you are not going to add more choices later, this is the simplest solution.  After making the change in SharePoint remember to save them and refresh the browser.  Then, in PowerApps, refresh the data source.

  • NandiniBhagya20 Profile Picture
    4,667 Super User 2024 Season 1 on at

    Can you please check the items property of this field in power apps

  • Verified answer
    IT-AKF Profile Picture
    45 on at

    Checked the DisplayFields property and they where all set to ["Value1"] instead of ["Value"] when the fields are automatically added to the form, after setting the data source!
    Changing it to ["Value"] gets this running good again.

    Never happened before, it's the second time this week that property fields are changed in apps that I am developing with no change at all in the app.

    Thanks for the help @Drrickryp , @NandiniBhagya20 


  • Drrickryp Profile Picture
    Super User 2024 Season 1 on at

    @IT-AKF 

    Yet another reason to avoid choices type columns.

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 765 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 343 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 272

Last 30 days Overall leaderboard