File System - Create File > Content Missing

[ThomasKick]

Hi There, 

I am using File System - Create file to create a file on a local drive. Name and Content of the file come from a SharePoint file. Thereafter I'm moving the SharePoint file to a different folder.

Most of the time the files is created perfectly incl. name and content. However, sometimes the file is created with the name only the content  of the file is missing. I was wondering if someone else also had this issue. And moreover how and if this can be solved.

Thanks. Thomas

[eric-cheng]

Hi @ThomasKick ,

With the ones that failed:

1. Does it work if you rerun the flow?

2. Do you create multiple files at the same time?  Is the data gateway overloaded?

3.  How big are the files?  There are size limits with the data gateway and file system connector

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

[ThomasKick]

Hi @eric-cheng,

Thank you for your response.

1. Does it work if you rerun the flow?

** Unfortunately this is not possible because the flow is triggered 'when a file is created in a folder'. In the flow this file is moved to a different location. Retriggering it would fail because of a missing document.

2. Do you create multiple files at the same time?  Is the data gateway overloaded?

** The flow was indeed triggered 4 times at almost the same time when this issue occured. This means it was creating 4 files at the same time. Could this cause a gateway overload?

3.  How big are the files?  There are size limits with the data gateway and file system connector

** The files CSV files of only 1KB. I hope this does not exceed any limit:)

[ThomasKick]

@eric-cheng while I was just thinking about point two you mentioned. Would you think that Concurrency control in the trigger settings might solve this isssue? Do you have any experience with this setting?

[eric-cheng · Accepted solution]

Hi @ThomasKick ,

Hard to say but at 1 kb, i wouldnt have thought so.

Can you go to your trigger settings, enable concurrency control and set parallelism to 1. This will force the trigger to execute one by one.  See if you still get errors.

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn 

[ThomasKick]

@eric-cheng I will add that to the flow to see if this will solve the issue from happening. Thank you for the eye-opener.