Inventory app, Multiple barcodescan upload to SharePoint list

(0) Share

Report

Posted on by Community Power Pla...

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!

Categories:

Power Apps Pro Dev & ISV

error.PNG

I have the same question (0)

All responses (4)

Answers (1)

Hemant Gaur on at

Like (0)

Report

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

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

Like (0)

Report

Hi!
I have sent you an email with info and the app.

Thx for taking time!

Was this reply helpful? Yes No
Verified answer

Hemant Gaur on at

Like (0)

Report
Here are the steps for saving multiple records from gallery and using the form to set the common fields for the batch -

Create a new form in the screen to get the user values for the common fields in the multi scan batch.

Add a condition to show this form only when there are scanned values in the gallery

Added a clear button to clear the gallery data

For the bulk submit button iterate over the records in gallery and create the data record to be saved using the form fields too

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

MultiScanDemo2.gif

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

Like (0)

Report

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 !!! 🙂

Was this reply helpful? Yes No