web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Edit Text not visible ...
Power Apps
Unanswered

Edit Text not visible in Control Type under Edit Form

(0) ShareShare
ReportReport
Posted on by 6

Hi , I am trying to create an edit form and when i add filed , under control type i am not getting edit controls. Only View option is showing up. Because of which unable to edit the filed. Any suggestion who to over come this ?

Note : My source is Azure SQL Server

 

sshasthri_0-1594210918129.png

 

 

Categories:
I have the same question (0)
  • Pstork1 Profile Picture
    68,678 Most Valuable Professional on at

    Make sure the SQL database you are trying to edit has an Auto Incremementing Identity field and that the connection account has permission to edit the database. Its pretty common for SQL databases to connect as ReadOnly unless you make sure the database is setup to allow editing through the connector.

  • SShasthri Profile Picture
    6 on at

    Thanks! Added Auto increment column in table and also there was an issue with Database datatype. Fixed them and working as expected.

  • MarkusZ Profile Picture
    10 on at

    what was the issue with the database datatype?

  • tautvydasp Profile Picture
    4 on at
    The table also must have a Primary Key.
  • andrejmfreitas Profile Picture
    10 on at

    I have the same issue. I am unsable to fix it.

    THe SQL server allows remote connection.
    I also have an id column. with INT IDENTITY(1,1)

    However, that's still not working

  • Pstork1 Profile Picture
    68,678 Most Valuable Professional on at

    The Auto incrementing Identity key is the primary key.

  • Pstork1 Profile Picture
    68,678 Most Valuable Professional on at

    Please post this as a new question.  You'll get more responses and others will be able to find the answer more easily later.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 757 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 322 Super User 2025 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 209 Super User 2025 Season 2

Last 30 days Overall leaderboard