Flow with On Premises File System Connector

[peterof63]

I Want to create a folder on a local server using data from a SharePoint list and put some files in there. I made this very basic flow that illustrates the problem:

If the folder already exists this flow works fine and a file is created in the given subfolder. When it does not it throws an error. Now the documentation is very silent on this topic but elsewhere it was suggested that this should work as long as you're creating a file which is good enough for me.

Tried all kinds of syntaxes including basckslashes, full paths, dynamic variables etc. but nothing works: a folder is not created. The account has Full Controll rights over the given folder path.

Please advise.

[tfhegdbn]

Could you please share error message?

[peterof63]

This is what I get:

{

"status": 400,

"message": "The requested action could not be completed. Check your request parameters to make sure the path '/Subfolder2/Test.txt' exists on your file system.\r\nclientRequestId: be21ad71-60b5-45c8-9c47-2344da0d671c",

"source": "filesystem-we.azconn-we.p.azurewebsites.net"

}

[v-lin-msft]

Hi @peterof63,

I tested it on my side like you said create a new folder name in the file path name and create a new file, no problem. Below is a screenshot of my test.

It's important to note that the flow's flawed interaction with file path input, you need to enter a dynamic content when entering a new folder name, and then delete the dynamic content before entering your new folder name.

Best Regards,

Community Support Team _ Lin Tu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[peterof63]

Thanks for the suggestions but alas, it doesn't work here.

This is what I did:

1. I first verified that it works without a path to ensure that the gateway is indeed properly setup:
   
2. And indeed it does:
   
3. Then I added the dynamic variable:
   
4. Removed the dynamic variable and added the value I want for the actual folder (I also tried first adding the actual folder name and then removing the dynamic variable which didn't make any difference):
   
5. And tried to run the Flow again:
   
6. And again it fails...

{

"status": 400,

"message": "The requested action could not be completed. Check your request parameters to make sure the path '/Testfolder/Test.txt' exists on your file system.\r\nclientRequestId: 230e6b99-b031-49b9-8a4b-f1e80fb7f611",

"source": "filesystem-we.azconn-we.p.azurewebsites.net"

}

[peterof63]

Oops, I noticed that the first step in the sequence above shows the City dynamic variable already in there but it was not. So don’t think that it worked with that variable as it didn’t.

[v-lin-msft]

Hi @peterof63,

Sorry for the descrip of the steps:

It's important to note that the flow's flawed interaction with file path input, you need to enter a dynamic content when entering a new folder name, and then delete the dynamic content before entering your new folder name.

Change into :

It's important to note that the flow's flawed interaction with file path input, you need to enter a dynamic content when entering a new folder name, and then delete the dynamic content after entering your new folder name.

Best Regards,

Community Support Team _ Lin Tu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[peterof63]

Hi,

Thanks for the feedback but it still isn't working. Tried several variations on the order of entering dynamic variables and the desired path (delete before/after) but I keep having errors. Even tried using only the dynamic variable itself but even that's not working. This is what I got following your suggested sequence:

{

"status": 400,

"message": "The requested action could not be completed. Check your request parameters to make sure the path '/Testfolder/Test.txt' exists on your file system.\r\nclientRequestId: 7f5e6c73-941b-4abf-9584-c22c097bd5b9",

"source": "filesystem-we.azconn-we.p.azurewebsites.net"

}

Given that this seems to be a known problem for Microsoft, is there some fix being worked on?

[v-lin-msft]

Hi @peterof63,

This is my steps to creating a file, I think you have a problem with the root path:

Step1:

Step2:

Step3:

Step4:

Step5:

Step6:

Run result:

Best Regards,

Community Support Team _ Lin Tu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[peterof63]

Hi,

This is exactly as I tried it several times. Also variations on this sequence but none of them get me any further.

[peterof63]

I made a screen recording of the steps to show the exact steps I take to show you that I indeed follow the right steps in proper order.

Unfortunately I cannot upload a video on this platform.

[v-lin-msft]

Hi @peterof63,

You can convert the video into Gif file and upload it.

[peterof63]

Here it is:

[v-lin-msft]

Hi @peterof63,

Have you tried this way? Initialize a variable to store the value of the file path.

Best Regards,

Community Support Team _ Lin Tu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[peterof63]

Yes I did and that didn't work either.

[v-lin-msft]

Hi @peterof63,

Do you still have the problem in the excel file?

[peterof63]

I guess you're mixing up my question with someone else's?

Though I directly would want to inquire if there's any follow up on my issue?

[v-lin-msft]

Hi @peterof63,

About your question you can refer to this post:

https://powerusers.microsoft.com/t5/General-Flow-Discussion/File-System-Connector-Gateway/m-p/252307

Hope it will help you.

Best Regards,

Community Support Team _ Lin Tu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[peterof63]

Tried that before and it doesn't work (at least here it doesn't).

I guess I just ran into some Flow bug. Could it be a localization issue (I'm running a dutch environment)?

[v-lin-msft]

Hi @peterof63,

It should not a local issue. Have you tried to create a new connection in the file system?