Power Platform Community Forum Thread Details

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