web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Struggling with search...

Power Apps

Answered

Struggling with search function

(0) Share

Report

Report

Posted on by renatobessa

12

Hi,

I spent a whole day trying to make a search input with multiple columns but I'm not able to do it.

I have a gallery linked to a SharePoint list, where I have the columns Name(Person), Old(text) and New(text).

I'm able to search the DisplayName for the Name column using this code:

Search(AddColumns(database,"DisplayName",Name.DisplayName), SearchBox.Text, "DisplayName")

How can I improve this code to be able to search also for the content on the Old and New columns?

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

LaurensM 12,516 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @renatobessa,

Search() can accept additional columns as optional parameters - the function expects Text columns which is why the addcolumns was necessary.

Search( AddColumns(database,"DisplayName",Name.DisplayName), SearchBox.Text, "DisplayName", "Old", "New" )

Do note that this function is not delegable for SharePoint and will not work as expected with list exceeding your Data Row Limit (see app settings, default 500 - Max 2000).

Should "Old" or "New" give errors, the naming of those columns may be incorrect. Use your original code and write a comma after "DisplayName" -> Power Apps will show a list of viable columns.

If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.

Thanks!
renatobessa 12 on at

Like
a
(0)

Report
Copy link

Link copied!

Worked like a charm, that tip to write a comma after the "DisplayName" was amazing!

Thank you

Join the conversation