Answered

Searching a nonexistant or blank collection

(0) Share

Report

Posted on by TheHockeyGeek

I have an app that is scanning barcode numbers into a collection and looking up data. Where I'm stuck is on the first item. How can you search a "Code" column on the first scan if the collection has not added the first item yet.

I've tried doing ClearCollect(colScannedStuff, Blank()), but is there a way to get a named column to search but the collection still be empty? Or is there a better way to go?

The goal is to take scans of additional of the same items and increment a quantity rather than duplicate the line. Prior to Collecting, do a lookup to see if it's there already. If so, add to the quantity column.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

AnthonyD 559 on at

Like (1)

Report
Copy link

Link copied!
I would do the following:

Initiate a collection colScannedStuff with ClearCollect(colScannedStuff, Blank()) onStart of your app.

Then later use the following code to add items to the collection if they don't exist. Or update the quantity if they do exist.
If( !IsBlank(colScannedStuff) And !IsBlank( LookUp( colScannedStuff, Barcode = Scanner.Text ) ), Patch( colScannedStuff, LookUp( colScannedStuff, Barcode = Scanner.Text ), { Barcode: Scanner.Text, Quantity: LookUp( colScannedStuff, Barcode = Scanner.Text ).Quantity + 1 } ), Collect( colScannedStuff, { Barcode: Scanner.Text, Quantity: 1 } ) )

Please accept this answer as a solution if this answer solved your question.

Best Regards,
Anthony

Was this reply helpful? Yes No
TheHockeyGeek 18 on at

Like (1)

Report
Copy link

Link copied!
I was close! I had to add the additional !IsBlank and the
Quantity: LookUp( colScannedStuff, Barcode = Scanner.Text ).Quantity + 1
was formatted wrong. I didn't have the lookup for Quantity. Thanks!

Was this reply helpful? Yes No