General Question

(0) Share

Report

Posted on by laizcb

Hi,

I attached a picture of my screen explaining my doubt.

I would like to detect When a barcode is duplicated in my Lists CheckFlow in column Digitalizacao do Tubo 1 MO.

Furthermore, I would like a notification to appear accusing duplicity of information 🙂

Please

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Verified answer

rpersad 831 on at

Like
a
(1)

Report
Copy link

Link copied!
Before patching to the CheckFlow list use the LookUp and isBlank function to determine if the barcode is in the list.

If(IsBlank(LookUp(CheckFlow;'Digitalizacao do Tubo 1 MO' = BarcodeScanner1_2.Value; "Digitalizacao do Tubo 1 MO")); Patch(CheckFlow; Defaults(CheckFlow); {'Digitalizacao do Tubo 1 MO':BarcodeScanner1_2.Value};;{'Codigo Grade':BarcodeScanner1_1.Value};; {Data: Now()}); Patch(CheckFlow; 'Digitalizacao do Tubo 1 MO' = BarcodeScanner1_2.Value;{'Digitalizacao do Tubo 1 MO':BarcodeScanner1_2.Value};;{'Codigo Grade':BarcodeScanner1_1.Value};; {Data: Now()})

How the code works is it searches for row that value in the "Digitalizacao do Tubo 1 MO" column and returns the value. Then checks to see if a value is return. If no value is returned then it is a new barcode and will create a new row, else it would update the row

Was this reply helpful? Yes No
laizcb 62 on at

Like
a
(0)

Report
Copy link

Link copied!

What Im doing wrong?

Was this reply helpful? Yes No
rpersad 831 on at

Like
a
(1)

Report
Copy link

Link copied!

Change the comma after Checkflow into a semi-colon. That was a mistake on my end because I believe there is a difference in syntax due to the difference in language.

So in a case where I would use "," you would use ";"
and where I would put a ";" you would use ";;"

Was this reply helpful? Yes No
laizcb 62 on at

Like
a
(0)

Report
Copy link

Link copied!

@rpersad

Thank you so much!

Was this reply helpful? Yes No
laizcb 62 on at

Like
a
(0)

Report
Copy link

Link copied!

its working 🙂

Was this reply helpful? Yes No