Good evening ,
I am getting error when using Patch function to update and /or create a row in SQL table (using Powerapps of course). so the error is [
Network Error when using Patch function: The requested operation is invalid] is stopping the code and nothing happens on the side of data (SQL).
Just to let you know: connection is working and data is displayed from data source (table). Also, I have developer permissions on this db.
Function is :
Patch(
TableName, Lookup(TableName, Column_Key = Dropdown.selected.Value)
{
field1: data1,
field2: data2,
field3: data3
}
)
Please assist. If you can suggest other solutions, that will be much appreciated.
Thank you.
