Share
ReportI have built a shop app containing a gallery view of all available items. The items are stored in a Sharepoint list.
In the SP List, i have a column called 'Department', in which I have comma-separated values, such as "Sales, Warehouse, All"
I want to filter the gallery view based on the persons Department (which I get from Office365Users connection).
How would i go about using Filter() to do this?
I started with this:
Filter(
'Shop Items', ThisRecord.Dept = Office365Users.MyProfileV2().department
)
This almost gives me what I want, but only if there is one value in the Department column, if there are multiple values, then I guess I need to change this to say 'Contains' but I don't know how to do that.
With the above, I also get delegation warnings and also don't know how I would include any items that have "all" in the Department column.
Any suggestions please?
All responses (
Answers (
11,128
