Passing Array Parameters into Stored Procedures from Power Apps

Learn how to use Power Apps to send arrays as parameters into a stored procedure using JSON and Power Automate. This can be used to solve more complex stored procedure filtering with OPENJSON.
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -
Next step on your journey:
👉 On-Demand Learning Courses FREE Trial: www.pragmaticworkstraining.co...
🔗Pragmatic Works On-Demand Learning Packages: pragmaticworks.com/pricing/
🔗Pragmatic Works Boot Camps: pragmaticworks.com/boot-camps/
🔗Pragmatic Works Hackathons: pragmaticworks.com/private-tr...
🔗Pragmatic Works Virtual Mentoring: pragmaticworks.com/virtual-me...
🔗Pragmatic Works Enterprise Private Training: pragmaticworks.com/private-tr...
🔗Pragmatic Works Blog: blog.pragmaticworks.com/
Let's connect:
✔️Twitter: / pragmaticworks
✔️Facebook: / pragmaticworks
✔️Instagram: / pragmatic.works
✔️LinkedIn: / pragmaticworks
✔️RUclips: / pragmaticworks
Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: [phone]
Email: [e-mail]

[@benterrell9139]

for a few seconds I thought I was going mad and then I spotted your subtle selection of "show more" on the flow. The first time I tried I had added the first argument twice. Why is Powerapps so squirrely? Incredible that it would assume that I wanted to add exactly the same link for the second parameter. Luckily I am getting used to its foibles. Great video!

[@MeirbhinOConaill]

Great stored proc example. I was struggling with passing parameters to SPs from flow. I now have SP names set as variables and we're using JSON parameters, truly dynamic. Many thanks

[@leenplof]

Nice way of doing this with the stored procedure. I used to use all sorts of variables, parse string from JSON for each etc ending up with long and complex flows. This is way easier, thanks a lot!

[@sciclops3443]

Excellent lesson! Thank you.

[@DanielADamico]

Awesome Video!! 👍👍👍

[@selwynvanrooyen9432]

Do you have a video that shows how to receive a response from your stored proc?

[@nirajbarot1861]

i want to create a Power App and Power Portal for our customers to place Power App CSP License orders & The base app for the power portal needs to be a model driven app (CMS DB) and The Power app entities will be displayed in the power portal. can you please make video on this requirement ASAP? if you can so it will help me a lot.