network error when using patch function

(1) Share

Report

Posted on by Sammen

Hello:

I have a parent table and a child table for a canvas app, both are dataVerse tables. there is no error when adding a new item with child table data, bu when modifying child table ,like adding a new line to child table, i'm getting an error saying

"network error when using patch function: the column "unique identifier" is generated by the server but can't be specified"

column in the error message is the unique identifier of the child table.

i'm saving the new line to a collection which is already preloaded with existed lines in the child table on "On visible" of the screen, so i can patch it to the child table on "On select" of the button.

i'm also loading unique identifier to the collection on "On visible", and i'm checking if the UID is empty in the collection before patching a new line to the child table.

I tried creating a new chilld table, but still the same error.

any helpful suggestions please.

All responses (2)

Answers (0)

Sammen 43 on at

Like (0)

Report

network error when using patch function

I don't think i'm generating UID, i'm only loading the UID for existed child table data, i have collection column name called id to load the UID from the child table, i'm checking if that is blank in the collection to patch new line item as new, you can see in the below patch code.

ForAll(
    colexistagentlines,
    If(
        IsBlank(ThisRecord.id),
        Patch(
            'Agents',
            Defaults('Agents'),
            LookUp(
                'Agents',
                Parent_ID = ThisRecord.Parent_ID
            ),
            {
                Name:ThisRecord.name,
                PhoneNumber:ThisRecord.phonenumber,
                Address:ThisRecord.adress,
                Salary:ThisRecord.salary,
              Line_No:ThisRecord.line_no,
                Parent_ID:ThisRecord.parent_id
         }
        )
    )
);
Suggested answer

Michael E. Gernaey 41,020 Super User 2025 Season 1 on at

Like (0)

Report

network error when using patch function

HI,

You will need to share the code.

however, I can tell you this. Without even seeing your code, you are sending in the Unique Id for the New Row, you cannot.

Please share your code, and stop generating the GUID for the new Row, let the System do it.