Showing results for 
Search instead for 
Did you mean: 
Level: Powered On

SOLVED ! - SQL Schemas in PowerAps



I have an app with an on premises SQL data source. I used to have a schema called 'dbo', the standard, and here everything worked fine. Due to some changes in the database structure I had to change the schema name to 'ops'. I am owner on the database, but now I cannot see any of my forms in edit mode, and I can't submit any forms. That is, I can't write to the tables using the schema 'ops'. 


Do any of you know what might be wrong? Is this something general with PowerApps? I have tried, and I can edit the tables directly in Management Studio, but not through the app. 


I found the solution: All the new tables did not have any primary keys, and it works now that they have. 

Dual Super User
Dual Super User

Re: SOLVED ! - SQL Schemas in PowerAps

Did you double check that the connection account being used in the connector has full access to the new schema?

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Helpful resources


Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!


Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020


Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (5,257)