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.
Did you ever find a solution for this?
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!
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:
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
WarrenBelz
146,658
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,999
Most Valuable Professional