Patch Function

(0) Share

Report

Posted on by omi18

640

Hello People,

I am trying to update a row in the SQL Server. In powerapps I have a data table to show available entries in the database. Also, I have form editor to allow users to update the record for a selected row from data table.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

mdevaney 29,989 Moderator on at

Like (0)

Report
@omi18

Since you already have an edit form could you use the SUBMIT function instead of PATCH?

Try this code in the OnSelect property of a button.

Submit(your_form_name);

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
Verified answer

v-xida-msft on at

Like (1)

Report
Hi @omi18 ,

Do you want to update the selected record in your Data Table using Edit form?

Please consider take a try with the following workaround:

Set the Items property of the Data Table to following:

'[dbo].[SQLTable]'

Set the DataSource property of the Edit form to following:

'[dbo].[SQLTable]'

set the Item property of the Edit form to following:

DataTable1.Selected

or

LookUp('[dbo].[SQLTable]', PrimaryKeyColumn = DataTable1.Selected.PrimaryKeyColumn)

Set the DefaultMode property of the Edit form to following:

FormMode.Edit

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

SubmitForm(EditForm1)

Note: Please make sure you have specified a proper Primary Key within your SQL Table.

If you want to use Patch function to submit your data to your SQL Table, please modify the submission formula as below (set the OnSelect property of "Submit" button to following😞

Patch( '[dbo].[SQLTable]', DataTable1.Selected, EditForm1.Updates )

Best regards,

Was this reply helpful? Yes No