You’re offline. This is a read only version of the page.
Announcements
Hi,
I'm really new to power apps and I'm struggling to get data from a collection into a SharePoint list. The first part works writing data from a collection into an order SharePoint list, however when I ask it to write into a different list it won't work, it keeps saying 'The specified column 'ItemSize' does not exist. The column with the most similar name is 'ItemSize', the column does exist.
This is the OnSelect function I am using, the first part works, where 'ShoeStyle Orders v3' is the first SharePoint list, colShoppingCart3 is my collection. This does create a record as expected.
The second part is where it gives me the error, 'ShoeStyle Ordered Items v3' is a different sharepoint list where the fields match however I get the error, it adds the Title field and required rows depending on the number of items selected but not the rest of the data:
Set(varRecordID,Patch('ShoeStyle Orders v3',Defaults('ShoeStyle Orders v3'),{Title:TextInput2.Text,'Order Comments':TextInput3.Text,'Order Total':With({ST:Sum(colShoppingCart3,SubTotal)},ST+ST*0.07+4.99)}).ID);
Collect('ShoeStyle Ordered Items v3', AddColumns(colShoppingCart3, "OrderID", varRecordID))
Any help would be really appreciated
I would still recommend to use Patch in order to submit to your second SP List instead of collect which seems to push data into SP but does not recognize added columns.
instead I would use Patch within a ForAll loop to create items in SP
ForAll(AddColumns(colShoppingCart, "OrderId", varRecordId), Patch(test, Defaults('ShoeStyle Ordered Items v3'), {Title: ThisRecord.Name, Order: ThisRecord.OrderId}))
Share
Report
All responses (
Answers (
717
