The Project gallery is filtered by Client.Value, title, AssignedUser.DisplayName & JobTitle | Source Sharepoint List Projects
Txt_Suchfeld_4.Text in Kunde.Value || Txt_Suchfeld_4.Text in Titel || Txt_Suchfeld_4.Text in Mitarbeiter.DisplayName || Txt_Suchfeld_4.Text in Mitarbeiter.JobTitle || Txt_Suchfeld_4.Text in Mitarbeiter.Department
The gallery clients is filtered by title. | Source Sharepoint List Clients
FirstN(Filter(Kunden; Txt_Suchfeld_4.Text in Titel);4)
So but now if i type in a projectname, i want to display in the users gallerys the users who are assigned to the projects results displayed in the projects gallery and in the clients gallery i want to see the clients to whom the projects are tagged to...