Azure Logic App - FTP management

%3CLINGO-SUB%20id%3D%22lingo-sub-1433472%22%20slang%3D%22en-US%22%3EAzure%20Logic%20App%20-%20FTP%20management%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1433472%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20building%20a%20logic%20app%20with%20the%20FTP%20connector%20to%20do%20the%20following%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E-%20Monitor%20for%20new%20files%26nbsp%3B%3C%2FP%3E%3CP%3E-%20Move%20files%20to%20vendor%20folder%20depending%20on%20Prefix%2Fsuffix%20(done%20with%20a%20condition)%3C%2FP%3E%3CP%3E-%20If%20file%20exists%2C%20get%20content%20of%20file%20and%20add%20it%20to%20existing%20file%20(Done)%3C%2FP%3E%3CP%3E-%20Delete%20new%20file%20(done)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENow%2C%20I%20need%20to%20do%20this%20for%20300%20vendors.%26nbsp%3B%20I%20wonder%20if%20there%20is%20a%20simpler%20way%20to%20map%20the%20prefix%20and%20vendor%20folder%20without%20having%20to%20create%20a%20bunch%20of%20code%20300%20times.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20would%20be%20the%20best%20approach%3F%26nbsp%3B%20I%20have%20limited%20skills%20in%20coding%20and%20would%20appreciate%20the%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHopefully%20this%20can%20be%20done.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1433472%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1433483%22%20slang%3D%22en-US%22%3ERe%3A%20Azure%20Logic%20App%20-%20FTP%20management%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1433483%22%20slang%3D%22en-US%22%3EWith%20Azure%20Logic%20Apps%20and%20the%20FTP%20connector%2C%20you%20can%20create%20automated%20tasks%20and%20workflows%20that%20create%2C%20monitor%2C%20send%2C%20and%20receive%20files%20through%20your%20account%20on%20an%20FTP%20server%2C%20along%20with%20other%20actions%2C%20for%20example%3A%20Monitor%20when%20files%20are%20added%20or%20changed.%20Get%2C%20create%2C%20copy%2C%20update%2C%20list%2C%20and%20delete%20files%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1433646%22%20slang%3D%22en-US%22%3ERe%3A%20Azure%20Logic%20App%20-%20FTP%20management%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1433646%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F493704%22%20target%3D%22_blank%22%3E%40Lewis-H%3C%2FA%3E%26nbsp%3Bthanks%20for%20the%20response.%26nbsp%3B%20I%20have%20done%20most%20of%20the%20tasks%20I%20need.%26nbsp%3B%20I%20just%20wonder%20how%20I%20can%20adapt%20it%20to%20monitor%20for%20300%20different%20prefixes.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELike%20if%20file%20starts%20with%200900%20move%20to%20folder%20vendor1%20and%20remove%20prefix%20on%20moved%20file.%20or%20if%20prefix%20is%200901%20move%20to%20folder%20vendor2%20and%20remove%20prefix%2C%20and%20so%20on...%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1438320%22%20slang%3D%22en-US%22%3ERe%3A%20Azure%20Logic%20App%20-%20FTP%20management%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1438320%22%20slang%3D%22en-US%22%3E%3CP%3EAnyone%20know%20how%20I%20can%20use%20a%20table%20to%20map%20prefixes%20with%20folders%20and%20use%20those%20to%20move%20my%20files%20around%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hi all,

 

I am building a logic app with the FTP connector to do the following:

 

- Monitor for new files 

- Move files to vendor folder depending on Prefix/suffix (done with a condition)

- If file exists, get content of file and add it to existing file (Done)

- Delete new file (done)

 

Now, I need to do this for 300 vendors.  I wonder if there is a simpler way to map the prefix and vendor folder without having to create a bunch of code 300 times.

 

What would be the best approach?  I have limited skills in coding and would appreciate the help.

 

Hopefully this can be done. 

 

Thanks in advance!

3 Replies
With Azure Logic Apps and the FTP connector, you can create automated tasks and workflows that create, monitor, send, and receive files through your account on an FTP server, along with other actions, for example: Monitor when files are added or changed. Get, create, copy, update, list, and delete files

@Lewis-H thanks for the response.  I have done most of the tasks I need.  I just wonder how I can adapt it to monitor for 300 different prefixes.

 

Like if file starts with 0900 move to folder vendor1 and remove prefix on moved file. or if prefix is 0901 move to folder vendor2 and remove prefix, and so on...

Anyone know how I can use a table to map prefixes with folders and use those to move my files around?