Unanswered

Not displaying Choice values from SharePoint List

(2) Share

Report

Posted on by ThomFromUoC

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.

Categories:

Building Power Apps

I have the same question (3)

All responses (10)

Answers (1)

StretchFredrik 3,395 Super User 2025 Season 2 on at

Like (3)

Report

Hello,

Put the items property to something similar to this image:

Was this reply helpful? Yes No
ThomFromUoC 49 on at

Like (2)

Report

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

Was this reply helpful? Yes No
Verified answer

ThomFromUoC 49 on at

Like (5)

Report

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

Was this reply helpful? Yes No
MA-21081317-0 23 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
bisaac 4 on at

Like (5)

Report

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?

3 people found this reply helpful.

Was this reply helpful? Yes No
jaanihsm 300 on at

Like (2)

Report

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.

Was this reply helpful? Yes No
aamir 48 on at

Like (1)

Report

No solution in this thread is working.

Was this reply helpful? Yes No
Suggested answer

Paul_2099 38 on at

Like (14)

Report

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

5 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

CamL 12 on at

Like (13)

Report

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

2 people found this reply helpful.

Was this reply helpful? Yes No
VT-25101447-0 4 on at

Like (2)

Report

I had this problem and found deleting the datacards and reinserting was most efficient. Such a pain though. Has worked fine before.

Was this reply helpful? Yes No