Answered

Searching multiple columns

(2) Share

Report

Posted on by JC-18030151-0

Hi, I have used this forum before and thanks for your responses. In my powerapp, I am trying to search more than one field in the gallery. The text box has the following item function:

SortByColumns(Filter([@MCN_Plants5], StartsWith(Species, TextSearchBox1.Text)) , "Title", If(SortDescending1, SortOrder.Descending, SortOrder.Ascending))
 
What formula do I use to search for another field entitled 'Çommon Name' without delegation warning please?
 
Thanks,
 
John.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (2)

Sort by

Verified answer

WarrenBelz 155,838 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @JC-18030151-0,

Assuming you are using the same search box
SortByColumns( Filter( [@MCN_Plants5], StartsWith( Species, TextSearchBox1.Text ) || StartsWith( 'Çommon Name', TextSearchBox1.Text ) ), "Title", If( SortDescending1, SortOrder.Descending, SortOrder.Ascending ) )

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
Suggested answer

11manish 3,333 on at

Like
a
(0)

Report
Copy link

Link copied!

You can also try below :

Sort(
Search(
[@MCN_Plants5],
TextSearchBox1.Text,
"Species",
"Common Name"
),
Title,
If(SortDescending1, Descending, Ascending)
)

Was this reply helpful? Yes No
Verified answer

oyepanky 537 on at

Like
a
(2)

Report
Copy link

Link copied!
Hi @JC-18030151-0

To search multiple fields without a delegation warning, you can extend your Filter + StartsWith like this.

SortByColumns( Filter( [@MCN_Plants5], StartsWith(Species, TextSearchBox1.Text) || StartsWith('Common Name', TextSearchBox1.Text) ), "Title", If(SortDescending1, SortOrder.Descending, SortOrder.Ascending) )

Pankaj J
24/7 Support Free
Power Platform Developer
📧 Oyepanky@gmail.com
📞 +91 9315839512
🎥 https://www.youtube.com/@oyepanky

Was this reply helpful? Yes No