web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Custom SQL statement w...
Power Apps
Unanswered

Custom SQL statement when connecting

(0) ShareShare
ReportReport
Posted on by

Hi,

 

I was just wanting to know if it is possible when connecting to an SQL database in Powerapps, to write custom SQL statements as opposed to just connecting and selecting a table.

Basically what you can do in Power BI/Power query under SQL statement (see below):

NJ91_0-1627373241360.png

 

E.g. SELECT DISTINCT(Column name) from xxx WHERE....

Many thanks

Categories:
I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
Kalathiya Profile Picture

Kalathiya 321 Super User 2026 Season 1

#2
WarrenBelz Profile Picture

WarrenBelz 289 Most Valuable Professional

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 200 Super User 2026 Season 1

Last 30 days Overall leaderboard