network error when using patch function

(0) Share

Report

Posted on by Station1901

209

Hello,

I have created a power app and when i run it I keep getting an error - Network error when using patch functionthe requested operation is invalid.

I have absolutely no idea why this is happening though I only have limited knowledge of creating powerapps. This is driving me crazy dos anyone know why I would get this error and how I go about correcting it?

Thanks

Categories:

Building Power Apps

iamge2.JPG

iamge1.JPG

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

Ami K 15,679 Super User 2024 Season 1 on at

Like (3)

Report
@Station1901 - some typical checks depending on your data source:

Check if you have any required fields not included in your Patch

Check if you have permission to write back to the data source

Remove each field from the patch one by one until the error disappears to pinpoint which field is causing the problem.

Check if you are patching Text to a Number column (and vice versa) or if you are patching to a Choice field

For SharePoint, check if any of those fields have "enforce unique values" enabled and you're not patching to a field which already has the same value

If any of your fields are a Choice field type, check if the choice from the combo box/dropdown in your app exists as an the available choice in the SharePoint list. If not, you will need set the SharePoint choice column to allow “fill in” choices (or 'can add values manually' in modern SharePoint).

Check the number of people columns in your list. The threshold in a single list is 12 Lookup columns. You start out with 2 out of the box people columns ("Created by" and "Modified by"), so you actually have 10 LookUp columns left to work with (people columns are also considered LookUp columns).

Was this reply helpful? Yes No
Yogesh_9 4 on at

Like (0)

Report

Patch(
Desktop_Screen,
Defaults(Desktop_Screen),
{
EmployeeCode: {
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
Id: ComboboxCanvas1.Selected.ID,
Value: ComboboxCanvas1.Selected.Title
},
'Employee Name': LookUp(
inventorydata,
Title = ComboboxCanvas1.Selected.Title,
EmployeeName
),
Department: LookUp(
inventorydata,
ComboboxCanvas1.Selected.Title in Title,
Department
),
'EmployeeCode: Location': {
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
Id: ComboboxCanvas1.Selected.ID,
Value: ComboboxCanvas1.Selected.Location
},
Title: DataCardValue1.Value,
ModelNumer: DataCardValue3.Value,
SerialNumber: DataCardValue4.Value,
HardDisk: DataCardValue5.Value,
RAM: DataCardValue11.Value,
Configuration: DataCardValue12.Value,
LEDModelNo: DataCardValue13.Value,
LEDSerialNo: DataCardValue14.Value,
Vendor: DataCardValue15.Value,
Status: DataCardValue16.Value,
DateofPurchased: DataCardValue17.SelectedDate,
IssuedDate: DataCardValue18.SelectedDate,
Value: Value(DataCardValue19.Value)
}
) i have facing same issue as i have created a collection inventory data which i used to filter my employee code and based on that i called my employee name , department ,location based on the filtration please help me to resolve this column

patch error.png

Was this reply helpful? Yes No
gdb789 36 on at

Like (1)

Report

The 'Monitor' (Advanced tools - Monitor) tool may help. Run the app, and you'll see the same error at the patching step, then 'Download' the details in JSON (in the top menu). Search through it to see if you can find what actually causes the error. That saved me tons of time (I had many custom fields and I knew it must be one of them.)

Was this reply helpful? Yes No
charterha17 4 on at

Like (0)

Report

Patch(
EOS_Downtime_Schchg,
ThisItem,
{
Date: DTG_Date.SelectedDate,
Shift: If(
IsBlank(DTG_Shift.Selected),
{Value: DTG_Shift.SearchText},
DTG_Shift.Selected
),
Type_: If(
IsBlank(DTG_Type.Selected),
{Value: DTG_Type.SearchText},
DTG_Type.Selected
),
Reason: If(
IsBlank(DTG_Reason.Selected),
{Value: DTG_Reason.SearchText},
DTG_Reason.Selected
),
Source: If(
IsBlank(DTG_Source.Selected),
{Value: DTG_Source.SearchText},
DTG_Source.Selected
),
Part_Number: DTG_PartNumber.Text,
Minutes: Value(DTG_Minutes.Text),
Comments: DTG_Comments.Text
}
);
UpdateContext({EditMe: false})

I am having the same issue with my combo box...

Was this reply helpful? Yes No