I have a PowerApp connected to an SQL database (in Azure). Showing the data in my app works fine. Now I want to make changes to the data within the app, and send the update command back to my database. But when I click the button with my 'Submit Form' command, nothing happens.
It seems to be related to my source, because when I insert an 'Edit form' to my app, this Edit form doesn't have all the capabilities it should have. For one it is missing the 'Update' option. When I connect to a different source (SharePoint list) and add an Edit form, it works fine.
I have thought of two reasons for this:
- It involves a premium connector. However, I now have a premium license and it still doesn’t work.
- It has something to do with the data source. Somehow PowerApps isn’t allowed to communicate back to my SQL database?!
Does anybody have any thoughts on this?
