Power Platform Community Forum Thread Details

Hello Community..

I'm new to copilot and i want to convert natural language into sql query and need to need to extract data from skema and display in powerapps. Is it possible in copilot to convert and use.

Thank you

Categories:

Building Power Apps

@CU10010527-0

Yes, what you're aiming to do—convert natural language into SQL queries and use that to extract data from a schema and display it in Power Apps—is absolutely possible with the right setup. Here's how you can approach it:

✅ What You Can Do with Copilot + Power Apps + SQL
1. Use Copilot to Generate SQL Queries
Copilot (like me!) can help you convert natural language into SQL. For example:
You say: “Show me all employees who joined after 2022.”
Copilot gives:
You can then use this query in your app or backend logic.

2. Connect Power Apps to SQL Server
To display SQL data in Power Apps:

Use the SQL Server connector (with Azure SQL or on-prem via gateway).
Create a view or stored procedure in SQL Server if needed.
Bind the data to a Gallery, Data Table, or Form in Power Apps.

3. Use Power Apps Copilot Studio (Preview)
If you're using Power Apps Copilot Studio, you can describe what you want in natural language, and it will help you:

Create tables
Generate forms
Suggest logic
Even build screens

Example: “Create an app that shows customer orders from the last 30 days.”

🛠️ Tools You’ll Use

Power Apps Studio (for building the UI)
SQL Server / Azure SQL (your data source)
Copilot in Power Apps (for natural language to app logic)
Copilot in SQL Server Management Studio or Azure Data Studio (for SQL generation)