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.
