
Announcements
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.