I've organized a list that includes a 'Person' column with details such as 'Employee' and 'EmployeeId'
Additionally, I have another list that captures 'EmployeeId' and their corresponding technological expertise. This creates a many-to-many relationship between employees and technologies.
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
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
)
)
)