Unanswered

Send Data to a Stored Procedure

(0) Share

Report

Posted on by Dpegs22

Hey Everybody,

I am creating a PowerApp that loads information into SQL (SSMS).
The PowerApp asks for numerous information from a leader. Once that information has been entered, the leader will press 'Save'.

After that, the data is to pass through a stored procedure and then into a SQL table. I am doing this to avoid duplicate entries, and the stored procedure removes all duplicates.
How can I do this? (The stored procedure has already been created).

Thanks

Dan

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Pstork1 68,697 Most Valuable Professional on at

Like (0)

Report

Power apps can't invoke a SQL stored procedure, but Power automate can. The easiest way to accomplish what you are suggesting is to store the information in a collection or variable and pass it to a Power Automate flow using JSON(). Then in the flow you can parse the JSON to retrieve the values and invoke the SQL stored procedure. This article walks through the basics of calling a SQL stored procedure using a flow from Power Apps.

Calling a SQL Server Stored Procedure from Power Apps (mssqltips.com)

Was this reply helpful? Yes No
Dpegs22 69 on at

Like (0)

Report

I have a few questions.
First, is there a way that I can only use PowerApps to avoid placing duplicates into the SQL table? Here, I would avoid the stored procedure all together.
Second, if I have to use a stored procedure in order to do this, can I avoid using JSON()?
Thanks
Dan

Was this reply helpful? Yes No
Pstork1 68,697 Most Valuable Professional on at

Like (0)

Report

1) Yes you can work directly with SQL and avoid duplicates. How you do that would depend on exactly what your SQL table looks like and what you consider to be a duplicate.

2) You have to pass the data to the flow in some way. Using JSON is the most efficient, especially if you want to pass multiple records.

Was this reply helpful? Yes No