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

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / OneNote Page Items int...
Power Automate
Unanswered

OneNote Page Items into Individual Planner Tasks

(1) ShareShare
ReportReport
Posted on by 4

Hi everyone. I'm trying to automate a process of taking a portion of my notes from a meeting in my OneNote notebook and having each bullet point converted into individual tasks, then sorted based off the categories in my Planner, and then create tasks. I know it's a tall order, but any help would be amazing. Here's what the notes look like and here's what the planner categories are.

buckets.png

notes.png

Categories:
I have the same question (0)
  • WillPage Profile Picture
    2,307 Super User 2025 Season 2 on at
    Re: OneNote Page Items into Individual Planner Tasks

    You can get the content of the page in Power Automate using the Onenote connector. Bullet points are list items in HTML with <li> tags so you can use that to parse the html text and get the values out.

  • ae12345 Profile Picture
    4 on at
    Re: OneNote Page Items into Individual Planner Tasks

    Do you have a post on your blog about that? Could you include the link if you do?

  • WillPage Profile Picture
    2,307 Super User 2025 Season 2 on at
    Re: OneNote Page Items into Individual Planner Tasks

    The closest I've got is this: https://willpage.dev/2020/08/21/extract-from-address-from-forwarded-email-in-power-automate-logic-apps/

    The principle is the same, except in this example we're extracting details from an HTML email body, but you can use the same technique for the HTML text from OneNote. Something to note though: I wrote that article before the slice() function was a thing, and slice() is far easier to get a slice of text using the start index and end index than using substring() with all those nested calculations.

    But in your scenario you might be better of with another technique:

    Split the text with split(<text>, '<li>') where <text> is the dynamic output from your Get page content action from OneNote. That'll leave you with an array of string items.
    1. Bullet points in HTML:

    WillPage_0-1720056368808.png

    2. Split on <li>

    WillPage_4-1720056442819.png

     

    WillPage_1-1720056398937.png

    Now add a Filter array action and filter the previous action for item() contains </li> and the result will be the list items.

    WillPage_5-1720056467280.png

     

    WillPage_2-1720056419871.png


    Now do a Select action and switch to JSON mode, which is the little T icon on the right and put the expression 

    substring(item(),0, indexOf(item(),'</li>'))

    in there, which should strip out the closing li tag and anything after it.

    WillPage_6-1720056494910.png

     

    WillPage_3-1720056430717.png

    The output of that is an array you can use in an Apply to each to create your planner tasks.

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 462 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 456 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard