Answered

Filter Gallery by Barcode Scanner And/Or Search box.

(0) Share

Report

Posted on by Community Power Pla...

I have figured out how to filter my Gallery by both the Barcode Scanner and the Search Box, but I don't know how to write a formula for the Gallery that will allow me to do both.

Barcode Scan Method:

Scanner --> OnScan = Set(V1,BarcodeScanner1.Value)

Gallery --> Items = Filter(Table2,'Alias Item Number'=V1)

Search Box Method:

Gallery --> Filter(Table2,StartsWith(Alias Item Number,SearchBox.Text))

I'm sure this is an easy fix, but I am not very familiar with the PowerApps syntax

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

zmorek 3,272 on at

Like (1)

Report

If understand right, you want the gallery to filter by the Barcode Scan (if something was scanned), then if nothing was scanned, filter by the search box?

The gallery's Items property could be something like:

If(
IsBlank(SearchBox.Text),
Filter(
Table2,'Alias Item Number' =V1
),
Filter(
Table2,StartsWith('Alias Item Number', SearchBox.Text
)
)

I'm not really sure you need the "StartsWith" as part of your search, but that could work just fine. You'll want to ensure that you have a way to clear either/both of V1 and the SearchBox (to avoid someone scanning something then trying to use the search box, or vice-versa).

Let me know if I misunderstood/if I was close!

Edit: I'm unsure if you'll run into delegation issues after sometime, but that's another story.

Was this reply helpful? Yes No
v-albai-msft on at

Like (0)

Report

Hi @Anonymous ,
I just provided my solution in another thread you post before. You can refer to my answer there. If you still have any question about this requirement, don't hesitate to ask me:
Scan Barcode and/or Search Filter - Power Platform Community (microsoft.com)
Best regards,
Allen

Was this reply helpful? Yes No