Flow to Create Files in Different SharePoint Folders Based on Keywords in Email Attachment Filenames

[ScottR-MT]

Hi,

As my subject line suggests, I would like to build a flow that will parse emails with multiple attachments (from Office 365 Outlook), and put the attachments into different SharePoint online Library folders, based on when the filenames contain the words Approved or Rejected.

Any ideas?

Thanks in advance!

[mydevexperience]

Hey,

Follow the below instructions:

Add "On new email with attachment (webhook)". Next add "Get email"

Next

Add apply to each and check condition "Attachment Name" contains "Approved"

 

Under the Yes and No condition add Create File (SharePoint) control

The site address is your SharePoint URL

Folder Path is your Document library name. Set the appropriate folder path for Yes and No condition to move the documents correctly.

I have tested this and it is working as expected. 

If you have any questions please let me know.

If you find it useful then mark it as solution.

Thanks

[v-yuazh-msft · Accepted solution]

Hi @ScottR-MT,

I have made a test on my side, please refer to screenshot below to create the flow:

Please make sure you have choose the "Attachments Content" dynamic content of the trigger in the "File Content" field of "Create file" action of sharepoint connector.

And please choose different folder for "Approved" or "Rejected" to save the attachment.

Best regards,

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mydevexperience]

Is that worked for you? If it is please accept this as solution to help others.

If you need any help please let me know.

Thanks

[ScottR-MT]

Thank you very much!  Just a couple of further questions...

The flow does not add the file extension when creating the files on the SharePoint in this flow.  How can I make the flow get the extension from the attachments automatically?

Also, I am adding the "Received Time" dynamic content to the beginning of the filename.  How can I reformat it to show the date as YYYY-MM-DD HH:MM:SS ?  Also, I want the time to be in my timezone.

[mydevexperience]

@ScottR-MT, have  look at this post

email attachment file manipulate