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.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Suggested answer

Michael E. Gernaey 53,978 Moderator on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Sammen 43 on at

Like (0)

Report
Copy link

Link copied!

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
         }
        )
    )
);

Was this reply helpful? Yes No