CODEWITHSUNDEEP
sharepointsharepoint-onlinepowerappspowerapps-canvaspowerapps-formula
Hash_Dew
Hash_Dew

Reputation: 503

Search persons by SharePoint lookup column values in Power Apps

I have a SharePoint list and it has a lookup column called "Skills" that can save multiple values and a person column which stores Microsoft 365 users.

This SharePoint list is connected to canvas Power Apps. I need to implement a feature that can filter persons by searching the skills.

How to implement this?

This is a preview of my SharePoint list:

enter image description here

This is a preview of my canvas Power Apps:

enter image description here

This is the current search formula to search by person name.

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

Upvotes: 0

Views: 703

Answers (1)

Sam Nseir
Sam Nseir

Reputation: 12111

Filter(
    Skills,
    Or(
        StartsWith(
            Employee.DisplayName,
            SearchInput1.Text
        ),
       CountRows(
        Filter(Skill, StartsWith(Value, SearchInput1.Text) )
       ) > 0
    )
)

Upvotes: 1

Related Questions