Copy Data to CSV file:Logic app

Rohit Kulkarni 441 Reputation points
2021-03-10T11:58:56.913+00:00

Hello Team, I want to copy the data from AzureSynapseAnalytics table(Table1) to csv file in the local system(Path :\DESKTOP-PLN2ARA\File).I have created a logic apps. Please refer my logic app screenshot :

76361-image.png

Once i ran the logic app. I got error in Create file Please refer to the screenshot:

![76239-image.png][2]

[2]: /api/attachments/76239-image.png?platform=QnA Thanks RK

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

Accepted answer
  1. Leo Erlandsson 1,656 Reputation points
    2021-03-10T12:31:21.517+00:00

    Hi,

    I assume you are running your Logic App in Azure?

    It looks like your file path (\DESKTOP-PLN2ARA\File) points to a Windows Share on your local Desktop computer. I guess this will not work.

    Br,
    Leo


1 additional answer

Sort by: Most helpful
  1. MayankBargali-MSFT 69,991 Reputation points
    2021-03-10T12:56:11.66+00:00

    Hi @Rohit Kulkarni

    As per the screenshot looks like you are using create file action of azure file connector and passing the folder path as the local path which is not supported as you need to specify the azure file path. There is no connector that can help you to save the file in your local path.

    If you still want to use logic app workflows the alternative would be saving the file in azure file or storage. Create your custom logic/code that would be running in your local machine to copy the files from storage/azure file to your local path. To automate you can schedule the task on your local machine which will trigger your custom exe, code/logic.