web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Search by multiple col...

Power Apps

Answered

Search by multiple columns in SharePoint

(0) Share

Report

Report

Posted on by aborder

28

I have a very basic canvas app connected to sharepoint list. I am showing items in Gallery.

There is search box automatically created when connected to sharepoint. It is searching data in only one column "EmployeeName". Now I want to search by two columns (EmployeeName & EmployeeTitle) using single search box. How to achieve this?

My current formula: SortByColumns(Filter([@TestList], StartsWith(EmployeeName, TextSearchBox1.Text)), "ID", If(SortDescending1, Descending, Ascending))

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

ganeshsanap 1,555 on at

Like
a
(1)

Report
Copy link

Link copied!
@aborder Try using below formula in items property of your Gallery control:

SortByColumns( Filter( [@TestList], StartsWith(EmployeeName, TextSearchBox1.Text) || StartsWith(EmployeeTitle, TextSearchBox1.Text) ), "ID", If(SortDescending1, Descending, Ascending) )

Please click Accept as solution & ‌‌👍 if my answer helped you to solve your issue. This will help others to find the correct solution easily. If the answer was useful in other ways, please consider giving it ‌‌👍

Best Regards,

Ganesh Sanap

Blog site
aborder 28 on at

Like
a
(1)

Report
Copy link

Link copied!

@ganeshsanap Thank you for quick response

Join the conversation