cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
samsam
Level: Powered On

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
Level 10

Re: PowerApps cannot edit text field when connect MSSQL

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
Level 10

Re: PowerApps cannot edit text field when connect MSSQL

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

samsam
Level: Powered On

Re: PowerApps cannot edit text field when connect MSSQL

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

 

Q16g.PNG

samsam
Level: Powered On

Re: PowerApps cannot edit text field when connect MSSQL

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

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (5,614)