You’re offline. This is a read only version of the page.
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!
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,
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!
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,
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
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,
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?
Hi @Vieri ,
I wrote the expression in Select:
Share
Report
All responses (
Answers (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,
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
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,
#1
Tomac
986
Moderator
#2
stampcoin
699
Super User 2025 Season 2
#3
Riyaz_riz11
577
Super User 2025 Season 2
