cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
365-Giovanni
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?

365Giovanni_0-1632157605693.png

 

1 REPLY 1
Hardesh15
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 /Gopenly.in

Helpful resources

Announcements
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)