Answered

Network Error when Patching, Field ID is Required

(0) Share

Report

Posted on by Prakhar_Gupta1

Hey All,
I have a Screen that has a form Control in Tab 1 & An Excel-like grid View in Tab 2.
I have two Sharepoint lists - List 1 & List 2, I am saving data to List 1 using form control from Tab 1

And using Collection & then Patching the data to List 2 from Tab 2.
I am making the Relation Between these 2 lists using the Master ID., It seems Pretty and working perfectly.
Now
I am creating an Amend Request, which means creating a New Request from Existing Request.
So when the user clicks on the button he can see all the data of the existing ID, & he made some changes & once he finally saves it, it creates a new ID in List
so what I did is, I made the column ID as Blank for Form Control, & once the user clicks on Submit form button, Power apps it self save it with a new ID.
till here everything works fine,

Now Here the Problem Comes :
But, when I click on the button to patch the data of the second list it Says Error, -"Network error when using Patch Fnction, Field ID is Required".
I have Collection which has Data from List 2, which means it has an ID column also, which Value of Last Saved ID, I tried making the ID column is Blank in Collection & then Patching, so the Power app can generate a new one by itself, but still, it gives error.

Please Help.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

TheRobRush 11,128 Moderator on at

Like (0)

Report
Copy link

Link copied!

DropColumns()

Was this reply helpful? Yes No
RajnishMahaseth 58 on at

Like (0)

Report
Copy link

Link copied!
Based on the information provided, the exact reason for the "Network error when using Patch Function, Field ID is Required" problem in your Power Apps scenario may be difficult to determine without more detailed information and reviewing the specific code and configurations you have implemented. However, there are a few potential causes that could lead to this issue:
Required Field: The error message indicates that the "ID" field in List 2 is set as a required field. When patching data to List 2, you need to ensure that you are providing a value for the ID field. If the field is left blank or not provided, the error will occur.
Incorrect Field Mapping: It's possible that there is an issue with the mapping of fields between List 1 and List 2. Ensure that you are correctly mapping the fields when patching data from the form control in Tab 1 to List 1, and then from the collection in Tab 2 to List 2.
Data Type Mismatch: Check if there is a data type mismatch between the ID field in List 2 and the value you are trying to patch. Ensure that the data types align between the collection and the field in List 2 to avoid errors.
Permissions and Connectivity: Verify that you have the necessary permissions to create and update items in List 2 in SharePoint. Additionally, ensure that you have a stable internet connection to avoid any network-related errors.

Was this reply helpful? Yes No
Verified answer

Prakhar_Gupta1 51 on at

Like (0)

Report
Copy link

Link copied!

Hello Every one,

I got the Solution, Instead of using just a Drop Column with various scenarios, Please try Using the Showcolumn().
In my case, Powerapps, was never deleting or completly removing the ID column, beacuse it was default generated by system. it was able to drop other type of column but ID column, i am not sure why, & then i tried Show column() & it worked for me,
Seems like Showcolumn is more powerfull than dropcolumn,

Thanks

Was this reply helpful? Yes No