Unanswered

Search Gallery with barcode scanner

(0) Share

Report

Posted on by emartinez

I seem to be having issues configuring my search bar within my BrowseGallery to search for "BIN LOCATION" or by "Title" when I type in the search text. Or to use the scan button to input text in the search bar so that I can filter my gallery to only pull what is located within that bin.

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

SebS 4,582 Moderator on at

Like (0)

Report
Hello @emartinez,

I see You created already variable I'm assuming it's in Property OnScan of the Scanning component button.

Try now to place in Default property of Your Search Box what I'm assuming is Text Input

If( !IsBalnk(varItem), varItem, "")

If you scan something Your variable will have value and the value will show up in search box if not it will depend on user input.

Hope it helps

Was this reply helpful? Yes No
emartinez 15 on at

Like (0)

Report

It did not Work. 😞

Browse gallery formula
TextSearchBox

Scan button is a stand alone just positioned on top of the the TextSearchBox

Was this reply helpful? Yes No
emartinez 15 on at

Like (0)

Report
I tried to follow this Topic Thread but I keep getting an error and I can't seem to find what I am missing.

https://powerusers.microsoft.com/t5/Building-Power-Apps/How-to-filter-gallery-from-QR-scanner-button/m-p/1293476#M338494

SortByColumns( Filter( [@'Secure Room Inventory'], StartsWith( Title, TextSearchBox1.Text ) && ( IsBlank(scanValue) || YourBarCodeField = scanValue ) ), "Title", If( SortDescending1, Descending, Ascending ) )

Was this reply helpful? Yes No
SebS 4,582 Moderator on at

Like (0)

Report

Hi @emartinez,

Just to confirm currently even if You type Item Code by hand to Search Box the gallery is not filtering ?
I was assuming Your search Box is working so I never focused on your Filter formula 🙂

Regards

Was this reply helpful? Yes No
emartinez 15 on at

Like (0)

Report

@seb

Yes it does work. It will work when i search by "title" it will not work when i search by "BIN LOCATION"

Was this reply helpful? Yes No
SebS 4,582 Moderator on at

Like (0)

Report
Hi @emartinez,

Ok I'm Assuming the column holding the scanned barcode is calling "BIN LOCATION"

SortByColumns( Filter( [@'1225 Consumable Inventory'], StartsWith( Title, TextSearchBox1.Text ) && ( IsBlank(varItem) || 'BIN LOCATION' = varItem ) ), "Title", If( SortDescending1, Descending, Ascending ) )

Try code above check if it filter when You type Title manually and than when You Scan

Regards

Was this reply helpful? Yes No
SebS 4,582 Moderator on at

Like (0)

Report
Personally I will go with this on start :

Filter( '1225 Consumable Inventory', IsBlank(varItem) || IsEmpty(varItem) || 'BIN LOCATION' = varItem, IsBlank(TextSearchBox1.text) || IsEmpty(TextSearchBox1.text) || StartsWith( Title, TextSearchBox1.text )

Was this reply helpful? Yes No
Verified answer

emartinez 15 on at

Like (0)

Report

@SebS

I solved my issue! I was just overthinking.

Was this reply helpful? Yes No