Skip to main content

Notifications

Power Apps - Building Power Apps
Answered

Not displaying Choice values from SharePoint List

Like (2) ShareShare
ReportReport
Posted on 19 Aug 2022 10:16:58 by 47

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:
  • VT-25101447-0 Profile Picture
    VT-25101447-0 2 on 25 Oct 2024 at 14:50:00
    Not displaying Choice values from SharePoint List
    I had this problem and found deleting the datacards and reinserting was most efficient. Such a pain though. Has worked fine before.
  • Suggested answer
    CamL Profile Picture
    CamL 2 on 02 Oct 2024 at 13:33:52
    Not displaying Choice values from SharePoint List
    As Paul Mentioned below, It appears selecting the drop-down, then going to the 'Advanced' tab in the right-hand properties pane, then change the 'IsSearchable' property from True to False and then save. You can then revert the value back to True, and republish and the issue will be solved, and the list will still be searchable.

    Again, no idea why this works but it does, and this ensures the dropdown list is still searchable.

    Thanks,
    Cam
  • Suggested answer
    Paul_2099 Profile Picture
    Paul_2099 26 on 05 Sep 2024 at 14:37:58
    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 27 Aug 2024 at 20:07:30
    Not displaying Choice values from SharePoint List
    No solution in this thread is working.
  • jaanihsm Profile Picture
    jaanihsm 259 on 21 Aug 2024 at 21:29:08
    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 05 Aug 2024 at 08:21:31
    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 12 Jul 2024 at 17:11:22
    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 47 on 22 Aug 2022 at 09:53:24
    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 47 on 19 Aug 2022 at 10:39:19
    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,608 on 19 Aug 2022 at 10:27:32
    Re: Not displaying Choice values from SharePoint List

    Hello,

     

    Put the items property to something similar to this image:

     

    StretchFredrik_0-1660904843350.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

End of Year Newsletter…

End of Year Community Newsletter…

Tuesday Tip #12 Start your Super User…

Welcome to a brand new series, Tuesday Tips…

Tuesday Tip #11 New Opportunities…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 144,696

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,456

Leaderboard
Loading complete