Answered

Search Gallery with barcode scanner

Like (0) Share

Report

Posted on 3 Aug 2022 13:50:55 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:

General Questions

Using Apps Using Formulas

All responses (8)

Answers (1)

Verified answer

emartinez 15 on 03 Aug 2022 at 16:51:57

Like (0)

Report

Re: Search Gallery with barcode scanner

@SebS

I solved my issue! I was just overthinking.
SebS 4,146 Super User 2025 Season 1 on 03 Aug 2022 at 15:39:13

Like (0)

Report
Re: Search Gallery with barcode scanner

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 )
SebS 4,146 Super User 2025 Season 1 on 03 Aug 2022 at 15:28:39

Like (0)

Report
Re: Search Gallery with barcode scanner

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
emartinez 15 on 03 Aug 2022 at 15:14:13

Like (0)

Report

Re: Search Gallery with barcode scanner

@seb

Yes it does work. It will work when i search by "title" it will not work when i search by "BIN LOCATION"
SebS 4,146 Super User 2025 Season 1 on 03 Aug 2022 at 15:10:10

Like (0)

Report

Re: Search Gallery with barcode scanner

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
emartinez 15 on 03 Aug 2022 at 15:02:53

Like (0)

Report
Re: Search Gallery with barcode scanner

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 ) )
emartinez 15 on 03 Aug 2022 at 14:54:31

Like (0)

Report

Re: Search Gallery with barcode scanner

It did not Work. 😞

Browse gallery formula
TextSearchBox

Scan button is a stand alone just positioned on top of the the TextSearchBox
SebS 4,146 Super User 2025 Season 1 on 03 Aug 2022 at 14:05:48

Like (0)

Report
Re: Search Gallery with barcode scanner

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