I am looking to create a small inventory app. I need to scan a single barcode for the location of the items and then do a scan collection for every barcode item in that location.
I need this information to be loaded to a sharepoint list. Is there a way to do this? Basically the sharepoint list should be like the attached picture.
I also attached a picture of how I would like the app to sort of be (not formatted yet though)
Any help would be appreciated
Solved! Go to Solution.
While your solution was not exactly what I needed, it did help me solve my issues. I used 2 barcode scanners. One i set a variable for a single scan. Then I used a 2nd barcode scanner to scan and load with the Patch formula.
Patch(ShippingLocations_1, {Title: BarcodeScanner1.Value, AssemblyScan: BarcodeScanner3.Value})
Hi @eaf3 ,
I would suggest that you could create one new item to SharePoint at one time in PowerApps.
You could create the app like we normally do, just use the auto-generated app from Start from data > SharePoint.
Then in the edit form control, unlock the 2 data cards for these 2 columns, and insert 2 barcode-scranner controls. For the 2 textinput controls, set the Default property of the textinput controls to:
Barcode1.Value
and
Barcode2.Value
Then set the Update property of these 2 data cards to:
TextInput1.Text
and
TextInput1.Text
I assume that both columns are text columns.
Regards,
Mona
I really wanted to be able to have a one to many situation. Scan one item (location) and all the items in that location with one go. But if there is not a way to do it.... I guess it will be one scan to one scan.
While your solution was not exactly what I needed, it did help me solve my issues. I used 2 barcode scanners. One i set a variable for a single scan. Then I used a 2nd barcode scanner to scan and load with the Patch formula.
Patch(ShippingLocations_1, {Title: BarcodeScanner1.Value, AssemblyScan: BarcodeScanner3.Value})
User | Count |
---|---|
194 | |
127 | |
88 | |
48 | |
42 |
User | Count |
---|---|
279 | |
162 | |
136 | |
81 | |
78 |