Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Calling Stored Procedure from Power Automate issue

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:

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



What am i doing wrong?



Super User
Super User

@365-Giovanni  I think you need to pass Key and Value in select action. Key could be any relevant name & Value should be from dynamic content. Select gives you selected values from array of items  in the form of key:value pair.

Please 'Thumbs Up' the posts that helped you and 'Mark as Solution' if my post answered your question.

@Hardesh /

Helpful resources

2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (1,350)