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 ?
Solved! Go to 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
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.
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
Adding Primary Key helped me
you made my day
Created a column in the table and made it as primary key and it worked
Thanks for the solution
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.
User | Count |
---|---|
204 | |
106 | |
56 | |
52 | |
41 |
User | Count |
---|---|
274 | |
157 | |
88 | |
81 | |
56 |