cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
satyakanth
Frequent Visitor

Write Back to SQL - Default screens

I have created app using Excel , I see 3 screens created Browse Screen, Details Screen and Edit Screen.

Similarly when i created with SharePoint, i can see all the 3 screens, but when created with SQL table, i see only only Browse screen and Details Screen. I have installed on premises gateway to connect with SQL. is it expected behavior. I tried edit screen, but didn't work .  How do I get the edit screen by default. Am is missing anything? Should I get a premium connector for this ?

1 ACCEPTED SOLUTION

Accepted Solutions
timl
Super User
Super User

Hi @satyakanth 

This typically happens when you don't have a primary key on your table.

Can you confirm that you have a primary key defined on your table?

https://powerusers.microsoft.com/t5/Building-Power-Apps/Performing-CRUD-with-a-SQL-DB/td-p/417323 

View solution in original post

4 REPLIES 4
eka24
Super User
Super User

Two option:
1. Insert a button on one of the Screens (detail or Browse), the put EditForm(YourFormName). When you click, it should turn it  to edit. To go back, Use:
    NewForm(YourFormName) ---New entries or
   ViewForm(YourFormName) --for view

 

 OR

 

2. For default Edit form. Duplicate one of the screens. Select the form and on the Defaultmode property change it to edit:
edit.JPG

 

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

timl
Super User
Super User

Hi @satyakanth 

This typically happens when you don't have a primary key on your table.

Can you confirm that you have a primary key defined on your table?

https://powerusers.microsoft.com/t5/Building-Power-Apps/Performing-CRUD-with-a-SQL-DB/td-p/417323 

View solution in original post

satyakanth
Frequent Visitor

Adding Primary Key helped me 

you made my day

satyakanth
Frequent Visitor

Created a column in the table and made it as primary key and it worked

Thanks for the solution

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (2,657)