web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Fetch sections and pag...
Power Automate
Unanswered

Fetch sections and pages of sharepoint onenote notebook and update an excel

(0) ShareShare
ReportReport
Posted on by

Newbie here. I have a sharepoint site and It has few specific notebooks i am interested in .Each with multiple sections and pages. I want to write a power automate script to access each note book ,fetch each section and for each section fetch ,under the section each page title and page URL .

I have another excel created in sharepoint. The script should update the excel with table with data fetched : Notebook Name ,Section Name, Page title ,Page URL. If the excel already has any data ,it should delete excel and upload the new excel to sharepoint.

The script should get triggered when any notebook gets modified in sharepoint and update the excel . The script should also send out email attaching the excel each time script is triggered. Need to use OneNote "Get Sections in Notebook" actions and fetch sections and then use the section names fetched to trigger "get pages of specific section" and fetch all pages . Store this data in arrays and then write it into excel and upload the excel to sharepoint and send email.

 

I am having issues running through section and pages logic .How to fetch each and store for multiple notebooks.

 

Categories:
I have the same question (0)
  • SA-16041342-0 Profile Picture
    2 on at
    did you figure this out? I'm in the beginning phases of doing something similar

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 501 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 323 Moderator

#3
abm abm Profile Picture

abm abm 237 Most Valuable Professional

Last 30 days Overall leaderboard