How to convert Excel file with multiple sheets to CSV at once using logic app?

S, Abeeya - Mindtree LTD 21 Reputation points
2021-08-16T06:51:39.567+00:00

Hi!

Im new to logic app and want to convert Excel file with multiple sheets to csv at once using logic app , Im able to convert perticular sheet(only 1 at a time) from excel file to csv but not all of them at once. Any help/suggestion would be appreciated

Thanks in advance

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
2,895 questions
0 comments No comments
{count} votes

Accepted answer
  1. MayankBargali-MSFT 69,421 Reputation points
    2021-08-16T10:28:44.34+00:00

    @S, Abeeya - Mindtree LTD If you are using Get Tables action then it returns all the tables in any of the worksheets. You can now loop in through the output of Get Tables action and use"list rows present in a table" action.

    123582-image.png

    On the Table option Select Enter custom value and Select the dynamic content Name of your previous "Get Tables" action.

    123622-image.png

    As you have already mentioned that you were able to convert one table to csv. The next actions should be inside the same for loop to save the table rows to csv.

    0 comments No comments

0 additional answers

Sort by: Most helpful