cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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
HemantG
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 

Anonymous
Not applicable

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

Anonymous
Not applicable

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
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (1,969)