Hi!,
I've searched a lot but can't find a way to do this.
I work with sharepoint lists.
I have the following tables:
I want to filter the Events table based on the Categories assigned to the Employee.
I have tried to do:
1. App.OnStart:
Set(colCategoriesEmployee; Filter('Employee-Categories';Employee.Email = User().Email).Categories)
2. Gallery.Items:
Filter(Events, Category in colEmployeeCategories.Categories)
... also
Filter(Events, Category.Id in colEmployeeCategories.Categories.Id)
... also many other tests but I can't.
Can somebody help me?
Thank you!!!
Solved! Go to Solution.
Hi!, I have found a way that works for me, maybe there are others...
1. App.OnStart
Set(_EmployeeCategories; Concat(First(Filter('Employee-Categories';Employee.Email = User().Email)).Categories;Value;" "))
2. Gallery.Items:
Filter(Events; Category.Value in _EmployeeCategories)
Greetings
Hi!, I have found a way that works for me, maybe there are others...
1. App.OnStart
Set(_EmployeeCategories; Concat(First(Filter('Employee-Categories';Employee.Email = User().Email)).Categories;Value;" "))
2. Gallery.Items:
Filter(Events; Category.Value in _EmployeeCategories)
Greetings