Network Error when using Patch: Specified record not found.

[starchrys]

I created a table in powerapps for an Excel Online Database. When a row on this table is clicked, a pop up is supposed to show details of this row from a different table. I created two tables with the same "Name" column, which I used for the lookup function.

I need the pop-up to be editable and submitted back to the database, but when I use the Patch function to submit the text inputs, it says that the specified record was not found. I debugged a bit and tested if it worked with Default(Table2), and it created a new row with the text input values. 

Patch(Table2, LookUp(Table2, Name = selectedItem.Name),{
    'L1_Specific Reason': l1Specific.Text,
    'L1_Probable Cause': l1Probable.Text,
    'L1_RemarksAction Taken': l1Remarks.Text
});

[mmbr1606]

hey @starchrys 

add a text lable and put this in the text property

LookUp(Table2, Name = selectedItem.Name).Name

 is it the record you are trying to find?

you can also try this:

Patch(Table2, Gallery1.Selected, {
    'L1_Specific Reason': l1Specific.Text,
    'L1_Probable Cause': l1Probable.Text,
    'L1_RemarksAction Taken': l1Remarks.Text
})

This assumes Gallery1.Selected gives you the selected record from Table2.

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.



Greetings

[starchrys]

Hi! Thanks for the reply!

LookUp(Table2, Name = selectedItem.Name).Name

 This does return the value that I need, but it still returns the error when I run it.

Patch(Table2, Gallery1.Selected, {
    'L1_Specific Reason': l1Specific.Text,
    'L1_Probable Cause': l1Probable.Text,
    'L1_RemarksAction Taken': l1Remarks.Text
})

I also tried this but it says that the specified column 'Email' does not exist, which exists in the first table but not on the second one.

[mmbr1606]

hey @starchrys 

can u try this modification:

Patch(
    Table2, 
    LookUp(Table2, Name = selectedItem.Name),
    {
        'L1_Specific Reason': l1Specific.Text,
        'L1_Probable Cause': l1Probable.Text,
        'L1_RemarksAction Taken': l1Remarks.Text
    }
);

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.



Greetings

[starchrys]

@mmbr1606 still returns the same error ☹️

[timl · Accepted solution]

Hi @starchrys 

When you connect to an Excel file using the Excel Online Business connector, it'll ask you to specify the column that contains unique values, or it can create a 'powerappsid' column to automatically manage this.

If you chose the former, can you check that that your key column contains a value for the record that you want to update, as this could explain the 'specified record not found' error?

[starchrys]

Oh! You're right @timl, I did create a powerappsid column. That might be it but how do I make powerapps to generate one for the row?

[starchrys]

Nvm, I found that I had to make powerapps enter data into the row itself in order to generate. It works! Thanks @timl