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
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (1,932)