cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
LeggoMyEggo
Level: Powered On

Edit Form Entries - Cannot edit text in fields.

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.

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Edit Form Entries - Cannot edit text in fields.

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#M3...


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/...

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/...

View solution in original post

5 REPLIES 5
Super User
Super User

Re: Edit Form Entries - Cannot edit text in fields.

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

LeggoMyEggo
Level: Powered On

Re: Edit Form Entries - Cannot edit text in fields.

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

 

 

 

Super User
Super User

Re: Edit Form Entries - Cannot edit text in fields.

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#M3...


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/...

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/...

View solution in original post

LeggoMyEggo
Level: Powered On

Re: Edit Form Entries - Cannot edit text in fields.

@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!

Super User
Super User

Re: Edit Form Entries - Cannot edit text in fields.

You're welcome @LeggoMyEggo!

Helpful resources

Announcements
Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Join THE global Microsoft Power Platform event series

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Microsoft Business Applications Virtual Launch

Join us for the Microsoft Business Applications Virtual Launch Event on Thursday, April 2, 2020, at 8:00 AM PST.

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (7,914)