Writeback Function - Network error when using Patch function: The requested operation is invalid.

[pstaggers]

I am trying to do a writeback from Power BI to Excel using Power Apps.  Excel file is on OneDrive and closed when I attempt the writeback.

I created a new form with a button called CreateNewRecordBtn --> NewForm(UpdateRecordForm).

I then update the tabe manually with new values.

I finally use a second button called SubmitNewRecordBtn --> SubmitForm(UpdateRecordForm)

This last statement is throwing the following error:  Network error when using Patch function: The requested operation is invalid.

Any suggestions on getting past this Patch error?

[SIH007]

Hi, my syntax was ok and the data types were correct. I already had as minimal code as possible. I managed to get my app running by using another browser.

[lbendlin]

The patch process is different between updates and additions.  Did you specify "Default" ?  Does your Excel table have a dedicated primary key column?

[SIH007]

I am having the same issue with a pretty small function: I want to write the contents of the edit form back to the table and use the command OnSelect = SubmitForm(Form1), so I don't know where to minimise this code. First everything looks ok, but then I keep getting an error telling me "Network error when using Patch function: The requested operation is invalid."

[pavanmanideep]

Hi,

Few things to check

1. Check Syntax: Check the syntax you were using for the Patch function

2. Verify the data types

Test with minimal code and build from there...I hope you will get an idea of what's going wrong there...

If I have answered your question, please mark your post as Solved.

If you like my response, please give it a Thumbs Up.

You can accept more than one post as a solution.

Cheers,

PMDY