Answered

Dropdowns show Items 1 to 15 instead of column choices

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have a form with a dropdown (SharePoint list Choice column) that works perfectly fine:
Items = Choices([@'LAR Approval'].LSA)

I needed to add another dropdown to the same form, as well a Choice column, with two options
Items = Choices([@'LAR Approval'].ChargingBasis)

Result: the dropdown shows Items 1 to 15 instead of the available choices in that column.

I created a new screen and a new form, but now all dropdowns in this new form show items 1 to 15, not just the dropdowns bu as well the people picker dropdowns, and even the LSA dropdown which works fine on the original form:

I checked all the properties, they are the same. I refreshed the data source, no change. I tested the SharePoint list, choices and people pickers work as expected. Where do these Item 1 to Item 15 come from? Why doesn't it load the choices?

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Fredrik_A 3,644 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hello,

Please change the following:

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

That's exactly what I have
and it's the same in the working dropdown and in the one that doesn't work.

Was this reply helpful? Yes No
Fredrik_A 3,644 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Well, you need to change the value part to the data you want to show.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

The only option I have is 'Value'

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@StretchFredrik really weird! I created a new app (from the SP list directly, rather than Canvas and adding form and fields), and all the dropdowns worked fine. I checked the properties, and they were all the same as in my Canvas app where the dropdowns didn't work. And to my surprise, now they all worked fine without any further modification in the Canvas app. They simply started working after creating the app from the SP list directly. I didn't even save the new App, and actually deleted it again, and the Canvas app still works fine. And just to confirm, all dropdowns have Value, Value as their primary text and search field, there's nothing that can be changed there.

Was this reply helpful? Yes No