cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper V
Helper V

Dropdown error

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.
long error.png

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Continued Contributor
Continued Contributor

Re: Dropdown error

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. 

View solution in original post

6 REPLIES 6
Highlighted
Continued Contributor
Continued Contributor

Re: Dropdown error

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. 

View solution in original post

Highlighted
Helper V
Helper V

Re: Dropdown error

@ZabiBabar, 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.

Highlighted
Continued Contributor
Continued Contributor

Re: Dropdown error

Can I see what formula you were using that was giving you the error you mentioned in the OP?
Highlighted
Helper V
Helper V

Re: Dropdown error

I tried both:

'PC Intake'.Status
and
Distinct('PC Intake',Status)
Highlighted
Continued Contributor
Continued Contributor

Re: Dropdown error

Both of those formulas expect the Status column to be a text field. 

Item(int)Status(text)
0New
1Old
2New
3Old

 

 

'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: 

Item(int)Status(Option)
0[New Option]
1[Old Option]

 

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

Highlighted
Helper V
Helper V

Re: Dropdown error

Perfect, thanks!

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Robotic Process Automation

Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (6,331)