Calling Stored Procedure from Power Automate issue
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
@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.