Sending collection to matching SP lists - not working

[GordonFreeman33]

Hi everyone, (First Time posting)

Some context:

I have an inventory app, and when people add the products from a delivery, they add each item to a collection (colProducts) before submitting their items to two matching SP lists. One SP is meant to remove quantities (InventoryTracker), and the other is intended to be the archive of all products (OrdersReceived) that have come into the warehouse.

My Dilemma:

Would anyone know why some records don't go to BOTH lists every time? Most times, they end up in the "OrdersReceived" (archives) list, but not always the "InventoryTracker" list.

Fomula: 

Patch(InventoryTracker,colProducts);
Collect(OrdersReceived,colProducts);
Reset(txtSearchInvoice_1);
ResetForm(FormPOitems_1);
Reset(Checkbox1_2);
Navigate(Home);
Clear(colProducts);

Would a FLOW be a better option?  Thank you in advanced!

[WarrenBelz]

Hi @GordonFreeman33 ,

To use

Patch(
   InventoryTracker,
   colProducts
)

the fields in colProducts need all to be in InventoryTracker and you should have the ID (I am assuming you are using SharePoint here) in colProducts, so the existing items can be updated. Is this the case?

[GordonFreeman33]

Hi @WarrenBelz.,

im actually using 

Patch(
   InventoryTracker,
   colProducts
)

to create new records in my SharePoint List. I understand Patch is used to update records, but i recently changed it from

Collect(InventoryTracker,colProducts)

 in efforts to fix the problems im having with the collection not going to InventoryTracker.

[WarrenBelz]

Hi @GordonFreeman33,

Patch also should work (I thought the difference was updating as you used Collect in the other one). There is something strange here if OrdersReceived works on Collect and InventoryTracker does not if all the fields in colProducts (both name and type) are in InventoryTracker and there are no compulsory fields in InventoryTracker not in colProducts (and I assume you get no errors on either the code or the Patch). Is all of this correct?

[GordonFreeman33]

@WarrenBelz. You are correct. colProducts always goes to OrdersReceived and to InventoryTracker about 95% of the time. It's very hit and miss. Not sure why.

Both SharePoint lists are identical, and there aren't any required fields in either of them. 

Any Advice?

[WarrenBelz]

HI @GordonFreeman33 ,

To be honest, I have experienced the same thing (occasional failure) on collections with a large number of fields - I just go back to doing it "the long way" and lining up the fields on each side - a bit of coding but works every time.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

[GordonFreeman33]

Hi @WarrenBelz. So would a formula like this be best:

ForAll(colProducts,Patch(InventoryTracker,Defaults(InventoryTracker),{Arrived:colArrived, Product:colProduct, Customer:colCustomer,...})

I really appreciate your help with this issue. Thank you!

[WarrenBelz · Accepted solution]

Hi @GordonFreeman33 ,

I assume the field names are the same as the List here - also Patch the table, not loop through - it is much faster

Patch(
   InventoryTracker,
   ForAll(
      colProducts As aPatch,
      {
         Arrived: aPatch.Arrived, 
         Product: aPatch.Product, 
         Customer: aPatch.Customer,
         ...
      }
   )
)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

[GordonFreeman33]

Hi @WarrenBelz I'll give this a try and let you know if it works. Thank you!

[GordonFreeman33]

@WarrenBelz. It's been close to a week and everything seems to be working fine so far. Thank you again.