Run SQL Stored Procedure in PowerApps with Flow

%3CLINGO-SUB%20id%3D%22lingo-sub-965947%22%20slang%3D%22en-US%22%3ERun%20SQL%20Stored%20Procedure%20in%20PowerApps%20with%20Flow%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-965947%22%20slang%3D%22en-US%22%3E%3CP%3EHere%20is%20what%20I%20am%20trying%20to%20do.%20Right%20now%2C%20I%20have%20an%20Excel%20spreadsheet%20that%20runs%20a%20stored%20procedure%20and%20returns%20the%20results%20based%20on%20a%20start%20date%20and%20end%20date%20within%20the%20spreadsheet.%20I%20would%20like%20to%20be%20able%20to%20create%20a%20Flow%20to%20run%20this%20stored%20procedure%20and%20return%20the%20results%20in%20a%20table%20or%20gallery%20in%20my%20PowerApps%20screen.%20Is%20this%20possible%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-965947%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFlow%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPowerApps%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESQL%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EStored%20Procedure%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-966421%22%20slang%3D%22en-US%22%3ERe%3A%20Run%20SQL%20Stored%20Procedure%20in%20PowerApps%20with%20Flow%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-966421%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F238560%22%20target%3D%22_blank%22%3E%40Tim%20Hunter%3C%2FA%3E%2C%26nbsp%3BI%20think%20that%20is%20possible.%20You%20can%20call%20the%20flow%20using%20PowerApps%20and%20use%20te%20action%20ResponseToPowerApps%20to%20return%20data%20to%20PowerApps.%20What%20do%20you%20Think%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-966459%22%20slang%3D%22en-US%22%3ERe%3A%20Run%20SQL%20Stored%20Procedure%20in%20PowerApps%20with%20Flow%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-966459%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F369329%22%20target%3D%22_blank%22%3E%40pedroneto%3C%2FA%3E%26nbsp%3B%20Thank%20you%20for%20the%20feedback!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20do%20I%20use%20%22%3CSPAN%3E%3CSTRONG%3Eaction%20ResponseToPowerApps%20to%20return%20data%20to%20PowerApps%3C%2FSTRONG%3E%22%3F%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-966784%22%20slang%3D%22en-US%22%3ERe%3A%20Run%20SQL%20Stored%20Procedure%20in%20PowerApps%20with%20Flow%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-966784%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20using%20the%20Select%20action%20in%20Flow%2C%20it%20does%20not%20allow%20me%20to%20select%20Execute%20Stored%20Procedure%20from%20Dynamic%20Content.%20Any%20ideas%3F%20Thank%20you.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F152077iC2EDD18645D37BEE%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22flow1.png%22%20title%3D%22flow1.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Super Contributor

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?

3 Replies

@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?

@pedroneto  Thank you for the feedback!

 

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

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

flow1.png