cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
GMI
New Member

CSV Table -> 'FTP create file' will remove line feeds in csv file

Hi,

I created some flows to collect data from Sharepoint lists, create csv tables and finally create a csv file on a FTP server.

All my flows are running fine for weeks.

Suddenly every 'FTP create file' task failed. I got this error message :

 "Another active upload session exists, please retry after some time"

 

On the FTP server I found this content: (expected filename is news.csv)

news.csv.b971ff0a-ae99-4951-a8fa-1a13a9514f5b.ms.partial

news.csv.b971ff0a-ae99-4951-a8fa-1a13a9514f5b.ms.partial.ms.lock

 

I found out that after I disabled the "chunking" in the task settings the flows runs properly again:

 

But now all the content of the csv file is written in one line without carriage return for each row in the list:

date,Title2018-03-07,Stellenangebot Einsatzleiter Betriebsfeuerwehr / Mitarbeiter Werkschutz2018-02-21,Unfallgeschehen Januar 2018....blabla...

 

instead of:

date,Title
2018-03-07,Stellenangebot Einsatzleiter Betriebsfeuerwehr / Mitarbeiter Werkschutz
2018-02-21,Unfallgeschehen Januar 2018.... blabla...

 

 Any Idea on this?

2 REPLIES 2
Community Support
Community Support

Re: CSV Table -> 'FTP create file' will remove line feeds in csv file

Hi @GMI,

 

Could you please share a screenshot of your flow's configuration?

 

I have made a test on my side and the CSV file opens well. My flow's configuration as below:

  • Add a proper trigger, here I use Flow Button trigger.
  • Add a "Get items" action, specify Site Address and List Name.
  • Add a "Create CSV table" action, From set to output of "Get items" action, Include headers set to Yes and Columns set to Custom. Within Header and Value map entry, type the entries as below:4.JPG

     

  • Add a "Create file" action of OneDrive for Business connector (for testing), specify Folder Path, File Name field set to News.csv and File Content field set to output of "Create CSV table" action.

Image reference:5.JPG

 

6.JPG

 

The flow works successfully as below:7.JPG

 

8.JPG

 

On your side, you should change the "Create file" action of OneDrive for Business connector into "Create file" action of FTP connector, File name field set to News.csv and File content field set to output of "Create CSV table" action.

 

Please take a try with above solution and check if the issue is solved on your side.

 

Best regards,

Kris

 

 

 

 

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
GMI
New Member

Re: CSV Table -> 'FTP create file' will remove line feeds in csv file

Hi Kris,

 

Thank you for your reply.

That is exactly what I have done. My flow has two parallel tasks at the end. On creates a file on OneDrive and the other creates a file with the same content on the ftp-server. The file in OneDrive is ok. But the file on the ftp server is corrupt.

 

PS: I try to add some screenshots but I cannot find out how. There is no button for this. I've uploaded a screenshot to my Image Library. But I cannot add it to a post.

 

Kr,

Michael

Helpful resources

Announcements
firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Automate Community!

firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Users online (7,698)