Logic Apps — How To Convert Excel File To a CSV File During Copy

This article shows how logic apps can be used to convert an excel file to a csv file before copying to ADLSG2.

Use Case:
An excel file is uploaded daily by a team in Microsoft teams folder. The excel file needs to be copied into Azure Blob Storage for further processing.
Teams location:
📌Location — Group-Data Engineer
📌Document Library — Documents
📌File location — /Logic Apps/medium excel.xlsx

Requirement:
As a Data engineer, I need to build a data pipeline that should locate the excel file and convert it to a csv file while copying from a Microsoft Teams room to ADLSG2.

Step 1: Create a New Logic App With a Daily Trigger

Every Logic app that needs to be built requires a trigger. For our use case, I will use a Schedule trigger that will be triggered daily as shown below.

Step 2: Get All Rows From Excel File

Search and select ‘List rows present in a table’ action. Fill out the information in the fields as shown below:

1. Location- Group — Data Engineer
2. Document Library — Documents
3. File — /Logic Apps/medium excel.xlsx
4. Table — Table1

(Test Data)