TextInput Search Box that I need to filter gallery by Order Number which is a list column

(0) Share

Report

Posted on by Evan_S1

341

I created a search box that I need to filter the gallery by Order Number. Order Number is a list column.

Categories:

Building Power Apps

I have the same question (0)

All responses (19)

Answers (1)

turnerj3 2,039 on at

Like (0)

Report
Copy link

Link copied!

Filter('YourListNameHere','Order Number'=Value(TextInput1.Text))

Was this reply helpful? Yes No
Evan_S1 341 on at

Like (0)

Report
Copy link

Link copied!

where does this function go? the gallery? the search box?

Was this reply helpful? Yes No
turnerj3 2,039 on at

Like (0)

Report
Copy link

Link copied!

Gallery Items Property

Was this reply helpful? Yes No
Evan_S1 341 on at

Like (0)

Report
Copy link

Link copied!

This is what I have and my whole gallery went black.
Filter('Production Stoppage - DRAFT 1','Order No'=Value(SearchBox_2.Text))

My Information is below
List is named: Production Stoppage - DRAFT 1
List column is: Order No (Which is input by text)
Search box name is: SearchBox_2

Was this reply helpful? Yes No
turnerj3 2,039 on at

Like (0)

Report
Copy link

Link copied!

Are there any errors?
What did you enter in the SearchBox?
If the order no is not a number you can take the Value() out and just try SearchBox_2.Text

Was this reply helpful? Yes No
Evan_S1 341 on at

Like (0)

Report
Copy link

Link copied!

this is what it looks like now.

Was this reply helpful? Yes No
turnerj3 2,039 on at

Like (0)

Report
Copy link

Link copied!

Show me the whole code for your gallery. It should just be the filter.

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Evan_S1,

Have you solved your problem?

Actually, if the you just input something key words in search box, you need to use the "in" instead of the "=":

Filter('Production Stoppage - DRAFT 1','Order No' in SearchBox_2.Text)

If this does not work either, please do post the complete formula in the Items property of the Gallery.

Was this reply helpful? Yes No
Evan_S1 341 on at

Like (0)

Report
Copy link

Link copied!

Here is my code below.

Switch(
btnChoice,
Vertical,
Filter('Production Stoppage - DRAFT 1', "Vertical" in Area.Value),
Modified,
Filter('Production Stoppage - DRAFT 1', "Modified" in Area.Value),
'Quick Ship',
Filter('Production Stoppage - DRAFT 1', "Quick Ship" in Area.Value),
Machining,
Filter('Production Stoppage - DRAFT 1', "Machining" in Area.Value),
Repairs,
Filter('Production Stoppage - DRAFT 1', "Repair" in Area.Value),
Horizontal,
Filter('Production Stoppage - DRAFT 1', "Horizontal" in Area.Value),
Shipping,
Filter('Production Stoppage - DRAFT 1', "Shipping/Receiving" in Area.Value),
'Material Handling',
Filter('Production Stoppage - DRAFT 1', "Material Handling" in Area.Value),
'Paint Booth',
Filter('Production Stoppage - DRAFT 1', "Paint Booth" in Area.Value),
ORE,
Filter('Production Stoppage - DRAFT 1', "ORE" in Responsible.Value),
Logistics,
Filter('Production Stoppage - DRAFT 1', "Logistics" in Responsible.Value),
Purchasing,
Filter('Production Stoppage - DRAFT 1', "Purchasing" in Responsible.Value),
Quality,
Filter('Production Stoppage - DRAFT 1', "Quality" in Responsible.Value),
'Production Stoppage - DRAFT 1'
); Filter('Production Stoppage - DRAFT 1','Order No'=Value(SearchBox_2.Text))

Was this reply helpful? Yes No
Evan_S1 341 on at

Like (0)

Report
Copy link

Link copied!

This is my code below. Am I just putting it in the wrong format? The gallery still goes blank when I try to add the search box filter.

Switch(
btnChoice,
Vertical,
Filter('Production Stoppage - DRAFT 1', "Vertical" in Area.Value),
Modified,
Filter('Production Stoppage - DRAFT 1', "Modified" in Area.Value),
'Quick Ship',
Filter('Production Stoppage - DRAFT 1', "Quick Ship" in Area.Value),
Machining,
Filter('Production Stoppage - DRAFT 1', "Machining" in Area.Value),
Repairs,
Filter('Production Stoppage - DRAFT 1', "Repair" in Area.Value),
Horizontal,
Filter('Production Stoppage - DRAFT 1', "Horizontal" in Area.Value),
Shipping,
Filter('Production Stoppage - DRAFT 1', "Shipping/Receiving" in Area.Value),
'Material Handling',
Filter('Production Stoppage - DRAFT 1', "Material Handling" in Area.Value),
'Paint Booth',
Filter('Production Stoppage - DRAFT 1', "Paint Booth" in Area.Value),
ORE,
Filter('Production Stoppage - DRAFT 1', "ORE" in Responsible.Value),
Logistics,
Filter('Production Stoppage - DRAFT 1', "Logistics" in Responsible.Value),
Purchasing,
Filter('Production Stoppage - DRAFT 1', "Purchasing" in Responsible.Value),
Quality,
Filter('Production Stoppage - DRAFT 1', "Quality" in Responsible.Value),
'Production Stoppage - DRAFT 1'
); Filter('Production Stoppage - DRAFT 1','Order No' in SearchBox_2.Text)

Was this reply helpful? Yes No