
Announcements
I want to parse text from a OneNote document into an Excel table. The OneNote document would have a bullet point representing each project. On each bullet point there will be three columns worth of text. Any edits made on the OneNote should automatically reflect on the Excel Sheet dynamically so that modifications don’t have to made to the excel sheet.
(Project Name, Developers, Project Notes)
Example:
Unity - Adam - Project was finished on 6/28.
This should parse to
Project Name
Developers
Project Notes
Unity | Adam | Project was finished on 6/28 |
Also, the OneNote document is stored on a sharepoint site (if I need to utilize the OneNote actions instead of sharepoint that's perfectly fine but I would prefer to use the sharepoint actions if possible). The excel sheet is on excel online. I can only use the online Power Automate Flow tool instead of the desktop app. Would strongly appreciate the help/guidance! Thank you guys.