Network error when patching a number field as from Collection to SharePoint

[Dianez]

Hi Everyone!

First thank you to everyone that has helped my thus far. I appreciate it. I feel like I should be able to get this, as a beginner, but apparently not...

I have a shopping cart app that collects data into a 'collection' and the submits the records to SharePoint. I am currently working on creating a Shopping Cart ID. So that all the items that people order in their shopping cart are grouped by a single ID number.

For some reason with the 'Patch' function, It cannot recognize the number as a number. The collection does when I use Value() function, and Sharepoint is looking to receive a number. But I don't know how to write it for the Patch function. Value() produces an error because it's looking for a "5", not the name of a column "CartNo."

Code to put entry into the Collection named "ColCart", See bold line of code

Collect(
ColCart,
{
Name: Name.Text,
Title: RoomNumberText.Text,
Email: EmailText.Selected.Mail,
DateText: Date1.SelectedDate,
Category: drpCategory.Selected.Result,
Subcategory: drpSubcategory.Selected.Result,
ItemName: drpItemName.Selected.ItemName,
Quantity: Quantity.Text,
CartID: Value(CartNo.Text)
}
);
Reset(drpCategory);
Reset(drpSubcategory);
Reset(drpItemName);
Reset(Quantity);
Reset(CartNo)

Code to Submit Shopping Cart to SharePoint, see in bold line of code

Patch(Orders, Defaults(Orders), { Title: RoomNumberText.Text, DateText: Date1.SelectedDate, Name: Name.Text, Email: EmailText.Selected.Mail, Category: drpCategory.Selected.Result, Subcategory: drpSubcategory.Selected.Result, ItemName: drpItemName.Selected.ItemName, Quantity: Quantity.Text, CartID: CartNo });

Collect(Orders, ColCart); RemoveIf(Orders, ItemName=Blank());

So, the error is "Network error when using Patch function. The requested operation is invalid." The record does show up in SharePoint, but the rest of my app does not work. Because it's supposed to navigate to a confirmation screen upon success and it does not.

[Ethan_R]

Hi @Dianez ,

You have used the collection 'colCart' but haven't used in your Patch. 

Are you trying to patch the record using colCart?

If so, use this

ForAll(
    colCart,
    With(
        {
            CurrentRecord: ThisRecord
        },
        Patch(
            Orders, 
            Defaults(Orders), 
            { 
                Title: CurrentRecord[@Title], 
                DateText: CurrentRecord[@DateText], 
                Name: CurrentRecord[@Name], 
                Email: CurrentRecord[@Email], 
                Category: CurrentRecord[@Category], 
                Subcategory: CurrentRecord[@Subcategory], 
                ItemName: CurrentRecord[@ItemName], 
                Quantity: CurrentRecord[@Quantity], 
                CartID: CurrentRecord[@CartID] 
            }
        );
    )
)

If not, then in your Patch function, try

CartID: Value(CartNo) 

Hope this helps

[Dianez]

Hi @Ethan_R 

It's the line that messes up the app. The app was working fine until I added the 'CartID' column. 

1) In 'ColCart', the collection, I have {...CartID: Value(CartNo.Text)}, This may or may not be correct. It seems to work though.

2) For Submitting the collection (ColCart) to the SharePoint list (Orders), I tried several different formulas, and I get errors:

• {...CartID: Value(CartNo.Text)} - Runtime error: "Network error when using 'Collect' function. The requested operation is invalid." 

• {...CartID: Value(CartNo)} - The function 'Value' has some invalid arguments

• {...CartID:  CartNo} - Network error when using 'Patch' function. The requested operation is invalid. <- this one almost works

• {...CartID:  CartNo.Text} - The type of argument 'CartID' does not match the expected type 'Number'. Found type text.

I've run out of ideas.

[Dianez · Accepted solution]

I found the answer.

Reza Dorani on youtube's video: 7 Key points to note: SharePoint in PoweApps. 

SharePoint does not support, or is not good at, creating relationships with data. A one-to-many, many-to-one, and a many-to-many relationships are better done with another type of data source like the Dataverse.