Newsletter
Join our blog
Join other Azure, Power Platform and SQL Server pros by subscribing to our blog.


-1.png)
Start with the FREE community plan and get your lifetime access to 20+ courses. Get Instant Access Now!
Need help? Talk to an expert: (904) 638-5743
Private Classes
Private deliveries of courses for groups
On-Demand Learning
Beginner to advanced classes taught by Microsoft MVPs and Authors.
Bootcamps
In-depth boot camps take you from a novice to mastery in less than a week.
Season Learning Pass
Get access to our very best training offerings for successful up-skilling.
Stream Pro Plus
Combine On-Demand Learning platform with face-to-face Virtual Mentoring.
Certification Training
Prepare and ace your next certification with CertXP.
Cheat Sheets
Quick references for when you need a little guidance.
Prag Guides
Explore our knowledge base for quick tips on syntax, functions, and more!
Downloads
Digital goodies - code samples, student files, and other must have files.
Blog
Stay up-to-date on all things Power BI, Power Apps, Microsoft 365 and Azure.
Community Discord Server
Start here for technology questions to get answers from the community.
Career Guides
Breaking into the field? Let these guides help get you started with a plan.
Nerd Guides
Summaries developed in conjunction with our Learn with the Nerds sessions.
Quickstarts
Hands-on training with expert-led collaborative development.
Private Training
Personalized approach for your specific training requirements
Hackathons
Use your own data to take your team's skills to the next level.
Virtual mentoring
Get there faster with your personal trainer.
Enablement
Comprehensive enterprise enablement training for your team.
Admin Hackathon
Tame your power platform environment.
Working with stored procedures in Power Apps? This can be done with using tools like Microsoft Power Automate. Power Apps works great when passing a single value into a stored procedure, but what if I have a multi-value array? Things can get a little trickier when you have complex stored procedures.
In this demo I’ll show you 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.
My example will use a simple application I built to go through and multi-select a list of projects that I want to activate or de-activate. When I change the status of certain projects, I want to see the status changed in another gallery in my app.
Stored procedures accept single parameters easily inside SQL Server or Oracle. But what if we want to do a more complex situation that you want to do inside of a stored procedure? Watch my video below to see a pretty easy way to do this.
Want to learn more Power Apps? Our On-Demand Learning platform has Power Apps and Power Platform courses as part of our 50+ library of courses. If you would like us to build apps for you, we can help with that too. Our Shared Development offering gives you expert development time to extend your team to build the beautiful reports, dashboards, and apps you need – all at a fraction of what it would cost for a full-time developer. Click below to learn more.
ABOUT THE AUTHOR
SQL Server MVP and founder of Pragmatic Works. Brian has been working with SQL Server as a DBA and business intelligence professional since 1998. He has written more than 15 books on the topic and has spoken at dozens of conferences.
Free Trial
private training
Newsletter
Join other Azure, Power Platform and SQL Server pros by subscribing to our blog.
Leave a comment