SOLVED - Save filtered attachments to SharePoint by differents senders

[Vyperium]

Hello everyone,

I'm currently working to automate most of the incoming mails we receive at my office.

The first project is to save every attachments in PDF or XLSX in a SharePoint folder. 

It's look like the following image and it's working like a charm !

Now, I want to go deeper and create files in differents folders in SharePoint , filtered by the domain name of the e-mail sender.
For example, my client A send me an e-mail with an attachment , then it goes to folder A in SharePoint and my attachment from my client B goes to folder B to simplify things.

I tried differents setups before asking for help, but I'm out of solutions right now !

I tested with a "Control > Switch".
The problem I encounter is the case should equals to an exact address. 
I have several clients from the same company and would prefer a condition with the domain name, than adding a case for every email address they have.

Next, I tried with a "Control > Condition" .
I can choose a value who contains my domain name , and I shoul be set.
But I'm talking with 23 differents clients and I can't set 23 loops of " If sender A then go to A , else IF sender B then go to B, else if ...etc"

Finally, my last attempt was to setup an expression in the " When a new email arrives" trigger.
According to the topics I read before posting, it's working for a single domain name.

Do you have any idea how to improve this flow ?

Thanks for your help !

[v-chengfen-msft]

Hi @Vyperium ,

Do you want:
1. Create a folder based on the domain name of the sender's mailbox
2. Put email attachments into the corresponding folder?

Here is a test for your reference:

Here is folder:

Here is flow:

last(split(first(split(triggerOutputs()?['body/from'],'.com')),'.'))

It can split the mailbox: aaaa@test.atest.com into test.atest

Here is result:

It is test email

Best Regards

Cheng Feng

[Vyperium]

Hey Cheng !

Thanks for the reply. 
Yes, I'm trying to do both.
My project is to save attachments from differents senders in the according folders, filtered by the domain name of the company if it make sense.

EDIT :
I tried your expression, and I have "fr" as a result from an e-mail like aaaa@test-testing.fr
I also tried with a aaa.bbb@gmail.com and it returns me bbb@gmail.

Am I missing something ?
Can you explain a bit more the expression you got ? please

I'm really enjoying my experience with Power Automate so far. I try to improve as much as possible 🙂

[Vyperium · Accepted solution]

Hello,
After hours of trial and error, and reading the expression course available on Microsoft Learn... It's working !

I had to put 2 composes instead of one, as you can see in the following picture :

If someone is interested, here is the expressions I used :
First compose : last(split(triggerOutputs()?['body/from'],'@'))
Second compose : first(split(outputs('Compose'),'.'))
I also added the output of the "Compose 2 " in my SharePoint path just like you and it's finally OK.

I tried to fuse the two compose in one , but I still can't figure it out after 2 hours of trying.

Anyway , thanks a lot for your help !

[v-chengfen-msft]

Hi @Vyperium ，

Could you please tell me the approximate format of the email?

I assume a mailbox: test@test.aa.com

If you use '. 'as a separation,
for example: [test@test.aa.com] will become the three parts of [test@test] [aa] [com],
so I recommend using '.com', [test@test.aa.com] will becomes [test@test.aa].
Then separate [test@test.aa] by ‘@’ to get: [test] [test.aa], we can get the latter one.
So the Finally formula is: last(split(first(split(triggerOutputs()?['body/from'],'.com')),'.'))

Best Regards

Cheng Feng

[Vyperium]

Hey @v-chengfen-msft,

I have differents formats for my e-mail :
-aaa.bbb@test.com
-c.ddddddd@toto-net.fr

First,I cut the part before the '@' . As a result, I have the domain name with the extension ' test.com' or 'toto-net.fr'
Second, I'm filtering with the '.' separator and I finally have the thing I wanted ... the domain name alone ! 🙂

I will keep the 2 composes, it's easier to explain for everyone.

My subject is solved, thanks a lot for your help !