Export sections as PDF from Notebook on the 1st every month

(2) Share

Report

Posted on by Vieri

Hi,

since a few weeks our department uses OneNote as a shift handover tool. We have a Night, Morning and Afternoon shift.

The group section is the current year, the group section is divided into sections (called months). Each section consist of pages. These pages are used as shift handover.

How the pages are built up:

2023 >> April

1-4-2023 Night Shift

1-4-2023 Morning Shift

1-4-2023 Afternoon Shift

2-4-2023 Night Shift

2-4-2023 Morning Shift

2-4-2023 Afternoon Shift

I would like to create a PDF back-up on the 1st of May at 01:00AM of all the pages (all the shift reports) in the previous section (April).

On 1st of June at 01:00AM a PDF backup of all the pages (all the shift reports) for May etc etc.

Programming such a flow requires a lot of know how and unfortunately i only have minor basic knowledge of Flows.

Thank you very much for helping out!

Categories:

Building flows

I have the same question (0)

All responses (10)

Answers (0)

v-jefferni on at

Like (1)

Report
Hi @Vieri ,

I have created some OneNote Sections/Pages for test:

Flow overview:

Flow details:

JSON Schema:

{ "type": "array", "items": { "type": "object", "properties": { "SectionGroup": { "type": "string" }, "SectionKey": { "type": "string" }, "SectionName": { "type": "string" } }, "required": [ "SectionGroup", "SectionKey", "SectionName" ] } }

Best regards,

Was this reply helpful? Yes No
Vieri 34 on at

Like (0)

Report

Wow, thank you very much for this flow. Currently i am creating the flow but i run into some challenges. Your images are very helpful but i would like to ask if it is possible to have some items a bit clarified.

1.For the [Select] i do not have a 'parentsection' available. I have choosen Section Identifier from the available options.

2. For [Apply to each 2] i do not know which dynamic content is specified in your example

Thank you

Was this reply helpful? Yes No
v-jefferni on at

Like (1)

Report
Hi @Vieri ,

I wrote the expression in Select:

item()?['parentSectionGroup/name']

The dynamic content in Apply to each 2 is:

Or you can easily write expression:

items('Apply_to_each_2')?['id']

Best regards,

Was this reply helpful? Yes No
Vieri 34 on at

Like (0)

Report

Hi, thank you for your swift response. This helped a lot since it succeeded a test so far without creating a file. Now i am stuck at the 'create file' section.

I can choose 'SectionName' from [Filter Array 2], [Parse JSON] or [Filter Array] but with last 2 options a 3rd Apply to each is created which i do not see in your example.

[Filter Array 2] does not create a 3rd apply to each, but for File Content i do not see 'pageContents' from [Append to Array Variable) available.

Clearly i am doing something wrong. Besides, i would like to create the file on Sharepoint so is an alternative available with Create Sharepoint File?

Was this reply helpful? Yes No
v-jefferni on at

Like (1)

Report

Hi @Vieri ,

They are both in Filter array 2, so just select dynamic contents from Filter array 2:

pageContents is name of the variable, so it's inserting the entire array variable as file content. You can use SharePoint create file action to replace the Create file 2 action in my flow.

Best regards,

Was this reply helpful? Yes No
Vieri 34 on at

Like (0)

Report

Hi,

flow has been finished but unfortunately no file is appearing. Please find below my steps with details about the dynamic content. I surely made a mistake as i am having difficulties to understand the various actions 😥 I have left out the notebook key due to privacy reasons

Was this reply helpful? Yes No
v-jefferni on at

Like (1)

Report

Hi @Vieri ,

I find a mistake:

The logic is simple, except for getting page contents into the array variable.

Next is use the entire array as file content to create the HTML file, since page contents are with HTML codes.

Best regards,

Was this reply helpful? Yes No
Vieri 34 on at

Like (0)

Report

Hi @v-jefferni

Thank you very much for your effort to help me out. I just spend 1,5 night shifts trying to find out where the mistake could be in my Flow.

Is it possible to share my flow with you? You have put so much effort in creating this flow that it would be a pity if i can't manage to get it working.

Thank you!

Was this reply helpful? Yes No
v-jefferni on at

Like (0)

Report

Hi @Vieri ,

If you have any issue you can leave in this thread and I will help you out. Sorry but I cannot save Non-certified programs in my hardware.

Best regards,

Was this reply helpful? Yes No
PBNZ_PPcommunity 3 on at

Like (0)

Report

Hi,

Did you ever manage to finish this Flow to successfully export/save OneNote content to PDF? If so, I was wondering if you'd mind to please share it here? Would love to replicate your approach.

Thanks very much in advance!

Cheers,

Peter

Was this reply helpful? Yes No