Forum Discussion

Brass Contributor

Oct 04, 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

ChrisWebbTech

MVP

Oct 04, 2020

Filter(list name, columninlisttofilter = dropdowncontrolname.selected.value)

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 =

Omar_204
Copper Contributor
Apr 20, 2022
THANK YOU SO MUCH!

This was the solution to my problem also. The filtering is working now when user selects their name from the combo box dropdown, the gallery containing the collection of 3 different SharePoint lists) gets filtered only with the items only containing the specific name (chosen from the dropdown)
willnow
Copper Contributor
Apr 27, 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.
- WilliamAzevedo
  Copper Contributor
  Nov 15, 2021
  I just can’t thank you enough for that explanation.