cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
frixel
Post Prodigy
Post Prodigy

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
AlanPs1
Resident Rockstar
Resident Rockstar

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!


View solution in original post

15 REPLIES 15
AlanPs1
Resident Rockstar
Resident Rockstar

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!


View solution in original post

Thanks for you reply. See the error here.

how can i resolve this?

 

flow5.png

I think a hick up now succeeded.

 

flow6.png

 

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

AlanPs1
Resident Rockstar
Resident Rockstar

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!


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

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

What must i fill in here?

 

flow1.png

AlanPs1
Resident Rockstar
Resident Rockstar

Put .xlsx at the end

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

Proud to be a Flownaut!


So?

 

flow2.png

AlanPs1
Resident Rockstar
Resident Rockstar

Nope. On the file name. Not content

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

Proud to be a Flownaut!


AlanPs1
Resident Rockstar
Resident Rockstar

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!


AlanPs1
Resident Rockstar
Resident Rockstar

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!


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

I don`t know what i do wrong.

 

AlanPs1
Resident Rockstar
Resident Rockstar

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!


AlanPs1
Resident Rockstar
Resident Rockstar

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!


Hi @AlanPs1 , your solution is great, I did applied too to save only excel files, however don't know for what reason within the Condition box the "attachments content" transform by itself in "current item" and the files are saved in a format not recognised by computer like in the picture... any ideas?

attachments.JPGfiles.JPG

 

Many thanks,

Manuela

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.

Top Solution Authors
Users online (2,395)