Moving files based on file name

[Abhoward17]

Hi Folks, 

Im hoping you can help me/offer me some guidance on how best to create a flow.

• Incoming post is scanned into shared SharePoint location using Kodak i4250 Scanners. (items will be renamed to the a persons name at the point of scanning eg, Tom Smith)
• Once a new file is added in the SharePoint folder, trigger the flow to move the file into another folder in SharePoint based on the file name. (Each person in the business has a folder named after them in a collaboration drive and i want to drop the files into a sub folder of their named folder Eg Collab drive > Tom Smith > Post).
• Once the file has been moved > send an email to the person who has received mail notifying them that they have a new item in their folder.
  
  I have approximately 100+ members of staff to issue mail to and dont want to set up a flow for each user, i have read about using conditions and expressions but im unsure how best to have one flow that will move a file based on its name to the correct location. 
  Any help is appreciated. 🙂 
  
  Amy

[schwibach]

If these folders already exists, you will need a table (SharePoint list) matching the folder names with the string in your file names and the respecive email addresses.

Then, whenever a file is created, you can look for the correct row in the table, get the folder name then, move the file to that folder and send an email to the email address from the same row.   

[Abhoward17]

For anyone struggling with something similar on this one, i managed to get half way there and move the file into the relevant folder based on the file name listed as the end user. 

When a file is created in a folder > This is where scanned items are dropped into

Move file > Show where the file currently is and select select where is needs to go. 
The expression used is: 

first(split(base64ToString(triggerOutputs()?['headers/x-ms-file-name-encoded']),'.'))

This allows for files that are named with a first and last name only to be moved into the corresponding folder of that person.