Filter a share point list by another list in power apps

60 views Asked by At

I've organized a list that includes a 'Person' column with details such as 'Employee' and 'EmployeeId'

enter image description here

Additionally, I have another list that captures 'EmployeeId' and their corresponding technological expertise. This creates a many-to-many relationship between employees and technologies.

enter image description here

In the context of a Power App, I'm aiming to create a search functionality where users can filter employees based on both their names and technological expertise. Could you guide me on how to effectively implement this search using the information from these two interconnected lists?

This is a preview of the current application

enter image description here

This is the current filter I use to filter employee by their names. It's working correctly.

Filter(
    Skills,
    Or(
        StartsWith(
            Employee.DisplayName,
            SearchInput1.Text
        )
    )
)
0

There are 0 answers