I'm getting an error when patching a SharePoint list from a PowerApp with little to no information to work off of. The only message is "Network Error when using Patch function: The requested operation is invalid". I dug into the Error object and found a code of 8, which I believe corresponds to ErrorKind.ConstraintViolation (One or more constraints have been violated).
I have narrowed down the error to a multiple-select Person or Group column in my SharePoint list called "Operators". When I comment that column out, the Patch is successful. When it's included, I get the error above. The worst part is, I have successfully patched to a Person or Group column in a different SharePoint list, but this one fails.
Column settings:
My code that is failing:
Patch(
'SharePoint List Name',
Defaults('SharePoint List Name'),
{
Title: "Title",
Zone: {Value: sel_sh_zone_name},
Shift: {Value: sel_shift_name},
Line: {Value: sel_line_name},
Date: DateValue(DateDisplay_Component_12.datasource),
Operators: AddColumns(
operators_select.SelectedItems,
"Claims",
"i:0#.f|membership|" & Mail,
"Email",
Mail,
"Picture",
"https://<base_site_url>/_layouts/15/UserPhoto.aspx?Size=L&AccountName=" & Mail
)
}
)
The operators_select.SelectedItems is a Office365Users table. I need to add the "Claims", "Email", and "Picture" columns in order to avoid Table schema errors. Before attempting the Patch, no errors/warnings show up. Like I said, this strategy has worked successfully in another SharePoint list with this column type. I've scoured settings and haven't found any differences yet.
If anyone has any ideas for what to look at next or how to get more detail on the error message, please let me know! Thanks.
I am getting same message but my data source is MS SQL
My formula is
I have the same problem; I deleted all the blank cells and rows from my list, but I still receive the error message: Network error when using patch function: the requested operation is invalid.
I was experiencing the same problem. After lots of trial and error i discovered that problem was that I was validating the data from SP list settings -> Validation settings, After removing the validation from list and keeping validation only in the app patch worked.
What are possible reasons of "Network Error when using Patch function: The requested operation is invalid"?
Hello, I am having the same issue.
I’m trying to use a Patch() function to collect some data (product name, price and quantity) from my shopping cart gallery and then populate a product order table in Dataverse.
Patch function:
ForAll(ShoppingCartGallery_1.AllItems,Patch('Product Orders',Defaults('Product Orders'),{'Product Name':ThisRecord.Item.ProductName, 'List Price':Value(ThisRecord.Price),Quantity:Value(ThisRecord.QuantityTextInput_1.Text)}))
This error occurred when I'm trying to make a checkout.
I also want to know how to create relation between tables. Please help me in these issues
If you are using Submit Form(Sharepoint1) and getting the error :Network Patch using title column
Then make sure you go to List Setting->Advanced settings->Allow Management of Content Types ->Yes (by default it will be No)
Go back to settings->Column title -> Remove the required information to No
Once done with changes go to Powerapps and refresh the Sharepoint source
I need help, I am getting the same Network error on the Patch function
Halo,
i am having this error , but a bit different.
anyone can help me please.
so i click my check all button then i transfer my data , my transfer button contain Patch in it. Previously is working so im not sure why suddenly is not working.
Many thanks
@v-xiaochen-msft sorry this is random, but I am facing a similar issue. I am new to powerapps and would appreciate if you could explain about -"'Mail' column of each record has a value rather than blank." I did not quite understand. Thanks.
WarrenBelz
146,743
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,079
Most Valuable Professional