Building a Power App as a front end to a SQL database

(1) Share

Report

Posted on by DB-14081104-0

Hello

I'd like to know if this is possible.

At my organisation we have a large SQL database (hundreds of tables, millions of rows). Does Power Apps have the functionality to be a front end GUI explorer for the database, and could it allow users to export data from the database into a document such as Excel at the same time? I do not want people to be able to write to the database tables. Purely read-only.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Daniel Bocklandt 5,099 Super User 2025 Season 2 on at

Like (1)

Report

Hey DB-14081104-0,

There is an Connector that we can use to get Data from SQL and you have the posibillitie to export the Data to Excel.

If it's a valid tool depends on your specific use case. could you tell us moe about hox you want to use the app and how the user should be guided?

Was this reply helpful? Yes No
DB-14081104-0 19 on at

Like (1)

Report

Hi, thanks for your response.

We need people to be able to browse what data is available, and if possible to be able to directly extract from specific tables that they might want to use for reporting and analysis. Ideally I'd want a user to access the Power App in a browser with a friendly UI, and then they can select the table they want to explore, run a query to show columns/rows in that table, and then export if they want to.

Was this reply helpful? Yes No
Suggested answer

Daniel Bocklandt 5,099 Super User 2025 Season 2 on at

Like (1)

Report

Okay I get it.

I think this Post should Help you out for the querry part : Type and Run a SQL Query inside PowerApps (powerplatform.com)

And this one should help you to create an excel file : Power Apps Export To Excel As A CSV File - Matthew Devaney

With the GetTables Action of The SQL connector you can also use a dropdown to select the table from and make it easyer for the user to create the Query.

If this answer solved your problem consider accepting it as solution.

If it helped in any other way or form give it a like so we can keep supporting eachother.

Was this reply helpful? Yes No