I created a SQL table with the primary key.
Create TABLE [dbo].[Table]
Create TABLE [dbo].[Table]
(
[MyID] int PRIMARY KEY NONCLUSTERED NOT ENFORCED,
[Time] [datetime] NULL,
[Name] [nvarchar] (255) NULL,
[Department] [nvarchar] (255) NULL
)then connected it with Powerapps, Browse shows all the entries but when edited or added new entry it shows the following error,
An error occurred on the server. Server Response: Table failed: BadGateway.
I also tried with the patch function but it also didnt work. Also, I entered the power apps IP to azure
I am unsure where the issue lies. Any help would be appreciated.
Thanks.

Report
All responses (
Answers (