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 III
Dual Super User III

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.

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

Helpful resources

PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group


Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Power Apps June 2021

June Power Apps Community Call

Did you miss the call? Check out the recording here!

Top Solution Authors
Top Kudoed Authors
Users online (29,962)