how to upload excel file from power apps to databircks notebook folder

[Sridhark]

Hi All,

User uploads an excel file from power apps interface, excel file has to store in databricks folder and  insert the excel data into sql table, storing excel file in databricks and inserting data has to go through power automate. Please suggest some steps on it.

[Brahmareddy]

Hi @Sridhark 

How are you doing today? As per my understanding, You can achieve this by setting up a Power Automate flow that triggers when a user uploads an Excel file in Power Apps, storing it in OneDrive or SharePoint first. Then, use Power Automate to move the file to Azure Blob Storage, which Databricks can access. Once the file is in storage, trigger a Databricks notebook using the Databricks REST API, where you can read the Excel file with pandas or PySpark and insert the data into your SQL table. Finally, send a confirmation message via Power Apps or email once the process is complete. This keeps everything automated and seamless—hope this helps! 

Regards,

Brahma