Unanswered

searching multiple columns and more than one thing at a time

(0) Share

Report

Posted on by jose8255

I am currently working on a canvas app that holds inventory for my company but currently when I search in the gallery using the search bar if search by item name it comes up but i would also like to search by location part number. Does anyone have any ideas? currently by default the app has this as the formula for the gallery sortbycolumns(filter([@'engineering Inventory'], startswith(title, textsearchbox1.text)), 'title', if(sortdescending1, descending, ascending))

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (0)

Sort by

NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi,
You can use below formula -
SortByColumns(filter([@'engineering Inventory'], StartsWith(title, textsearchbox1.text) || StartsWith(Location, textsearchbox1.text)), 'title', if(sortdescending1, descending, ascending))

Was this reply helpful? Yes No
jose8255 14 on at

Like
a
(0)

Report
Copy link

Link copied!

no this formula does not work at all the whole thing is lit up

Was this reply helpful? Yes No
NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

what is the error that you are getting ?
Can you please share a screenshot of it

Was this reply helpful? Yes No
jose8255 14 on at

Like
a
(0)

Report
Copy link

Link copied!

here is a pic of the error

Was this reply helpful? Yes No
NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Is Location a choice field, If Yes, the use below formula -
SortByColumns(Filter(AddColumns([@'engineering Inventory'],"LocationCustom", Location.Value), StartsWith(Title, TextSearchBox1.Text) || StartsWith(LocationCustom,TextSearchBox1.Text)), "Title", If(SortDescending1, Descending, Ascending))
If Location is pf type Single line of text, then try below (made some changes in syntax) -
SortByColumns(Filter([@'engineering Inventory'], StartsWith(Title, TextSearchBox1.Text) || StartsWith(Location,TextSearchBox1.Text)), "Title", If(SortDescending1, Descending, Ascending))

Was this reply helpful? Yes No
jose8255 14 on at

Like
a
(0)

Report
Copy link

Link copied!

it is not a choice field its a single line of text and im still getting a error attached is a pic of the error

Was this reply helpful? Yes No
NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Please try the below formula:
SortByColumns(Filter(AddColumns([@'engineering Inventory'],"LocationCustom", Location.Value), StartsWith(Title, TextSearchBox1.Text) || StartsWith(LocationCustom,TextSearchBox1.Text)), "Title", If(SortDescending1, Descending, Ascending))

Was this reply helpful? Yes No
jose8255 14 on at

Like
a
(0)

Report
Copy link

Link copied!

sorry again tons of errors throught the whole formula

Was this reply helpful? Yes No