Write Back to SQL - Default screens

[satyakanth]

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 ?

[eka24]

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:

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

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 · Accepted solution]

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 

[satyakanth]

Adding Primary Key helped me 

you made my day

[satyakanth]

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

Thanks for the solution