Unanswered

Search All OneNote Pages for Incomplete Tasks and Send Email

(0) Share

Report

Posted on by jeremyterry

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.

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

JamesDix_n 203 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
jeremyterry 2 on at

Like (0)

Report
Copy link

Link copied!
Hello James,

By task I mean this checkbox Tag in OneNote
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:
start with the notebook
get a list of all sections
for each section, get a list of all pages
search all pages for incomplete to do tag

Was this reply helpful? Yes No
JamesDix_n 203 on at

Like (0)

Report
Copy link

Link copied!

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!

Was this reply helpful? Yes No
VenusB 5 on at

Like (0)

Report
Copy link

Link copied!

Did you ever find a solution for this?

Was this reply helpful? Yes No