You’re offline. This is a read only version of the page.
Hi,
I'm really new to PowerApps but I've managed to get through just about every obstacle to put together a prototype for my clients. I seem to be the only person on the planet with this issue. Please give me a clue.
I have one sceen with one Data Table which displays a sorted list of records from a SQL database. I have an Edit Form below it on the same Canvas. When you highlight a record in the table, it appears in the edit form. There are no errors. I cannot edit the text in any field in the edit form. I have the form defaulting to edit. I forced some fields to edit. I call EditForm(form_name). The fields cannot be changed. Doesn't work in the preview nor published. It's like it's a display form in disguise. I have read 50+ posts, apparently everyone is smarther than I am.
All of the examples show boxes around the fields in their apps. Mine doesn't have the boxes which is probably a blatant indication. Please help. I know enough to provide more details. Thank you.
Wow this article helps a lot! I created a table with no PK and I was wondering why the Edit Form isnt working! With no PK there is no Edit form created. I tried to create one manually and nothing work. So I deleted the whole table, created a new one with a PK and created a power app with it and finally the Edit form appears when creating an app
Thank you for taking the time to help me. I appreciate it.
The table does not have a primary key. I'll get with my DBAs to modify the back end. They can do it without blowing it up.
I'll mark this as resolved. Thank you so much!
Hi @LeggoMyEggo
Here are the things that I would check....
When you say that your data source is a 'sorted list of records from a SQL database', is your data source a SQL table or a SQL View? Edit forms work only with SQL tables that contain a primary key. Therefore if your data source is a view, this would be one reason why your form doesn't work.
https://powerusers.microsoft.com/t5/General-Discussion/Issue-with-SQL-not-allowing-EDIT/m-p/96092#M35756
When you say that you 'I forced some fields to edit', I'm assuming from your screenshot that you set the DisplayMode property to edit. Note that the DisplayMode property controls whether a control is enabled or disabled. It doesn't control whether a form displays a data item in a text input control or label. There are some more details in my post here.
https://powerusers.microsoft.com/t5/General-Discussion/Forms-always-open-with-Displaymode-Edit/td-p/92181
The screenshot in this post shows how you can change the data item in a card from 'view text' to 'edit text' via the properties > data item of a form.
https://powerusers.microsoft.com/t5/General-Discussion/EditForm-isn-t-showing-an-editable-field/m-p/95112#M35465
The fields appears to be defined as "Cards".
If you click on my avatar photo to the left, then MyPhotos, the screen shot opens nice and big. Thanks
#1
WarrenBelz
250
Most Valuable Professional
#2
MS.Ragavendar
122
#3
stampcoin
108
Share
Report
All responses (
Answers (
