Answered

Calling Stored Procedure from Power Automate issue

(0) Share

Report

Posted on by 365-Giovanni

Hi guys,

I'm trying to build a canvas app that passes a serial number to a stored procedure and the results are fed back and shown in a table.

I know I need to create a Power Automate flow to call the Stored Proc, thats where im struggling:

Following some guides, I know I need to do a select on the outcome of a store proc, however I get no 'value' results - I know the stored proc works in flow as I've tested it and can succesfully see the data return in a JSON object.

Whre Im trynig to achieve is:

Canvas app - user inputs a serial number
Store proc returns details or orders with that serial number
Canvas app shows lines in a grid

What am i doing wrong?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Nogueira1306 7,390 Super User 2024 Season 1 on at

Like (0)

Report

Hey! My Advice would be:

1. Trigger
2. Get SQL rows and set filter to SerialNumber eq 'PowerAppsSerailNumber'
3. Select with the rows from the filter
4. Send the email with the output

Plus, there is a Power Automate community, they might be better

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira

Check my LinkedIn!

Check my User Group (pt-PT)!

Was this reply helpful? Yes No
365-Giovanni 18 on at

Like (0)

Report

Hi thanks for reply, I'm using a store procedure so can't use Get SQL Rows

Was this reply helpful? Yes No
Verified answer

timl 36,393 Super User 2025 Season 2 on at

Like (0)

Report

@365-Giovanni

The typical way to do this is to return the output of your stored procedure from Flow using a 'Response' action, rather than a 'Select' action, which is what you have in your screenshot.

The key step is to specify the 'Response Body JSON Schema' value, and Mr Dang's post here provides a great explaination. You can effectively take this example, and replace the 'Execute a SQL Query' action with your 'Execute Stored Procedure' action.

https://powerapps.microsoft.com/en-us/blog/return-an-array-from-flow-to-powerapps-response-method/

Was this reply helpful? Yes No