cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
samsam
Advocate II
Advocate II

PowerApps cannot edit text field when connect MSSQL

Hi, 

 

Conneciton: PowerApps to connect SQL Express via on-premises data gateway 

I am trying to create a simple form and submit to SQL express

but the Form field does not allow me to enter the text.

 

Finding #1

when I started the PowerApps by "Start with your data", 

the "+" new form icon was not being generated as usual (but I was able to see "+" icon if start with Sharepoint data.)

 

Finding #2

I tried to add a new screen and start from blank, but the fields are not showing 

Screen are attached

Q16a.PNGQ16b.PNGQ16c.PNGQ16d.PNGQ16e.PNG

 

Finding #3

I found that all the DataCardValue's lineHeight are minimized to less than 1 pixel (during the creation), that's why I cannot see the "string edit area". 

When selected "DataCardValue12", the Display mode is "View", but it's locked and cannot change to other mode.....

and it returns "This data type is unsupported for evaluation"

 

Q16f.PNG

 

Any idea?

Thanks in advance


Sam

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-siky-msft
Community Support
Community Support

Hi @samsam ,

 

It seems that your SQL table is read-only so that you can not edit the form.

Does your SQL table have a primary key? I had met the same issue with you that if the table doesn't have a primary key, it just be read-only. So please make sure to define the primary key? It'll need one.

For SQL tables moving forward, please be sure to write your CREATE statement like this:

CREATE TABLE dbo.TableName (
    Id INT IDENTITY(1,1) PRIMARY KEY NOT NULL,
    ...
)

Also you can find it in the prerequisites of SQL connector, source:  https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/connections/connection-azure-sqldataba... 

Annotation 2019-10-14 162242.png

Best regards,

Sik

If my post is helpful for you, please click on “Accept as Solution” to help other members find it more quickly.

 

 

 

View solution in original post

3 REPLIES 3
v-siky-msft
Community Support
Community Support

Hi @samsam ,

 

It seems that your SQL table is read-only so that you can not edit the form.

Does your SQL table have a primary key? I had met the same issue with you that if the table doesn't have a primary key, it just be read-only. So please make sure to define the primary key? It'll need one.

For SQL tables moving forward, please be sure to write your CREATE statement like this:

CREATE TABLE dbo.TableName (
    Id INT IDENTITY(1,1) PRIMARY KEY NOT NULL,
    ...
)

Also you can find it in the prerequisites of SQL connector, source:  https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/connections/connection-azure-sqldataba... 

Annotation 2019-10-14 162242.png

Best regards,

Sik

If my post is helpful for you, please click on “Accept as Solution” to help other members find it more quickly.

 

 

 

View solution in original post

@v-siky-msft I've just added the primary key, but it still failed...

 

Q16g.PNG

@v-siky-msft thanks ~~ the table is required to be re-created from NEW. 
Everything works fine now ~~ thank you 🙂

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (1,246)