Unanswered

Edit Text not visible in Control Type under Edit Form

(0) Share

Report

Posted on by SShasthri

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

Categories:

Building Power Apps

ScreenShot.JPG

I have the same question (0)

All responses (7)

Answers (0)

Pstork1 68,678 Most Valuable Professional on at

Like (1)

Report

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.

Was this reply helpful? Yes No
SShasthri 6 on at

Like (0)

Report

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

Was this reply helpful? Yes No
MarkusZ 10 on at

Like (0)

Report

what was the issue with the database datatype?

Was this reply helpful? Yes No
tautvydasp 4 on at

Like (1)

Report

The table also must have a Primary Key.

Was this reply helpful? Yes No
andrejmfreitas 10 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Pstork1 68,678 Most Valuable Professional on at

Like (0)

Report

The Auto incrementing Identity key is the primary key.

Was this reply helpful? Yes No
Pstork1 68,678 Most Valuable Professional on at

Like (0)

Report

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

Was this reply helpful? Yes No