Custom SQL statement when connecting

[Syndicate_Admin]

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):

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

Many thanks

[murshed · Accepted solution]

Sorry this isn't supported since the connection creation is isolated from the actual flow.

If this reply answers your question or solves your issue, please ACCEPT AS SOLUTION ☑️. If you find this reply helpful, please consider giving it a LIKE 👍.