Creating a Folder Structure based on Subject Line

[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.

[DamoBird365]

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

[DamoBird365 · Accepted solution]

Hi @tdktyson 

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

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

Damien

[tdktyson]

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

[DamoBird365]

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

[tdktyson]

I am here is everything I have so far

[DamoBird365]

Hi @tdktyson 

This is what you are looking for:

What does your flow history look like?

Damien

[tdktyson]

[tdktyson]

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