Announcements
I have a SharePoint list that has a 'Status' field in it. The field is of Choice type and only 1 status is allowed to be selected. When I add a dropdown to my app and set the Items property to this field, I keep getting the below error, which I've never encountered before.I've tried throwing the status into a collection and also running a distinct on the field and all code I've tried comes back with that error.Thanks
Try this on your items property of the drop down:
Choices(<SPOListName>.'Status')
SPOListName is the name of the SPO List that you want to use. You can find that under data sources tab.
@Anonymous, thanks for the quick solution. Why is Choices needed in this instance? I've never had to use this before and am unsure what I've done to cause it.
I tried both:
'PC Intake'.Status and Distinct('PC Intake',Status)
Both of those formulas expect the Status column to be a text field.
'PC Intake'.Status
should return all 4 in the drop down. And the distinct formula should just return new and old.
However, in your case, Status is an option list. Those formulas do not work on lookup or option sets or pretty much any nested stuff. Your table is like this:
When you do 'PC Intake'.Status inside Choices, choices takes in the reference to that column. That is, it will literally get the Status Option set. More information here
Perfect, thanks!
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 402 Super User 2026 Season 2
Mohsin Ali 328
WarrenBelz 296 Most Valuable Professional
