cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
frixel
Level: Powered On

Save ONLY excel attachments from mail

Hello,

 

How can i make a Flow that save ONLY the excel files (.xlx, .xlsx) tot Sharepoint from a mail.

 

The Flow i now have saves also the images that are in the mail and that is not what i want.

 

flow4.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Save ONLY excel attachments from mail

Hi @frixel , thank you for your post.

I have acheived this by using a condition as below in my example using .pdf initially.capture-291.PNG

Using the new condition builder and adding to your own flow within "Apply to each" you could use the following to cover multipl excel file formats.capture-292.PNG

If you find my posts helpful, please mark with thumbs up

If this solves your issue, please click "Accept as Solution"

Any questions, just ask.

Thanks, Alan


Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!


14 REPLIES 14
Super User
Super User

Re: Save ONLY excel attachments from mail

Hi @frixel , thank you for your post.

I have acheived this by using a condition as below in my example using .pdf initially.capture-291.PNG

Using the new condition builder and adding to your own flow within "Apply to each" you could use the following to cover multipl excel file formats.capture-292.PNG

If you find my posts helpful, please mark with thumbs up

If this solves your issue, please click "Accept as Solution"

Any questions, just ask.

Thanks, Alan


Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!


frixel
Level: Powered On

Re: Save ONLY excel attachments from mail

Thanks for you reply. See the error here.

how can i resolve this?

 

flow5.png

frixel
Level: Powered On

Re: Save ONLY excel attachments from mail

I think a hick up now succeeded.

 

flow6.png

 

But hou to changed the flow when attachments hav the same name?

Super User
Super User

Re: Save ONLY excel attachments from mail

Perfect!

 

Please click "Accept as Solution"

 

If you found my posts helpful, please mark with thumbs up.

 

Any questions, just ask.

Thanks, Alan


Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!


frixel
Level: Powered On

Re: Save ONLY excel attachments from mail

But hou to changed the flow when attachments hav the same name?

frixel
Level: Powered On

Re: Save ONLY excel attachments from mail

Ahh, now i see that the attachments in Sharepoint are mismake and would not open.

What must i fill in here?

 

flow1.png

Super User
Super User

Re: Save ONLY excel attachments from mail

Put .xlsx at the end

Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!


frixel
Level: Powered On

Re: Save ONLY excel attachments from mail

So?

 

flow2.png

Super User
Super User

Re: Save ONLY excel attachments from mail

Nope. On the file name. Not content

Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!


Super User
Super User

Re: Save ONLY excel attachments from mail

In fact, in my example I haven't had to use a file extension on the attachment name.

Just see how you get on, you're not far away and I'm sure you'll get it.

any issues, just ask.

Thanks, Alan


Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!


Super User
Super User

Re: Save ONLY excel attachments from mail

Hi @frixel .

Do you now have your condition/Flow working as expected?

Thanks, Alan


Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!


frixel
Level: Powered On

Re: Save ONLY excel attachments from mail

No. it saves now the 2 attachments from the mail 8 times in the sharepoint.

I don`t know what i do wrong.

 

Super User
Super User

Re: Save ONLY excel attachments from mail

Ok. At one point today, I will build this from the ground up. I will address files of the same name also and I will post it a working example in a new post.

Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!


Super User
Super User

Re: Save ONLY excel attachments from mail

Hi @frixel 

You had asked "But hou to changed the flow when attachments hav the same name?"

 

Please see: https://powerusers.microsoft.com/t5/Flow-Cookbook/Save-Outlook-Attachments-And-Guard-Against-Duplica...

 

If you find my posts helpful, please mark thumbs up.

 

Thanks, Alan


Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!


Helpful resources

Announcements
firstImage

Microsoft Flow Online Conference

Join us for a FULL day of FREE Microsoft Flow Sessions from some of the best minds in the industry!

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020

thirdimage

Flow Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

thirdImage

New Flow Community Board!

Check out the new Microsoft Flow Community Blog Topic Suggestion board!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Flow Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 208 members 4,490 guests
Please welcome our newest community members: