For context, I'm working on an action tracking app. Separate screens for the current user's actions, grouped actions of different teams etc with all actions stored as individual records in a sharepoint list.
My issue is that with certain values in my filter, the returned collection is empty even though it should be populated, and I cannot figure it what's causing this.
ClearCollect(Committee_col, Filter('Actions List', Project_or_committee_name = Selected_committee))
As you can see, I am not performing any sort of complex filtering, quite literally just checking if the currently selected project/committee (selected_committee),which is set with a button press, is the same as the value stored in the Project_or_committee_name column. This logic has worked perfectly fine for the last month but isn't now.
For example, some of the committee names include [Tech, Finance, BAU Acquisitions, Swiss Watch] and many more. If I set Selected_committee to "Tech", all relevant records are returned. However if Selected_committee is set to "BAU Acquisitions", my collection is completely empty even though there are records with "BAU Acquisitions" in my sharepoint list.
I've checked, and triple checked all spellings, checked the values being passed to Selected_committee and yet it still only seems to break for a few specific values and work for others but I cannot see any relation between which do and do not work.
I've tried referencing the broken values directly in the filter, copying the exact value from the sharepoint list rather than using Selected_committee, didn't make a difference.
Tried changing the filter to a lookUp to see if it'd return a single value but even that comes back null.
My sharepoint list is at ~800 rows so I thought maybe it'd be an issue with my sharepoint list getting too big, but even with the whole or part of sharepoint list (tested separately) stored locally in a collection I'm still getting a null return from the filter. I know the delegation limit is 500 by default, but I had already changed it to 2000 a while ago. I don't see why that would make any difference, especially since it still didn't work with a local copy of the collection.
Tried in another, completely blank app with the same sharepoint list connected to see if it was being interfered with somewhere else in the app and still got the same result.
Is there something small and obvious that im missing? Cannot for the life of me see why such a simple filter request is causing such an issue so any help would be appreciated.