Power Platform Community Forum Thread Details

Hello all,

I wonder if you can help me with this.

I am making a change to a page of an existing Power App.
The Power App uses SQL Authentication to connect to a Azure hosted SQL server database.

Before the change, the page had two tabs. Each tab has a gallery, which connects to a database table.

The change is simple. Have another tab, that will have another gallery, which will connect to another table.

The application works fine when I run it in Power Apps development studio. I can read, write delete to/from the new table.

The issue is when I publish the app and run the published version, the new galley does not interact with the new table.

I have an "Add Row" button, I get a generic error Network error when using Patch function: You don't have permission to create this row.

I ran the published app from the Monitor. I can see there are some errors. See attached Monitor.png.

I just cannot understand why the application works okay in the Power Apps studio, but not as a published app.

Any help would be much appreciated.

Thanks,

Rob

Categories:

Published Power App does not interact with SQL Server table