Power Platform Community Forum Thread Details

Hi All,

Just quick question, I am plannig to do to Submit Form on SPLIST data and Patch update item on PostgreSQL on one click button, is it possible?

Right now I am only able to get the Gallery from Postgre, but tried to update the list is not working.

Thanks

Categories:

Building Power Apps

Hi @daroot,

Could you please share a screenshot about your app's configuration?

Could you please show more details about the SubmitForm function and Patch function you used within your app?

Based on the needs that you mentioned, I think it is impossible to be achieved in PowerApps with single one button?

I assume that you want to submit a new record into your SP list and update an existing record in your Postgre SQL table, I have made a test on my side, please take a try with the following workaround:

Set the OnSelect property of the "Submit" button to following formula:

SubmitForm(EditForm1); /* <- Submit Form data into your SP list */
Patch(
 'YourPostgreSQLTable', /* <- 'YourPostGreSQLTable' represents your Postgre SQL Table */
 LookUp('YourPostgreSQLTable', PrimaryColumn = PostgreBrowserGallery1.Selected.PrimaryColumn), /* <- Find the record you want to update in your PostgreSQL table*/
 {
 Column1: "xxxx",
 Column2: "xxxx",
 ...
 }
)

Note: PrimaryColumn represents the Primary column in your PostgreSQL table. PostgreBrowserGallery1 represents the Gallery control which pull data from your PostgreSQL table.

In addition, you could also consider take a try with the following workaround:

Set the OnSelect property of the "Submit" button to following:

SubmitForm(EditForm1); /* <- Submit Form data into your SP list */

Set the OnSuccess property of the EditForm (EditForm1) to following:

Patch(
 'YourPostgreSQLTable', /* <- 'YourPostGreSQLTable' represents your Postgre SQL Table */
 LookUp('YourPostgreSQLTable', PrimaryColumn = PostgreBrowserGallery1.Selected.PrimaryColumn), /* <- Find the record you want to update in your PostgreSQL table*/
 {
 Column1: "xxxx",
 Column2: "xxxx",
 ...
 }
)

More details about the Patch function in PowerApps, please check the following article:

Patch function

Best regards,

Kris