Hoe to read the uploaded excel from a storage blob and process the data using logic app

Question

How to read the excel file which is uploaded in storage bob and process the data and execute sql query using logic app

Answer 1

Hello @Pragiri

To read an Excel file uploaded in a storage blob and process the data and execute SQL query using Logic App, you can follow the below steps:

1. Create a new Logic App in the Azure portal and select the trigger as "When a blob is added or modified (properties only)".
2. Select the storage account and container where the Excel file is uploaded.
3. Add a new action "Get blob content" and provide the path of the Excel file.
4. Add a new action "List rows present in a table" and provide the Excel file content from the previous step.
5. Select the table name and worksheet name from the Excel file.
6. Add a new action "Execute a SQL query (V2)" and provide the SQL query to execute.
7. Save and run the Logic App. This will read the Excel file uploaded in the storage blob, process the data and execute the SQL query. You can also add additional actions to perform other operations based on your requirement.

---

I hope that this response has addressed your query and helped you overcome your challenges. If so, please mark this response as Answered. This will not only acknowledge our efforts, but also assist other community members who may be looking for similar solutions.