Answered

Barcode Scanner

(0) Share

Report

Posted on by SOng8

Hi,

I'm designing Power App to scan WOID. Before patching into Table 1, it needs to look up Column WOID to ensure no duplication. The formula (attached below) doesn't seem to be working correctly. Any help and advise would be very much appreciated.

Thanks.

If(
IsBlank(
LookUp(
Table1,
WOID = BarcodeScanner6.Text
)
),
Navigate(
Error,
ScreenTransition.None
),
Navigate(
Successful,
ScreenTransition.None
);
Patch(
Table1,
Defaults(Table1),
{
Activity: "WO Collection",
WOID: BarcodeScanner6.Text,
Timestamp: Now(),
Username: User().FullName
}
)
)

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

timl 37,331 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @SOng8

Can you clarify what isn't working here?

Is it not finding the record in Table1 and navigating you to the error screen, or is it not patching the record correctly?
SOng8 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Tim,

Thanks for the quick respond.
The lookup isn't working, it doesnt respond correctly to Navigate accordingly. The patch is working well, I have removed other logic to test just the patch.
Verified answer

timl 37,331 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @SOng8

Isn't the logic here just the wrong way round? If the result of the lookup is blank (ie, there isn't a record that matches the WOID value in table 1, you want to patch a new record?

I would also recommend that you patch the new record before navigating to 'successful' screen.

If(IsBlank(LookUp(Table1, WOID = BarcodeScanner6.Text ) ), Patch(Table1, Defaults(Table1), { Activity: "WO Collection", WOID: BarcodeScanner6.Text, Timestamp: Now(), Username: User().FullName } ); Navigate(Successful,ScreenTransition.None), Navigate(Error,ScreenTransition.None) )
SOng8 6 on at

Like
a
(0)

Report
Copy link

Link copied!

hi @timl ,

You are right, problem is resolved.

Thank you.