Hello guys,
maybe a rookie problem, but I don't know how I can achieve that.
I have a sharepoint site with around 6-8 Lists filled with different Requests. Lets call them List1/List2/List3 ....
Everylist has a PersonColumn Employee which contains the affected Employee.
Having 6-8 different Gallerys sucks so I had the Idea to combine Every Request in just one Gallery.
So I had no idea how to achieve this. But I made a 'Workaround'. I filled a Dropdown with
[ "List1","List2","List3","List4","List5","List6","List7","List8" ]
And the Gallery Items Property is set to
Switch(Dropdown1.Selected.Value,"List1", Filter(List1, Mitarbeiter.Email = User().Email || 'Created By'.Email = User().Email),"List2", Filter(List2, Mitarbeiter.Email = User().Email || 'Created By'.Email = User().Email), [...AND SO ON AND SO ON UNTIL...], "List8", Filter(List8, Mitarbeiter.Email = User().Email || 'Created By'.Email = User().Email))
The Problem is, the delay is high and the usability sucks.
Has Anyone another Idea how to achieve this, that I can combine those List in one Gallery ( Best would be with an additional column so that the Dropdwon works like a filter but it is not necessary)?
