Issue Connecting with SQL Server

Hello everyone!

I have 2 issues here from building my first power app and I can't seem to find the right solution anywhere on the internet so I'm turning to this forum. I have already created a SQL database on Microsoft Azure, and when I tried to create a power app directly from it, the screen was loading for a while before it says '404 resource not found'. After the connection failed, I went into the list of connections inside power apps, and the SQL server, which previously failed to connect, was already there. When I tried to manually connect it at that point and create the app from there, it was able to connect successfully. However, it only generated 2 screens instead of the 3 I was expecting to get (the EditScreen was missing). I've tried recreating a new database as well as restarting everything from scratch, but the same problem remains.

The second problem, which could be a result of the first problem, is when I tried to manually create the edit screen and create a new form, I was able to add the column names directly from the app, but the text field did not show up at all. This meant that the app is able to display the data from the SQL server, but cannot edit the data. The power app simply does not seem to have 'write' access to the database on Azure. Is there any pointers as to how I can connect SQL server to power apps more seamlessly?

Any help is appreciated,

Thank you!!

Categories:

Connecting to Data