Answered

Inventory management with Barcode

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi guys,

I'm struggling to finish this function in PowerApps and I need your help. Basically, when I use the scan function for Inventory Management app, if the code exists in SharePoint List, it will be navigated to the Product Details page. If not, it will show a new EditForm for users to add a new product. Here is the screenshot of the Homepage, the function to show the existing product works well, however for the nonexisting product, I don't know how to navigate that.

Home screen

Here is my OnScan function: Set(TheRecord, LookUp('Capella Asset Management', Barcode = BarcodeScanner4.Value)); Navigate(product_details, ScreenTransition.Cover)

Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (2)

Sort by

Verified answer

BCBuizer 22,833 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Anonymous,

I guess you need to build in a scenario where BarcodeScanner4.Value is not in 'Capella Asset Management':

If( IsEmpty( LookUp('Capella Asset Management', Barcode = BarcodeScanner4.Value ), Notify( "This barcode is not found", NotificationType.Error, 5000 ), Set( TheRecord, LookUp( 'Capella Asset Management', Barcode = BarcodeScanner4.Value ) ); Navigate( product_details, ScreenTransition.Cover ) )

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

Like
a
(0)

Report
Copy link

Link copied!

Thanks for responding so quickly, appreciated that. I just want to ask where can I put this function? In the OnScan or the search box? Thanks a lot!!

Was this reply helpful? Yes No
Verified answer

BCBuizer 22,833 Super User 2026 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!

Hi @Anonymous ,

This code is written to replace the code you posted, so for the OnScan property.

Was this reply helpful? Yes No