cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

Inventory app, Multiple barcodescan upload to SharePoint list

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!

1 ACCEPTED SOLUTION

Accepted Solutions

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

  1. Create a new form in the screen to get the user values for the common fields in the multi scan batch.
  2. Add a condition to show this form only when there are scanned values in the gallery
  3. Added a clear button to clear the gallery data
  4. 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 

View solution in original post

4 REPLIES 4
Power Apps
Power Apps

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 

Frequent Visitor

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 - 

  1. Create a new form in the screen to get the user values for the common fields in the multi scan batch.
  2. Add a condition to show this form only when there are scanned values in the gallery
  3. Added a clear button to clear the gallery data
  4. 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 

View solution in original post

Frequent Visitor

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

Helpful resources

Announcements
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

Users online (88,882)