Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Edit Text not visible in Control Type under Edit Form

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





Dual Super User
Dual Super User

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.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Join me at 365EduCon in Chicago on Sept. 26-30 where I'll be presenting on the Power Platform!

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

Helpful resources

Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (1,967)