I have a SharePoint list that I am connected to in my PowerApp. I am creating a gallery based on that list data when the app initially loads and would like to filter that out based on data that is in a Choice field. The choice field is set to allow multiple values and that is what is causing me problems. How are we able to filter the gallery based on that field? Using the Filter, it is throwing an Invalid Argument on the = sign. I have tried Search and that doesn't bring back the results as I would expect.
Is there a different way for me to filter that info? Is there a way to do a Contains to filter out the data?
Here is my current formula that is not working: ClearCollect(colARFStatus, Filter('ARF Status', Nameplate.Value="Order Monday"), SortByColumns('ARF Status', "Created", Descending)).
