Forum Discussion
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...
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.
I just can’t thank you enough for that explanation.