Filter a gallery using a SharePoint list choice column against multiple possible values from a collection in Power Apps

(0) Share

Report

Posted on by Shamim007

I have a case in which a list has a department column (type choice). I want to filter my gallery data using the logged in user's department. However, the same user can belong to multiple departments and that has been saved in another list and the department data for the logged in user is fetched during "OnStart" and saved in variable/collection.

eg: Department column in SharePoint list has choices of [Finance, HR, Admin, Tech, Support] etc. and the logged in user belongs to [Tech, Support].

I have tried saving the user departments as a string using "Concat" and Filtered using Department.Value in departmentString and I have tried using a combination of CountRows, Filter, ForAll but I am still getting delegation issues.

How do I filter my gallery data without facing delegation issues?

Any help will be appreciated.