cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate I
Advocate I

SOLVED ! - SQL Schemas in PowerAps

Hi, 

 

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. 

1 REPLY 1
Highlighted
Dual Super User III
Dual Super User III

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

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (11,134)