Using Patch to update SQL table with button.

[Anonymous]

Hello,

I just wanted to make sure I am understanding this correctly when using patch function with a button.

I have this patch function  as 

Patch('[dbo]. [table]', ThisItem, (column_name: datacard.text) 

Would I have to write each column in the function in order to update multiple columns at one time?

Thanks,

Jvang

[RandyHayes]

@Anonymous 

You should ONLY be using SubmitForm.  You do not need any Patch statements to submit a form and update your table.

I hope this is helpful for you.

[Anonymous]

@RandyHayes,

When I do use that, it gives me an error.

Thanks,

Jvang

[RandyHayes · Accepted solution]

@Anonymous 

The error is telling you the problem - you cannot have a trigger defined in the table you are trying to update.  PowerApps does not support triggers in a table.  You cannot use Patch either to get around it.  In your case, however, SubmitForm is all you need - but no trigger.

[Anonymous]

@RandyHayes,

Oh okay, so it's either I remove the trigger and use the submit form or keep the trigger and make a flow from sharepoint list into SQL. 

Thanks,

Jvang

[RandyHayes]

@Anonymous 

The only way I've worked around triggers is to use a flow to call a stored procedure which would write information to a table with a trigger.

Otherwise, if you introduce SharePoint into this, then you can simply SubmitForm to your SharePoint list and have a flow set up to trigger to then push to a SQL table.

All depends on how fast things have to happen.