Unanswered

Download specific email attachment and post to sharepoint

(0) Share

Report

Posted on by gabequinn__

I receive an email every week and post the attachment (report 1) to sharepoint. However, the user also has other attachments in the email (report 2 and email signature that is a picture). Is there a way to only download and post report 1 and ignore report 2 and the email signature?

All responses (6)

Answers (0)

gabequinn__ 32 on at

Like (0)

Report

Re: Download specific email attachment and post to sharepoint

I tried that. It says it successfully posted but now there is no file in the sharepoint site. So confused.
Unknown geen idee 1,755 on at

Like (0)

Report

Re: Download specific email attachment and post to sharepoint

Did you put an '.xlsx' behind the filename?
gabequinn__ 32 on at

Like (0)

Report

Re: Download specific email attachment and post to sharepoint

Thanks @Koen5 !

I did that but when I post the attachment to sharepoint, its not in Excel format (like the attachment) but in a File format. Thoughts?

Here's the flow and the resulting file
Unknown geen idee 1,755 on at

Like (0)

Report

Re: Download specific email attachment and post to sharepoint

Dear Gabequinn,
I gave it a try myself and realized that the output from the trigger is already an array with the attachments .... hence you do not need to use a 'Get attachments' actions.
View example below and you should be good:

Happy flowing,
Koen
gabequinn__ 32 on at

Like (0)

Report

Re: Download specific email attachment and post to sharepoint

Thanks for the response @ko

I tried get attachments and got the error "ID malformed"

Here is what it looks like currently:

Thoughts?
Unknown geen idee 1,755 on at

Like (0)

Report
Re: Download specific email attachment and post to sharepoint

Dear Gabequinn,
I assume you are using a trigger "When new email arrives" or an action "Get emails" for Outlook.
If the attachment you need to get always has the same name ... or has a name-syntax which you can predict, then you should be able to use the following sequence of actions:
Get attachments
This will get you an array output of all the attachments.
Filter array
Filter the output from the previous action based on your filename/filename syntax.
... use the output of filter array in your ongoing actions ... for example to save the attachment in the sharepoint.

Hope the suggestion helps,
Happy flowing,
Koen