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)
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...
2018-03-07,Stellenangebot Einsatzleiter Betriebsfeuerwehr / Mitarbeiter Werkschutz
2018-02-21,Unfallgeschehen Januar 2018.... blabla...
Any Idea on this?
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:
The flow works successfully as below:
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.
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.
Learn how to create your own user groups today!
Check out the new Power Platform Community Connections gallery!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.