Unanswered

SQL Stored Procedures to PowerApps

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I'm trying to pull in SQL data to a PowerApp but my SQL data is the output from a stored procedure.
It sounds like I need to use a Flow in conjunction with PowerApps to accomplish this.
I've got my on-prem SQL setup on a data gateway and that's working fine.
I can create my flow ok: Triggered by PowerApps button, set static params just for testing. But the output options are very limited.
Using the "Respond to PowerApp" step, the only option I have in dynamic content is the Return Code. Which, by the way, comes back as an empty string.
So I get no visible output in my app. I can check the flow status and see the output but there's nothing useful in there.

I've tested the sproc in SSMS with the same creds and it works fine. Returns 179 records.

Any ideas?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

yashag2255 24,769 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Anonymous

If you wish to pass JSON data from Flow to PowerApps, then you can also use the Response action. Make sure that you pass the valid schema in the output.

Also, if you just wish to pass string values, then it would be easier if you add a parse json action in the flow. You can get the response from SQL action from the previous run to design the schema. Once it is done, you can use keys from the Parse JSON action in the dynamic content.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
eka24 20,925 on at

Like
a
(1)

Report
Copy link

Link copied!

Please watch this video on store procedure and powerapps from Brian:
https://youtu.be/hTraYHbcIHc?t=30
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

My issue is that I'm not getting any output from the sproc. I run it in SSMS and get 179 records.

Was this reply helpful? Yes No