Forum Discussion

Brass Contributor

Oct 03, 2020

FILTER GALLERY WITH DROPDOWN BY CHOICE FIELD IN SHAREPOINT LIST

Have an app and want to filter data in column that is a "choice" field in SharePoint list. Made a dropdown box where Items = Choices(List.Column). The Dropdown displays all items in that column with...

PowerApps

cblanton

Copper Contributor

Dec 16, 2020

ChrisWebbTech I'm trying to do the same, but I'm getting an error. The intellisense is saying = is an invalid argument.

'Sponsoring Org' is the Choice Field in my list. Intellisense also prompted me to use result instead of value.

Any ideas if there'a a different issue with my list?

Filter('DIA/DRA', 'Sponsoring Org'= ComboBox5.Selected.Result) and
Filter('DIA/DRA', 'Sponsoring Org'= ComboBox5.Selected.Value) both give the error on =

willnow

Copper Contributor

Apr 26, 2021

The schema of a Choice column has two keys, ID (number) and Value (string). Since your Sponsoring Org column is of type Choice, it should be:

'Sponsoring Org'.Value

The reason is you're currently comparing an object to a string and because those data types don't match, that error is expected. Append .Value to your Choice column in your filter and now you're comparing a string to a string.