Hello All,
We are looking for specific requirements of the OneNote page reordering using Power Automate and PowerApps, which are mentioned below.
Power Apps re-ordering function: OneNote Page re-order using PowerApps and Power Automate
- Background:
Our client uses a Power Apps solution integrated with OneNote to manage executive board meetings. Changes to agenda items are dynamic in the lead up to board meetings and this places a significant administrative burden on the board support team to manual apply and re-order agenda changes and make sure they are correctly synchronised across both Master OneNote and multiple executive board members User OneNotes.
- Requirement overview:
A Power Automate action or other appropriate utility is required to provide the ability to perform re-ordering of agenda items in Power Apps when the order of an agenda changes or a new agenda item is inserted which necessitates re-ordering. As a corollary the function must then support processing mass changes so that when the re-ordering function has been performed in the Power App, the change is automatically reflected in the Master One Note and rippled through to individual User OneNotes.
- Worked Example and illustrations:
A simple example is provided below with supporting mocked up screenshots to illustrate the before and after desired after effect. See figures 1, 2 and 3 appended below.
Power App – Existing agenda items:
0.0 |
Overall agenda |
1.0 |
Welcome and introductions |
2.0 |
Gas & Low carbon energy update |
3.0 |
Production & Operations update |
4.0 |
Customer and Products update |
A new agenda item is inserted and by standard default this item is appended directly after the last agenda item.
Power Apps – Agenda items after insertion
0.00 |
Overall agenda |
1.0 |
Welcome and introductions |
2.0 |
Gas & Low carbon energy update |
3.0 |
Production & Operations update |
4.0 |
Customer and Products update |
5.0 |
Technology - Cyber security incident update |
A decision is made table the new item immediately after the initial item. The entire agenda now needs to be re-ordered.
Power Apps – Agenda items after reordering function is called:
0.0 |
Overall agenda |
1.0 |
Welcome and introductions |
2.0 |
Technology - Cyber security incident update |
3.0 |
Gas & Low carbon energy update |
4.0 |
Production & Operations update |
5.0 |
Customer and Products update |
A mass change now needs to be processed so that agenda reordering is automatically synchronised to the Master OneNote and all Board Members individual User OneNotes.
Figure 1: Power App and OneNotes before re-ordering action
Figure 2: Power App following re-ordering action
Figure 3: OneNotes following re-ordering action
- Sub items:
Agenda items can also include sub items that need to be included in the scope of the re-ordering requirement. Status before re-ordering:
0.00 |
Overall Agenda |
1.0 |
Welcome and introductions |
2.0 |
Technology - Cyber security incident update |
3.0 |
Gas & Low carbon energy update |
4.0 |
Production & Operations update |
5.0 |
Customer and Products update |
6.0 |
Project ABC review |
6.1 |
Benefits Case |
6.2 |
Schedule Plan |
6.3 |
Governance |
6.4 |
Change Management |
After reordering:
0.0 |
Overall agenda |
1.0 |
Welcome and introductions |
2.0 |
Technology - Cyber security incident update |
3.0 |
Project ABC review |
3.1 |
Benefits Case |
3.2 |
Schedule Plan |
3.3 |
Governance |
3.4 |
Change Management |
4.0 |
Gas & Low carbon energy update |
5.0 |
Production & Operations update |
6.0 |
Customer and Products update |
Please refer to the attached document for the same.
Looking forward to hearing more on this from your side.
Thank you!!