Answered

Route attachments from email into a SharePoint library (folders) when there are 130+ locations

(1) Share

Report

Posted on by DS1

We have an shared email inbox where emails (with multiple attachments) come in with a subject line with the location number in it. There are 130+ locations. We want to route the attachments to a SharePoint document library, and were thinking we could create 130+ folders and according to which location it is, the attachments would drop into the corresponding location SharePoint folder.

However, creating 130+ conditions/apply to each would make for one hefty Flow!

Is there a better way with this scenario?

I was thinking to create a column for the location, and have the Flow update the file properties to place the location number in the column and then group by location in the SharePoint library view, but there are going to be a lot of files here and a grouping view may not eventually work very well as the library eventually gets to 5000+ files.

Any ideas on this one? I'd appreciate any guidance on this, thanks!

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (2)

Sort by

Verified answer

trice602 16,244 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi there!

I found a sample flow I had and modified it to show you the steps. Essentially you can use substring to get the location out of the subject line using a compose.

In my example, the location is the first 6 characters of the subject but there are a TON of ways to get the exact location and exact location details. Easy peasy.

So you don't need to have 130 conditions, one create file action will work. Again, this is just an example and here I'm only working with pdf attachment files so you may not even need the condition.

But in the create file action, part of your hard-coded URL will contain the dynamic content from the subject for your location#.

------------------------------------------------

⭐ If this was helpful, please like and check the box below "Does this answer your question" to help others find this too!

Always glad to help! 💯💯💯💯💯

Tom

Follow me on LinkedIn - Thomas Rice, PMP | LinkedIn

3 people found this reply helpful.

Was this reply helpful? Yes No
Verified answer

trice602 16,244 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Here's another variation:

Here I know that my Subject always includes "Location#" in the subject and I want the number 6 characters after it to get 123456 such as

Location# 123456

So know my compose substring expression is

substring(triggerOutputs()?['body/subject'],add(body('Find_text_position'),11),6)

the length of "Location# " is 10

so I want to start in position 11 and get the next 6 characters.

3 people found this reply helpful.

Was this reply helpful? Yes No
DS1 48 on at

Like (1)

Report
Copy link

Link copied!

Thanks very much, @trice602 - going to test these out. Much appreciated!

Was this reply helpful? Yes No