Answered

Create a OneNote page for upcoming event Using a template

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have a template in One Note that I use to take notes for meetings. (see below) I would like to create a flow that creates a new page using this template every time I have an outlook scheduled event. I know how to create a flow that creates a OneNote page for my upcoming event, but I would really like that page to be my template and not a blank page.

Any ideas, suggestions, or recommendations?

Thank you

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (1)

Expiscornovus 33,828 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous,

I am not sure if you can access the My Templates from your OneNote? But as a workaround you could use the content of another page and create your new page with that content.

Below is an example

In this example I reused the page content and also replace the title with the value from a string variable called PageTitle.

replace(outputs('Get_page_content')?['body'], split(split(outputs('Get_page_content')?['body'], '<title>')[1], '</title>')[0], variables('PageTitle'))

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hey Thank you for you help. I think I'm missing something Could you take a look at my flow? The page gets created but I end up with the formula on that page see the picture below. any idea what I'm doing wrong? Thank you for your help

Was this reply helpful? Yes No
dunkindude 9 on at

Like (0)

Report
Copy link

Link copied!

Were you able to resolve this? Fellow Key2Success user here trying to solve the exact same problem.

Thanks!

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

yes I have see my setup below The formula Format date is:
formatDateTime(parseDateTime(split(triggerBody()?['Start'], '+')[0]), 'MM/dd', 'en-US')
and it's so I have the date of the meeting in front of the meeting' name
Then the formula that goes in the replace is :
replace(outputs('Get_page_content')?['body'], split(split(outputs('Get_page_content')?['body'], '<title>')[1], '</title>')[0], variables('PageTitle'))

This is what the finish result looks like
I have the title with the date and the subject of the meeting, then at the bottom I have the link to the actual Outlook invite, and below that I have the body of the Outlook invite.

I hope this help

Was this reply helpful? Yes No
dunkindude 9 on at

Like (0)

Report
Copy link

Link copied!

Thank you so much for the detail and your steps. - I'm getting a strange error on the last step but I will dig and work it out, I'm sure its somewhere in my transposing. Thanks again sir

InvalidTemplate. Unable to process template language expressions in action 'Create_page_in_a_section' inputs at line '0' and column '0': 'String cannot be of zero length. Parameter name: oldValue'.

Was this reply helpful? Yes No
Verified answer

Expiscornovus 33,828 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous,

Apologies for the delayed reply. The PageTitle string variable just contains a new text title. The expression should not be used there 🙂

Was this reply helpful? Yes No
ecupp 2 on at

Like (0)

Report
Copy link

Link copied!

I am getting the same error. Did you happen to get passed this error?

Thanks!

Was this reply helpful? Yes No
dunkindude 9 on at

Like (0)

Report
Copy link

Link copied!

Hi ecupp,
The exact solution escapes memory as I did multiple edits tweaking this and that. This flow works for the purpose of applying the K2S Meeting template and dropping it into a "Meeting" section with date and subject as title and OWA URL at bottom with space for notes in between. I used the "When an upcoming meeting is starting soon (v3)" and a Look-Ahead Time of 60 minutes.
fx in Expression field= replace(outputs('Get_page_content')?['body'], split(split(outputs('Get_page_content')?['body'], '<title>')[1], '</title>')[0], variables('PageTitle'))

Hope that helps-

Was this reply helpful? Yes No