Filter a table with existing values in a collection

[Jota90]

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:

• Events (Title, Category*, Employee*) //Employee User Created by
• Categories (Title)
• Employees-Categories(Employee*, Categories*) // The Categories column can select multiple values

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!!!

[Jota90 · Accepted 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