Unanswered

Using barcode scanner with a lookup dataverse field

(0) Share

Report

Posted on by sam-L

Hello,

I'm building an app that is used as a cash bag tracker in my workplace. I've set up some dataverse tables for 'bags', 'bag_movements' and 'bag_locations'.

I've got one screen that logs the bag and the bag_movements table that is transactional and updates when the bag is scanned and changes locations. However, I can't put the concept of this into practice. The serial number field of the bag from the bag table that is related to the serial number field in my bag_movements is set to be a lookup field in dataverse. I'm trying to use this field from the bag_movements table in my form in PowerApps and populate the dropdown by using a barcode scanner. I can get the barcode scanner to work into a standard text/number field, but not a dropdown lookup field.

Any helpers with this please?

Thank you in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

BCBuizer 22,505 Super User 2025 Season 2 on at

Like (0)

Report

Hi @sam-L ,

Instead of using the serial number field in the bag_movements table to populate the dropdown, use the serial number field from the bags table.

If this doesn't answer your question, can you please share what you currently have and is not working?

Was this reply helpful? Yes No
sam-L 9 on at

Like (0)

Report

Thanks @BCBuizer, I've added the serial number from the bags form and the barcode scanner is populating this fine. However, I need to commit that value to the bag_movements table so that we can see the serial number of the bag that has moved locations. How would I go about using the save button to commit both forms to one table? Or is there a different way that this should be done? Thank you

Was this reply helpful? Yes No
BCBuizer 22,505 Super User 2025 Season 2 on at

Like (0)

Report
Hi @sam-L ,

What is the BagsForm for? Within the context of the "Log a Movement" screen that seems out of place.

However, if there's a need to submit two forms with the click of a single button, that can be easily accomplished by including both forms in the OnSelect property of the SaveButton:

SubmitForm(BagsForm); SubmitForm(BagMovementsForm);

Was this reply helpful? Yes No