Sending email with attachment to OneNote?

[EdHans]

I am trying to create a flow that takes emails in our Office 365 account from a particular address to a page in OneNote. Getting the text there is no problem, but I cannot get the attachment.

I tried the "Content - Attachment content" from the dynamic content selector and added that to the OneNote component for Page Content, along with the email subject and attachment name.

The email subject and attachment name get there fine, but in stead of a usable attachment, I just get a ton of jibberish, like I've opened a PDF file in Notepad or something.

Is there any way to do this?

[v-yamao-msft]

Hi EdHans,

Could you show me a detailed screenshot of your flow configuration?

I have created a flow to create a page in a section in OneNote when a new email arrives. But I found that when I select the “Content-Attachment content”, the flow would be failed with the error “Invalid Template”. Without the “Content-Attachment content”, the flow would run succeed and a page can be created.

With the “Content-Attachment content”, the flow failed:

Without the “Content-Attachment content”, the flow succeed:

It seems that the Attachment content from an email is not supported in the action “create page in a section”. If I understand you correctly, may I suggest you submit an idea at Flow Ideas Forum:
https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

Best regards,
Mabel Mao

[EdHans]

Hi Mabel,

My flow can be seen at this link.

It seems to be the same as yours, but I jsut got a note hundreds and hundreds of rows long with jibberish in it where it looked like the binary attachment was converted to text. It was a PDF.

[v-yamao-msft]

Hi EdHans,

Thanks for your reply. Could you provide the screenshot of the error message for a further investigation?

I run the flow again, but I am still getting the error message I got before.

Best regards,
Mabel Mao

[EdHans]

I'm not getting an error message. It runs. I just get garbage in the OneNote file rather than the binary attachment.

[tpalmer · Accepted solution]

Hi @EdHans - currently the "create a page" action expects text or HTML to be provided and does not handle converting more complex file types. The OneNote API does allow a file attachments or printouts to be added (similar to when you add a PDF to a page in the OneNote client), unfortunately we don't support this in the OneNote connector today. Please add this to our ideas forum to help us prioritize the improvement!

[EdHans]

Thanks @tpalmer. At least I can give up trying for now. I am a bit surprised given I can use attachments for other connectors - like Outlook 365 to OneDrive for Business.

I've added the request to the list.

[GMR1]

@EdHans 

Hi. I'm curious if you ever figured out a way to get your attachment to render in OneNote? I'm working on this now. Thank you.

GMR1

[EdHans]

No, and the funny thing is I was thinking about it this morning wondering if Flow integration with OneNote and attachments had been improved, so it was on my list of stuff to look at this week.  Great timing!

[Loosr]

I figured it out. 

Set up an email account with the email to onenote account and use a outlook email flow sent to me@onenote.com.

This will create a new page in a section with the attachment added to the page. Check out the '@section' in the subject to route into specific sections.

Love OneNote - Come on MS, help us by developing the best product offering you have.  Dont make us figure these things out for you.

[GMR1]

Thanks - that totally worked. You Rock! @Loosr 

[mizzmeeshelly]

@Loosr  Thank you so much for figuring this out.

This works only if I wanted the attachment email to save to "My Notebook"

Any way to have it saved to a group notebook that I created?

Right now, even if I had set the flow to save to the group notebook, it still defaults to "My Notebook". I'm assuming because of the me@onenote address.

Any advise is much appreciate it!

Thank you.

[Loosr]

@mizzmeeshelly

The destination notebook is configured on the Email to OneNote site.