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

SQL Connection View Only

Hi everyone

 

I have added a connection to a couple of Azure SQL databases using a SQL account that is db_owner on both databases.  However, for some reason when I add an edit form for one of the databases all the fields show as view.  I can go into each individual field and change from view to edit but it makes no difference.

 

I'm not sure why this is happening as the account used for the connection is a db_owner and it works fine on the other database.

 

Has anyone come across this before, and if so, how can I fix it?

 

Thanks in advance for your help.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: SQL Connection View Only

Hi @gj84uw 

Have you defined a primary key field of the tables that you want edit? If there's no primary key field on a table, PowerApps will open the table in view mode only.

View solution in original post

3 REPLIES 3
Highlighted
Community Champion
Community Champion

Re: SQL Connection View Only

Can you show a screenshot. Did you connect o a sql table or view
Highlighted
Super User
Super User

Re: SQL Connection View Only

Hi @gj84uw 

Have you defined a primary key field of the tables that you want edit? If there's no primary key field on a table, PowerApps will open the table in view mode only.

View solution in original post

Highlighted
Helper I
Helper I

Re: SQL Connection View Only

@timl 

 

Thank you so much, I checked the SQL table and there was indeed no primary key setup.  I added a primary key field and the form in Power Apps now allows editing as expected.

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Robotic Process Automation

Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

Top Solution Authors
Top Kudoed Authors
Users online (5,752)