Skip to main content

Notifications

Power Automate - Using Flows
Unanswered

OneNote Page Reordering/Automation Using Power Automate Flow

Posted on by
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
  1. 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.
  1. 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.
  1. 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
  1. 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!!

Categories:

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,246

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,884

Leaderboard

Featured topics

Restore a deleted flow