Answered

check if a gallery has data

(0) Share

Report

Posted on by joef

HI All,

I have a barcode scanner on my app, after I scan, I load a variable, to hold the barcode. I have a gallery that will pull the data from my SPO list that matches the Barcode.

Is there a way to check if the barcode exists? I would like to popup a message "Bar Not Found".

I have an HTML text box that is visible when "VarshowEmptyBar" = true

The "On Scan" property is set to:

Set(VarBarcode, BarcodeScanner2.Value); // gallery Items are based on this variable...

If(CountRows(BrowseGallery_Lookup.AllItems) = 0, UpdateContext({VarshowEmptyBar:true}),UpdateContext({VarshowEmptyBar:false}))

I am having an issue, when I scan, I get the message pop up, regardless of weather the barcode is there or not. If the bar exists, the data comes back, but so does the popup.

Does anyone know how to avoid the popup if there is a match?

It almost seems like I need a delay after I scan. The check seems to fire off before the data comes back.

Thanks,

Joe

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (2)

Sort by

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I created a test using your code that is working. What is the Items property of your gallery set to?

Was this reply helpful? Yes No
joef on at

Like
a
(0)

Report
Copy link

Link copied!

HI @Anonymous,
That's weird, Every time I do the first scan I get the popup, then the data comes thru a second later..

My gallery Items are set to:
Filter('Mail Room APP', (Barcode=VarBarcode))

Thanks,
Joe

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Try using this in your OnSelect
Set(VarBarcode, BarcodeScanner2.Value); If(CountRows(Filter('Mail Room APP', (Barcode=VarBarcode))) = 0, UpdateContext({VarshowEmptyBar:true}),UpdateContext({VarshowEmptyBar:false}))

Was this reply helpful? Yes No
joef on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you @Anonymous ...

That was it, but I am getting a delegation warning.. Is there a way to get rid of that?

Joe

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Try using Lookup() instead of Filter() in the OnScan property. Since you're using CountRows() all you care about is if there is 0 or more than 0. Lookup() will only return one row, so CountRows() will either equal 0 or 1.

Was this reply helpful? Yes No
joef on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ,
this causes an error

Set(VarBarcode, BarcodeScanner2.Value); If(CountRows(Lookup('Mail Room APP', (Barcode=VarBarcode))) = 0, UpdateContext({VarshowEmptyBar:true}),UpdateContext({VarshowEmptyBar:false}))

CountRows has some invalid arguments...

Joe

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Try this
Set(VarBarcode, BarcodeScanner2.Value); If(CountRows(Lookup('Mail Room APP', (Barcode=VarBarcode)).Barcode) = 0, UpdateContext({VarshowEmptyBar:true}),UpdateContext({VarshowEmptyBar:false}))

Was this reply helpful? Yes No
joef on at

Like
a
(0)

Report
Copy link

Link copied!

hi @Anonymous ,
I added the .Barcode to the Filter and all is good no more delegation warning, and it works perfectly!!

The lookup kept giving me the same error about CountRows having invalid parameters.

Thanks Again!!

Joe

Was this reply helpful? Yes No