How to move multiple files at once from Logic App (from SFTP to Azure File share)?

Question

How to move multiple files at once from Logic App (from SFTP to Azure File share)?

Anonymous

I have a Logic App that is working fine when it moves one file from SFTP to Azure File share.
But I am not sure how to modify this Logic App so that it could move multiple files whenever there is/are update from source area (SFPT).

This is what I have in Logic app:

There is going to be average 2 new files moving into a SFTP folder from third party on a daily basis.
I guess I could try by running every 12 hours, but I am not sure that is only solution.

What I am trying to do is, run once a day and grab everything (at least 2 new files) at once.
How do I go about doing this?

Also, I am curious how does Logic App understand/recognize which one is a new file? What is the technology behind which one to grab?

@MayankBargali-MSFT I am putting your attention here just in case.

2 answers

Your answer

Answer 1

Kamlesh Kumar 3,871

Hi @KingJava ,

Did you try to get the list of files and then using the loop create files to Azure File Share?

Something like below flow it should work.

Anonymous

2022-06-20T21:57:32.9+00:00

@Kamlesh Kumar
Thank you for your help.
I have three questions:

1) What is point of indicating "Body" on the "For each"?

2) This is what I have. Does it look ok?

3) What does "Infer Content Type" mean?
Anonymous

2022-06-20T22:53:28.9+00:00

@Kamlesh Kumar
Thank you for your help.
It really helped!

I have three questions:

1) What is point of indicating "Body" on the "For each"?

2) Bottom is what I have. Does it look ok?

3) What does "Infer Content Type" mean?
Kamlesh Kumar 3,871 Reputation points

2022-06-21T01:58:05.257+00:00
Hi @KingJava Thanks for an update and glad to know given solution helped you.

Please find my comment for asked 3 questions,

In "For each" you have to pass the output from previous steps so it'll executes a block of actions for each item in the input array. As you are selecting List files in folder so it'll give you the array output.

Instead of File name, I would suggest choose Path like below screenshot.

"Infer Content Type" property handling content types in Logicapp. By default it'll be Yes. Read more about this here => https://learn.microsoft.com/en-us/azure/logic-apps/logic-apps-content-type
Anonymous

2022-06-21T17:28:02.467+00:00

@Kamlesh Kumar

Thanks for help. I have two questions.

1)
On the "Get file content", if I change from "File name" to "Path", what is difference/what is going to happen?
I guess my bottom line question is 'what is purpose of "Get file content" step '?

2) I am going to try "Yes" on the Infer Content Type. I read the article, but I did not understand the implication between "No" and "Yes".
Kamlesh Kumar 3,871 Reputation points

2022-06-21T18:30:59.637+00:00
If you use the "Name" instead of "Path" then it'll unable to find the content and you'll end-up with error "Not Found" like below screenshot. But if you use the "Path" then it'll take the full file location and get the content of file like screenshot-2

Here let me explain you the diff if Infer Content type "Yes" & "No"
When Infer Content Type is 'Yes'

When Infer Content Type is 'No'
Anonymous

2022-06-22T18:01:48.977+00:00

@MayankBargali-MSFT
I am still having an issue with the process as somehow, For Each does not work.
Can we possibly have a session?
Thanks!

Answer 2

@MayankBargali-MSFT

Thank you so much for your help.
As per your chat, this was the reason that my previous pipeline did not work.
https://learn.microsoft.com/en-us/azure/connectors/connectors-sftp-ssh#polling-behavior

This is configuration that I modified (uncheck/disable "Preserver timestamp") in Winscp.

This is current pipeline that works: (I did not have to use Loop).

This is setting (no need to change anything, just leave as Default on Concurrency):

Share via

How to move multiple files at once from Logic App (from SFTP to Azure File share)?

2 answers

Your answer