Notify

(0) Share

Report

Posted on by DHAGZ

162

Good day asking for help.

How to fix this my formula:

If(BarcodeScanner2_2.Value = "","",

If(BarcodeScanner2_2.Value <> LookUp(SPList, ID = BarcodeScanner2_2.Value,ID), "No record found",
If(BarcodeScanner2_2.Value = LookUp(SPList, ID = BarcodeScanner2_2.Value,ID), "Already Regestered", "Thank You!")))

Scenario:

What I want to do is when the QR code is scanned when the ID is not recorded in the SP LIST, "No record found" should appear.

What formula should be changed?

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@DHAGZ ,

The LookUp function returns a List item so you need to specify what column you want to retrieve. Try,

If(BarcodeScanner2_2.Value = "","",

If(BarcodeScanner2_2.Value <> LookUp(SPList, ID = BarcodeScanner2_2.Value).ID, "No record found",
If(BarcodeScanner2_2.Value = LookUp(SPList, ID = BarcodeScanner2_2.Value).ID, "Already Regestered", "Thank You!")))

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @DHAGZ,

Modify your formula as below:

If(BarcodeScanner2_2.Value = "","", If(BarcodeScanner2_2.Value <>Text( LookUp(SPList, Text(ID) = BarcodeScanner2_2.Value).ID), "No record found", "Already Registered, Thank You!"))

I assume that the VarcodeScanner2_2.Value returns a text value, so I use Text() to convert the ID number value to text so that we could compare.

Was this reply helpful? Yes No