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

Sridhark — Thu, 20 Feb 2025 14:05:27 GMT

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.

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

Brahmareddy — Mon, 24 Feb 2025 19:01:31 GMT

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

topic Re: how to upload excel file from power apps to databircks notebook folder in Data Engineering

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

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