Answered

Creating a Folder Structure based on Subject Line

(0) Share

Report

Posted on by tdktyson

So I am trying to use Power Automate To save the attachments in a email to a folder structure that is created each time a new email arrives based on the Subject line. Each email arrives like this. Blend Sheet Attached STULL, LONNY - HOME NORTH 2018 - WBV25SW7. I would like the Folder structure to then look like this. /Stull, Lonny/WBV25SW7/Rx/ And the attachments to then be saved in the RX folder. I got a lot of the rest figured out. Anyway thanks in advanced for helping.

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (1)

DamoBird365 8,942 Microsoft Employee on at

Like (0)

Report

Hi @tdktyson

I don't believe you can have folders with commas in them. You can replace the - with / replace the , with nothing and use it in the create folder action like so:

This created the following path:

Please consider accepting my answer as a solution if it helps to solve your problem.

Cheers
Damien

Please take a look and subscribe to my YouTube Channel for more Power Platform ideas and concepts, or take a look at my website. Thanks

Was this reply helpful? Yes No
Verified answer

DamoBird365 8,942 Microsoft Employee on at

Like (1)

Report

Hi @tdktyson

Quick update - you can have , in the path. Just tried it.

replace(outputs('Compose-Subject'),' - ','/') is my new expression.

Damien

Was this reply helpful? Yes No
tdktyson 11 on at

Like (0)

Report

I think I almost got it. But it is not separating into the sub folders.

Was this reply helpful? Yes No
DamoBird365 8,942 Microsoft Employee on at

Like (0)

Report

Hi @tdktyson

Are you using replace(outputs('Compose-Subject'),' - ','/') but instead of it being based on the compose, you run it on the subject and then use the output for the folder path, not the original subject, which you might be doing.

Damien

Was this reply helpful? Yes No
tdktyson 11 on at

Like (0)

Report

I am here is everything I have so far

Was this reply helpful? Yes No
DamoBird365 8,942 Microsoft Employee on at

Like (0)

Report

Hi @tdktyson

This is what you are looking for:

What does your flow history look like?

Damien

Was this reply helpful? Yes No
tdktyson 11 on at

Like (0)

Report

Was this reply helpful? Yes No
tdktyson 11 on at

Like (0)

Report

Never mind thank you so much had the wrong output in the folder line. Thanks again!

Was this reply helpful? Yes No