Skip to main content

Notifications

Community site session details

Community site session details

Session Id : oVDlg5+dsD+/ftmRRFsJvR
Power Automate - Building Flows
Unanswered

Search All OneNote Pages for Incomplete Tasks and Send Email

Like (0) ShareShare
ReportReport
Posted on 14 Jul 2023 01:52:54 by 2

I'm struggling to create a flow.  I'd like a weekly scheduled flow to search all sections and pages within a single notebook for incomplete tasks, then send a summary email.

 

I looks like the OneNote connector has the required actions to get list of sections and pages but I can't figure it out.

  • VenusB Profile Picture
    5 on 12 Jun 2024 at 12:55:03
    Re: Search All OneNote Pages for Incomplete Tasks and Send Email

    Did you ever find a solution for this?

     

  • JamesDix_n Profile Picture
    203 on 18 Jul 2023 at 16:02:15
    Re: Search All OneNote Pages for Incomplete Tasks and Send Email

    Hey Jeremy, this is a tricky one and a bit beyond my knowledge I'm afraid. The OneNote action 'Get Page content' does allow you to get HTML text from the pages that shows the to do tag in html format: 

    <p data-tag="to-do:completed" style="margin-top:0pt;margin-bottom:0pt">Example task</p>.

     

    This could be handy but you would need to find a way to search your relevant pages (possibly in a loop as you suggest?) and then translate the html back into a more accessible format to include in your email. Good luck! 

  • jeremyterry Profile Picture
    2 on 14 Jul 2023 at 17:40:50
    Re: Search All OneNote Pages for Incomplete Tasks and Send Email

    Hello James,

     

    By task I mean this checkbox Tag in OneNote
    jeremyterry_0-1689355559704.png

    Where I'm getting stuck is drilling down and searching the content for each individual page.  I imagine it works as a nested for loop:

    1. start with the notebook
    2. get a list of all sections
    3. for each section, get a list of all pages
    4. search all pages for incomplete to do tag

     

  • JamesDix_n Profile Picture
    203 on 14 Jul 2023 at 15:46:20
    Re: Search All OneNote Pages for Incomplete Tasks and Send Email

    Hi Jeremy, hopefully the community can help you out with this. The weekly scheduled email side of the Flow probably isn't too hard to create but it would be helpful to understand what you are defining as a 'Task' in OneNote? Is it the functionality in OneNote to create an Outlook task? If so then you may be able to use this pre-built template to achieve your needs: Send a digest email of all outstanding Outlook tasks | Microsoft Power Automate

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,658 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,999 Most Valuable Professional

Leaderboard
Loading started