Unanswered

how to insert data from databricks table into power apps.

(3) Share

Report

Posted on by sridharbabuk

having data in databricks table, bring the data from databricks table into power apps. Having a drop down in power apps. has to show data in dropdown in power apps.

could anyone please help me in this.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Jon Unzueta 1,827 Super User 2025 Season 2 on at

Like (3)

Report
@sridharbabuk

To bring data from a Databricks table into Power Apps and display it in a dropdown, you can now use the native Azure Databricks connector in Power Platform, which is currently in Public Preview. Here's a step-by-step guide to help you set this up efficiently and reliably:

✅ Step-by-Step: Populate Power Apps Dropdown from Databricks Table

1. Prerequisites

Azure Databricks workspace with access to a SQL Warehouse

Power Apps Premium license

Microsoft Entra ID (formerly Azure AD) account

Optional: Service Principal if cross-tenant access is needed

2. Connect Power Platform to Databricks

Use the new Azure Databricks connector:

Go to Power Apps or Power Automate

Add a new data connection

Search for Azure Databricks

Authenticate using OAuth or a Service Principal

Select your SQL Warehouse as the data source

🔗 Microsoft Docs: Connect Azure Databricks to Power Platform

3. Query Databricks Table

Use Power Automate to run a SQL query against your Databricks table:

Create a flow with the Databricks SQL query action

Example query:

SELECT id, name FROM your_table ORDER BY name
Store the results in a variable or array

4. Pass Data to Power Apps
Use the “Respond to Power Apps” action in Power Automate to send the query results back In Power Apps, call the flow using PowerAutomate.Run() and bind the result to the dropdown

5. Bind Dropdown in Power Apps

In your dropdown control:

Items = YourFlowName.Run().value

To show names and store IDs:

Items = YourFlowName.Run().value

DisplayFields = ["name"]

Value = "id"

⚠️ Limitations & Best Practices
Performance: Keep queries lightweight. Avoid joins or large result sets. Security: Use Unity Catalog for fine-grained access control. Governance: All access is logged via Databricks Query History. Dropdown Size: If the dataset is large, consider pagination or search-enabled dropdowns.

🏷️ Tag me if you have any further questions or if the issue persists.

✅ Click "Accept as Solution" if my post helped resolve your issue—it helps others facing similar problems.

❤️ Give it a Like if you found the approach useful in any way.

Was this reply helpful? Yes No
Cgangweg01 727 Super User 2025 Season 2 on at

Like (1)

Report

Hello @Jon Unzueta

I will try to pass data from Power Automate to Power Apps as I got the Azure Databricks connector to work there in Power Automate. Was wondering if you have been able to connect Azure Databricks connector directly as a data source within Power Apps?

I get the following error:

Was this reply helpful? Yes No