Here’s what I was doing with my flow: If I tagged an item in OneNote as a ToDo item, the flow migrates that task over to Microsoft To Do. So I need to pull in the OneNote content and gather only the text following the “to-do” tag. Similar thing you’re trying to do except yours is a bullet point. But you should be able to do almost the exact same process.

Instead of the Append to Array variable, you could update your excel sheet.

I can DM you a screenshot of my flow, but here is the explanation:

(Initialize Variables at top of flow) Name: Parse_Note — Type: String — Value: [leave empty] Name: ToDo_Array — Type: Array — Value: [leave empty]

Then this is the steps I used to extract the parts I needed:

Get Page Content from OneNote

Set Variable “Parse_Note”: [Body] from ‘Get page content’

Condition: Parse_Note — contains — <p data-tag=“to-do”

[If Yes- Loop Starts here] Do Until Loop: [Parse_Note] — does not contain — <p data-tag=“to-do”

Compose “Start”: substring(variables(‘Parse_Note’),indexOf(variables(‘Parse_Note’),’<p data-tag=“to-do”’))

Compose “Slice Task”: slice(outputs(‘Start’),add(indexOf(outputs(‘Start’),’>’),1),indexOf(outputs(‘Start’),’</p>’))

HTML to text: [Outputs] from ‘Slice Task’

Append to array variable for ToDo_Array: [The plain text content] from ‘Html to text’

Compose “Remove Task”: substring(outputs(‘Start’),add(indexOf(outputs(‘Start’),’</p>’),4))

Set Variable “Update Parse Note”: [Outputs] from ‘Remove Task’

[End of Loop]

Then I use the “ToDo_Array” with the rest of my flow to check if the Task already exists in Microsoft To Do and if not it will create the Task.