Save ONLY excel attachments from mail

[frixel]

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.

[AlanPs1 · Accepted solution]

Hi @frixel , thank you for your post.

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

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.

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

[frixel]

Thanks for you reply. See the error here.

how can i resolve this?

[frixel]

I think a hick up now succeeded.

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

[AlanPs1]

Perfect!

Please click "Accept as Solution"

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

Any questions, just ask.

Thanks, Alan

[frixel]

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

[frixel]

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

What must i fill in here?

[AlanPs1]

Put .xlsx at the end

[frixel]

So?

[AlanPs1]

Nope. On the file name. Not content

[AlanPs1]

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

[AlanPs1]

Hi @frixel .

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

Thanks, Alan

[frixel]

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

I don`t know what i do wrong.

[AlanPs1]

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.

[AlanPs1]

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

[manuelatarabuta]

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?

Many thanks,

Manuela

[Faiz0102]

Thanks Bro , it helped me a lot. Love U

[revenuemgmt101]

I'm able to run a few flows without fail, however when I run a flow the excel file does download but it is downloading in a 1KB size, then when opening it renders this pop up message. Any advice? @AlanPs1 

[Mario_Schneider]

I have the same Issue as @revenuemgmt101 . Does anybody have a solution yet?