Answered

Edit Form Entries - Cannot edit text in fields.

(0) Share

Report

Posted on by LeggoMyEggo

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.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

leyburn19 2,157 on at

Like (0)

Report

Can you supply a screen dump. It seems like your fields are labels which is not likley.

Was this reply helpful? Yes No
LeggoMyEggo 6 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

timl 36,393 Super User 2025 Season 2 on at

Like (4)

Report

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

Was this reply helpful? Yes No
LeggoMyEggo 6 on at

Like (0)

Report

@timl,

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!

Was this reply helpful? Yes No
timl 36,393 Super User 2025 Season 2 on at

Like (0)

Report

You're welcome @LeggoMyEggo!

Was this reply helpful? Yes No
Zz1117 on at

Like (0)

Report

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

Was this reply helpful? Yes No