Trying to parse text from a OneNote (if impossible then word document) to an excel spreadsheet.

[CashiFr]

The OneNote (if impossible use word) contains bullet points that represent a project. Each bullet point has a project name, user, then project notes. Essentially like this:

• Project1 - John - Project1 was completed in August.

This should translate over to excel as

ProjectName	User	ProjectNotes
Project1	John	Project 1

How do I make a flow that achieves this? I tried setting up a compose tree but it didn't work. I'm thinking of using AI to parse but I'm extremely unfamilar with it.

Also all of these files are connected with a sharepoint link as I'm using a company computer to set this flow up. But if I need to use the native OneNote or (word document) then that should be permissable.

[SudeepGhatakNZ]

@CashiFr 

Loop through each bullet point in the array.

Use the split function to divide each bullet point into parts using split(item(), ' - ')
Parse Project Name: first(outputs('Compose'))
Parse User: outputs('Compose')[1]
Parse Project Notes: outputs('Compose')[2]

[CashiFr]

Thank you so much for the answer, is it possible you can show me through the form of the flow? Using the flow icons as a visual means? Thank you.

[SudeepGhatakNZ]

OK, I'll post a solution.

[SudeepGhatakNZ]

@CashiFr 

[CashiFr]

Thank you so much for giving me such a well-written example. I have two more questions, my first question is that is the code for the compose actually supposed to include the "[1]" in the code itself or is that merely a comment meant to represent that its a copy? Another question is how do I connect this to an excel spreadsheet so that the information is outputted to there and I get my end result which is the graph. Thank you so much.

[SudeepGhatakNZ]

The split function in programming is used to divide a string into an array of substrings based on a specified delimiter.

When you use split with a string, it will break the string into an array of objects (substrings). Here’s how it works:

Project Name (First Object): The first object in the resulting array is the Project Name. You can access it using array[0] or first(array)

Second Object: The second object 'User' in the array can be accessed by using array[1].

Third Object and Beyond: The third object and any subsequent objects can be accessed by using array[2], array[3], and so on.

[CashiFr]

Thank you for explaining the split functionality to me. Can you guide me on how to take that composed text into an excel spreadsheet (the spreadsheet is already created)  where the format is

ProjectName	User	ProjectNotes
Project1	John	Project

Thank you so much for helping me and I strongly appreciate it!

Also when you connect these two together, will updates to the OneNote automatically translate over to the Excel spreadsheet such as the flow reading the OneNote then composing the text to the excel spreadsheet? Or is this like a button press feature?