Power Platform Community Forum Thread Details

Having problems updating a Sharepoint list with these 3 criteria:

Multiple records at once
Person/Group field (x2)
Lookup field (another Sharepoint list)

I have an internal inventory system with 2 SP lists (Supplies and Orders).

Supplies hosts the inventory items in stock
Orders tracks orders for those items

I can easily update the Orders list one item (record) at a time, but that's inefficient. I'd like the users to be able to select multiple items at once. Using SubmitForm works for the single items, but if I try to patch, I have problems patching in the complex fields listed above. I imagine there are a few different ways to do this (multiple forms, basic patch, possibly a data table). The route I'm trying to make work is pulling the User fields, Notes, and a Reference OrderID field into a form (these items will apply to all items on the order), and then patching the items separately (which is failing due to the complex lookup field) or simply patching all fields which is also failing due to the complex fields.

See screenshot below. The items in the blue section would be added to all records on the order. The supplies in the white section would be separate records. I can do this successfully with basic text fields, but the failures come when adding the user and lookup fields. Any help is appreciated!