Power Platform Community Forum Thread Details

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

Categories:

Building Power Apps