Azure Logic App: FTP conditional file management

Question

Hello,
I am trying to create a logic app that can manage my ftp server. We have multiple vendors dropping files on our ftp server. Based on the prefix of the file, I would like to move it to a specific folder and strip the prefix/suffix once moved.

What would be the best way to tackle this? Also, would I have to create multiple conditions based on each vendor and suffix or can I create a reference for each vendor in a list/table?

Answer 1

Hello @MB69 There are multiple ways to implement this workflow using the SFTP - FTP connector depending on how frequently the files are uploaded and how big the file sizes are. I've put together the following workflow as a quick demonstration in hopes that it'll give you some ideas and get you started:

A few noteworthy items regarding this workflow are as follows:

• Trigger uses base64 encoding for keeping the data intact so be sure to use base64ToString() function to decode the data wherever needed.
• The vendor list is stored in an array collection: vendorCollection
• The vendor name is extracted from the trigger with @{split(base64ToString(triggerOutputs()['headers']['x-ms-file-name-encoded']), '_')[0]} and set as a value for the vendorName variable for reusability across subsequent actions.
• Condition check whether vendorName exists in the vendorCollection array. If true, workflow continues on to copy the file to a folder matching vendorName value and renames it with vendorName followed by deleting the original file that was uploaded.
• Condition to check is as follows: @contains(variables('vendorCollection'), variables('vendorName'))
• RunAfter is configured across "Copy File", "Rename File" and "Delete File" actions so that they run one after the other sequentally

In my example workflow above, I only strip the prefix which is assumed to be the matching vendor name but you can make slight adjustments to it for any desired format -- let me know if any further assistance is needed ;)