cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted
Community Support
Community Support

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
Highlighted
Community Support
Community Support

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

Highlighted
Advocate II
Advocate II

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

Highlighted
Advocate II
Advocate II

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
Ignite

Microsoft Ignite

This will be a conference that you do not want to miss!

secondImage

New Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (3,293)