Hi!
I´m creating an Inventory app where the users gonna scan multiple (bulk) serialnumbers and QR Inventory codes.
I also have connected a Gallery to the sharepointlist where they can choose some options for the scans like:
Computer model
Customer
Status and so on.
I have managed to make a single scan where im scanning serialnumber and Inventory-ID
->SubmitForm(Form1) + NewForm(Form1)
See pictures:
This works well.
I have also created a multiple scan page where I want to scan multiple serialnumbers and qr codes where I have the same form with model, customer, status and so on. I then want to upload this bulk to sharepoint online list where they all will be unique objects with a serialnumber and qr inventory code attached with the formsoptions.
I have created a gallery so I can scan multiple serial and qr codes without any issues. Its just when i try to upload it will not work.
Can anyone help me out wit this?
I have tried two different codes so far without any luck:
1) Patch('Funktions-PC'; {Serienummer: Title2; 'Inventarie-ID': Title4; Inventarietyp: DataCardValue11; Modell: DataCardValue12; Kund: DataCardValue13})
Error: Object must implement IConvertible
2) Patch('Funktions-PC'; {Serienummer: Title2; 'Inventarie-ID': Title4 & SubmitForm(Form2) + NewForm(Form2)})
Error: Customer must contain info or something like that. (I have choosen a customer in dropdown)
Thx in advance!
Solved! Go to Solution.
Here are the steps for saving multiple records from gallery and using the form to set the common fields for the batch -
ForAll(
collectMultiScan,
Patch(
Inventory,
Defaults(Inventory),
{
Title: DataCardValue11.Text,
Type1: DataCardValue12.Selected,
Model1: DataCardValue13.Selected,
SerialNumber: ThisRecord.BarcodeInfo
}
)
)
5. Verify that the records are created in the target list
Attached gif has the demo .
thanks,
Hemant
Would it be possible for you to share the complete app , I can try to repro and understand whats the gap here ?
You can send me an email if a quick meeting will be helpful .
hemant
Hi!
I have sent you an email with info and the app.
Thx for taking time!
Here are the steps for saving multiple records from gallery and using the form to set the common fields for the batch -
ForAll(
collectMultiScan,
Patch(
Inventory,
Defaults(Inventory),
{
Title: DataCardValue11.Text,
Type1: DataCardValue12.Selected,
Model1: DataCardValue13.Selected,
SerialNumber: ThisRecord.BarcodeInfo
}
)
)
5. Verify that the records are created in the target list
Attached gif has the demo .
thanks,
Hemant
Hi! My app works perfect know, many thanks for your great approach and educational support with this!
This helped me alot and i´m forever thankfull!
Merry xmas and happy new year @HemantG !!! 🙂
User | Count |
---|---|
4 | |
1 | |
1 | |
1 | |
1 |
User | Count |
---|---|
5 | |
5 | |
3 | |
2 | |
1 |