Showing results for 
Search instead for 
Did you mean: 
Helper III
Helper III

Running SQL queries/ Calling View in PowerApps

Hi PowerUsers,


I was wondering if we have any mechanism to run a SQL query or call a view within PowerApps without involving MS flow?

I have a very large data set residing in the SQL table and I do not want to attach the complete table in PowerApps.

And do not want to use flow either !!


Is there any way around to get this done ?


Looking forward to your awesome responses 🙂 




Ali Nawaz

Dual Super User III
Dual Super User III

To the best of my knowledge there is no way to execute a SQL query from inside Power Apps without using SQL.  You can approximate the same thing using ShowColumns() and Filter().  But your data source will use the full table/view that you are attaching to.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Regular Visitor

Hi Ali,
Not sure if you figured this out yet but there is an interesting related video by Brian Dang.
Here's the link:


Hope it's helpful.

If you find a better solution, let me know!




Helpful resources

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (3,867)