cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
User0987
New Member

Email to SharePoint repartization

Hello,

 

I have to create a flow that is triggered when I receive an email. Email's body and attachment have to be saved in SharePoint in a folder that is named by the sender.

 

 Bellow I attached my progress until now:

Annotation 095709.png

Annotation 101026.png

 Thank you!

7 REPLIES 7
Mira_Ghaly
Dual Super User II
Dual Super User II

@User0987 

Your flow logic looks fine but what part are you stuck in is it the extraction of the attachments from the Email?

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here
CFernandes
Super User
Super User

Hi @User0987 

 

You need to add some actions to your Power Automate to Save the attachments.

 

CFernandes_0-1598945427521.png

 

You might also want to have a look at the template and build on it https://unitedkingdom.flow.microsoft.com/en-us/galleries/public/templates/f7a46809e53c42108034e56acf...

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

 

@Mira_Ghaly 

The error occurs at the folder creation part or searching. Thing is I've just realised that I have to create a function that parse every sender's address by domain. So that a folder to contain every email from a company and not every email from every worker in a company

Mira_Ghaly
Dual Super User II
Dual Super User II

@User0987 

To create the folder name by domain you can use the split function as below

split('senderemail','@')[1]

 

Also can you share a screenshot of the History of your flow run that is failing.

 

If this post helps you with your problem, please mark your as Accepted solution.

If you like my response, please give it a Thumbs Up.

MG (Naturally Curious)

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here

@Mira_Ghaly 

 

There is no sign of error. The problem is that it does not run at all

Mira_Ghaly
Dual Super User II
Dual Super User II

@User0987 

By does not run do you mean it does not get triggered?

Or when you open the flow run history no steps are executed...

 

You need to use the below action instead of List Folder

Mira_Ghaly_0-1598950259770.png

Where outputs is the Folder Name , 

The use the below condition:

length(outputs('Get_files_(properties_only)')?['body/value'])

Mira_Ghaly_1-1598950316375.png

 

Then your condition will be as below

 

 

Mira_Ghaly_0-1598950396710.png

 

If yes than the folder exist , No folder does not exist

If this post helps you with your problem, please mark your as Accepted solution.

If you like my response, please give it a Thumbs Up.

MG (Naturally Curious)

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here

@Mira_Ghaly 

 

I am sorry. It was not quite helpful for my problem. 

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Top Solution Authors
Top Kudoed Authors
Users online (1,520)