cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
EdHans
Advocate V
Advocate V

Sending email with attachment to OneNote?

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?

1 ACCEPTED SOLUTION

Accepted Solutions

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!

View solution in original post

12 REPLIES 12
v-yamao-msft
Community Support
Community Support

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.

content1.PNG

 

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

content2.PNG

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

content3.PNG

 

 

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

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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.

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

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

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!

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
New Member

 

@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

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. Smiley Happy Great timing!

Loosr
Frequent Visitor

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.

Thanks - that totally worked. You Rock! @Loosr 

@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.

@mizzmeeshelly

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

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

MPA Licensing.jpg

Ask your licensing questions at the Power Automate AMA!

Join Priya Kodukula and the licensing team, super users and MVPs to find answers to your questions on Power Automate licensing.

Users online (1,999)