SQL Stored Procedure

[omi18]

Hello People,

Can we use stored procedure the same as patch function? or there is a different format we have to use while working with the stored procedures? I'm trying to use the procedure to save some information from the app to the database.

Thanks,

Omi

[Pstork1]

Power Apps doesn't support the use of SQL Stored Procedures directly.  You can invoke a Stored Procedure from a Power Automate flow that is kicked off by Power apps.  That's typically what I do.

[omi18]

Hi @Pstork1 ,

What you prefer or suggest then using the stored procedure is better or Use patch function to store the data? 

Thanks,

Omi

[Pstork1 · Accepted solution]

I would recommend using a stored procedure to retrieve the data and then patch to update it.