PowerApps cannot edit text field when connect MSSQL

(0) Share

Report

Posted on by samsam

185

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

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"

Any idea?

Thanks in advance

Sam

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

v-siky-msft on at

Like (1)

Report
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-sqldatabas...
Best regards,
Sik
If my post is helpful for you, please click on “Accept as Solution” to help other members find it more quickly.

Was this reply helpful? Yes No
samsam 185 on at

Like (0)

Report

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

Was this reply helpful? Yes No
samsam 185 on at

Like (0)

Report

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

Was this reply helpful? Yes No