Forum Discussion

Tim Hunter's avatar
Tim Hunter
Steel Contributor
Oct 30, 2019

Run SQL Stored Procedure in PowerApps with Flow

Here is what I am trying to do. Right now, I have an Excel spreadsheet that runs a stored procedure and returns the results based on a start date and end date within the spreadsheet. I would like to be able to create a Flow to run this stored procedure and return the results in a table or gallery in my PowerApps screen. Is this possible?

  • pedroneto's avatar
    pedroneto
    Copper Contributor

    Tim Hunter, I think that is possible. You can call the flow using PowerApps and use te action ResponseToPowerApps to return data to PowerApps. What do you Think?

    • Tim Hunter's avatar
      Tim Hunter
      Steel Contributor

      pedroneto  Thank you for the feedback!

       

      How do I use "action ResponseToPowerApps to return data to PowerApps"?

    • Tim Hunter's avatar
      Tim Hunter
      Steel Contributor

      When using the Select action in Flow, it does not allow me to select Execute Stored Procedure from Dynamic Content. Any ideas? Thank you.

Resources