Answered

Issue Inserting Data into PostgreSQL Datasource

(0) Share

Report

Posted on by LL-07111511-0

Hi, I'm looking to create a PowerApp using PostgreSQL as a datasource. I'm looking to try something really basic where I can add, edit, and delete data from inside PowerApps. We are already paying for a premium license and I've attempted to use the following:

Patch('camera_system.System',
Defaults('camera_system.System'),
{
System_Components_Number: Int(txt_CompNum.Text),
System_Name: txt_SysName.Text,
System_Status:txt_SysStat.Text
}
)

However, there is an error message 'The function 'Patch' has some invalid arguments.' but fails to point out where the issue is. Could I get some help on this? I've logged in with the super admin credentials so no read/write permissions are missing as I can retrieve a table of contents, but no luck!

Thanks,

Liam

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (3)

Answers (1)

Sivaksk147 10 on at

Like (0)

Report

can you share the what error are you getting ?

i presume you have the gateway configured and logged in with same credetails ? and able to see the see the tables from power apps application ?

Was this reply helpful? Yes No
LL-07111511-0 11 on at

Like (0)

Report

Hi Sivaksk147,

Thanks for replying. I've got the following error:

'The function 'Patch' has some invalid arguments.'

I can confirm I've been able to retrieve data:

Many thanks,
Liam

Was this reply helpful? Yes No
Verified answer

LL-07111511-0 11 on at

Like (1)

Report

A fix for this problem, was definitely a rookie mistake, but there wasn't a primary key set on PGAdmin 4. After enabling the Primary Key, there was no issue with Patching.

Was this reply helpful? Yes No