Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Aubrey McKillop]

Hello,

I have an app that has a list of items being pulled from a SQL Table.  I added a new screen with the scanner button and I am looking to see if it is possible to scan the UPC (ItemNumber) and directly go to the edit screen based on the item number scanned.

I have been able to navigate to the screen without issue on the scan but it does not load the proper item.

Thank you for any help.

Aubrey

——————————
Aubrey McKillop
Moncton NB
——————————

[Warren Belz]

HI Aubrey,
What code are you using on the OnScan of the barcode scanner?
Assuming ItemNumber is a unique identifier in your list and your scanner was named BarcodeScanner1, you would do something like this OnScan.

Set(vItem,BarcodeScanner1.Value)?;
Navigate(YourEditScreenName)

Your Item on your edit form would be

Lookup(
   YourSQLTableName,
   ItemNumber=vItem
)

If you also navigate to this screen from a gallery – on the gallery OnSelect

Set(vItem,ThisItem.ItemNumber);
Navigate(YourEditScreenName)

——————————
Warren Belz
Rockhampton Qld Australia
+61 409 315 509
——————————
——————————————-

[Aubrey McKillop]

Hi Warren, 

Thank you so much!  Between your response and one provide by Shane young on his YouTube channel I have been able to make this work.

I was so close …I was trying to do my lookup in the wrong spot.

I now have the app doing what I need.

Thank you!

Aubrey

——————————
Aubrey McKillop
Moncton NB
Canada
——————————
——————————————-