Answered

Error while Patching SQL Server BadGateway

(0) Share

Report

Posted on by artenike

Hello.

I am facing really annoying problem and I spend so much time trying to fix this and I still don't know what is the issue.

As in subject: I am trying to use Patch() function to add and update SQL Server rows. Everything works fine for SharePoint lists, but here I keep getting error AFTER clicking button. I tried looking up this problem and I tried already reconnecting to SQL Server, reloading app and it still doesn't work. In Playload everything seems fine...

"An error occurred on the server. Server Response: *table name* failed" : BadGateway"

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Akash17 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @artenike
In your patch there is value: Value(txtinput.txt) just remove the Value() from if it is datepicker field
If it is not datepicker field still once you can try with Value: (.....).value
Also just check your connector whether it is properly connected to the gateway and other stuff
Let me know if it is working after trying this

Was this reply helpful? Yes No
artenike 15 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Akash17 ! Thank you so much for your reply. It is Number field so when I delete "Value" function I'm getting "The type of this argument 'Value' does not match expected type 'Number'" error.
"(...).Value" is not available (tbh even after deleting this whole column from Patch() it keeps showing Bad Gateway error.
Connector should be ok since I can view this table in gallery with no problem. I used SQL Server Authenntication, where Gateway itself isn't required. Should I install specified one to insert/ update and delete rows into SQL Server? (The same problem while using Azure Authenticaiton in connector)

Was this reply helpful? Yes No
Verified answer

artenike 15 on at

Like
a
(1)

Report
Copy link

Link copied!

Solved. Problem was that this table was data pool on Synapse and Power Apps can show Synapse tables but if you try to insert/update/delete it shows Bad Gateway Error. I recommend using following workaround in this situation: Power Automate Flow executing insert/update/delete procedure with Azure SQL Data Warehouse.

Was this reply helpful? Yes No