Skip to main content

Notifications

Power Platform Community / Forums / Building Power Apps / Not displaying Choice ...
Building Power Apps
Answered

Not displaying Choice values from SharePoint List

Posted on by 45

I have a SharePoint list with a Choice field. I am connecting to this in a PowerApp via the Form control. Instead of displaying the Choice values it is initially displaying Item 1, Item 2 etc. up to Item 15 (there's only 3 choice values). It then blanks out all these values and shows no values at all. In all our other PowerApps we've developed this has worked fine, with the DisplayFields and SearchFields properties displaying as ["Value"]. However, in new forms these now seem to be showing as ["Value1"] and it doesn't seem to matter if the 1 is removed, the choice values never appear (see attached image). New forms, new lists have been tried and tested but the error persists. This is stopping all new developments from proceeding. Any help greatly appreciated.

ThomFromUoC_0-1660904143109.png

 

Categories:
  • Suggested answer
    Paul_2099 Profile Picture
    Paul_2099 26 on at
    Not displaying Choice values from SharePoint List
    Only way I could get a solution to this problem was to select the drop-down, then go to the 'Advance' tab in the right-hand pane, there I just changed the 'IsSearchable' property from true to false and then saved and republished the app. Tested it in the live version and it worked. Don't know why, but it worked.

    Good luck.
     
    Paul
  • aamir Profile Picture
    aamir 37 on at
    Not displaying Choice values from SharePoint List
    No solution in this thread is working.
  • jaanihsm Profile Picture
    jaanihsm 241 on at
    Not displaying Choice values from SharePoint List
    Happened to me today. I had to remove the datacard from the form and re-add. When it happens again I'll try @bisaac workaround. 
  • bisaac Profile Picture
    bisaac 4 on at
    Not displaying Choice values from SharePoint List
    I ran into this problem today. The fix for me was to change the Items property of the DataCard to refer to my column's display names instead of internal names.
     
    By default, this property is locked and uses the internal column name of the SharePoint List column. My column names had spaces in them, and since internal column names don't have spaces, SharePoint usually just removes the spaces to derive an internal name.
     
    For example, broken/default:
     
    Choices([@TestList].TestColumnName)
     
    Changed to fix:
     
    Choices([@TestList].'Test Column Name')
     
    Too bad the internal column name isn't sufficient. What's the point of those internal names if they're not a unique identifier, and why does Power Apps use them if they're not sufficient here?
  • MA-21081317-0 Profile Picture
    MA-21081317-0 23 on at
    Re: Not displaying Choice values from SharePoint List

    I have the same issue, only started happening once I started using power apps to customize the list. I am not sure how to fix it.

  • Verified answer
    ThomFromUoC Profile Picture
    ThomFromUoC 45 on at
    Re: Not displaying Choice values from SharePoint List

    After I opened a ticket with MS they were able to find a reference to this issue where, if you review the DataCardValue properties of the affected Choice DataCard, you may find the Default value is null. Enter ThisItem.[ChoiceFieldName] and this should bring the options back. The cause is unclear but we guessed it maybe due to our template app being somehow corrupted and stripping out the Default value for Choice fields when inserting the Form control. We will be creating a new template for our apps to avoid this, which is frustrating, as a quick test in a blank canvas app shows the error does not reoccur.

     

    [Previous reference of this issue]:  https://powerusers.microsoft.com/t5/Building-Power-Apps/Drop-Down-in-Edit-Form/td-p/49931

     

     

  • ThomFromUoC Profile Picture
    ThomFromUoC 45 on at
    Re: Not displaying Choice values from SharePoint List

    Hi @StretchFredrik the Items property is set to this format, as all our form developments tend to be i.e. Choices([@TEST].TEST_Choice)

  • StretchFredrik Profile Picture
    StretchFredrik 2,612 on at
    Re: Not displaying Choice values from SharePoint List

    Hello,

     

    Put the items property to something similar to this image:

     

    StretchFredrik_0-1660904843350.png

     

Helpful resources

Quick Links

Welcome to the Power Platform…

We are thrilled to unveil the newly-launched Power Platform Communities!…

Community Update 9/9/24…

Power Platform Community Update…

Welcome to the new Power Platform Community!…

We are excited to announce our new Copilot Cookbook Gallery in the Community…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 140,690

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,355

Leaderboard