can't Write data on Sql server table

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello everyone

I'm tring to read from Textbox and store it on sql server table....

I used function patch it gave me an Error

https://imgur.com/a/HxDh9

Patch('[dbo].[KAfaween]',Defaults('[dbo].[KAfaween]'),{Name: "hhhhhhhhhh"})

the first argumnt of 'Patch' must be a collection

how can I insert into sql table a value...?

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

v-micsh-msft Microsoft Employee on at

Like (3)

Report
Copy link

Link copied!
Hi @Anonymous,

I just tested the patch() function, it works for creating new record into SQL Server database from my side.

Please take a note that when using the following code:

Patch(DataSource, Defaults(DataSource), {PrimaryKey:Required, OtherFields:UpdateValue})

The Primary Key is a required field (If it has not been set to be auto-generated from the Server side).

Adding the function reference:

Patch function in PowerApps

Regards,

Michael

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

man thanks... it worked
I think this is a littele dummy.. is how it gives you an error if the table doesn't have a primary key..

this is strange...
any way thanks a lot

Was this reply helpful? Yes No
Brian Dang 3,976 on at

Like (3)

Report
Copy link

Link copied!
Confirmed: I had this same error and it was because I did not correctly configure my SQL table. I had included IDENTITY(1,1), but not PRIMARY KEY.

I recreated my table using this generic structure:

CREATE TABLE Persons ( ID int IDENTITY(1,1) PRIMARY KEY NOT NULL, LastName varchar(255) NOT NULL, FirstName varchar(255), Age int );

Was this reply helpful? Yes No
mcorsaaiincs 15 on at

Like (0)

Report
Copy link

Link copied!

I have a similar issue. My SQLServer table has a primary key, and I've been able to write to it and read from it already. But the connection occasionally seems to stop working. The only solution I've found is to remove the connection entirely and then add it back in. It appears to be a bug. One other detail: there is no error message or indicator from PowerApps that the connection stopped working. That's part of the major problem with this. And all connections (Internet, Gateway, etc.) are showing that they work fine still.

Was this reply helpful? Yes No
mcorsaaiincs 15 on at

Like (0)

Report
Copy link

Link copied!

Actually, I found out that my On_Submit button function had an error before this issue happened.. It was not showing as an error, though, until I went into the function itself.

Was this reply helpful? Yes No