Share via

How to automatically create a Planner Task from OneNote

Anonymous
2022-12-16T20:15:39+00:00

I would like to create a Power Automate flow that automatically creates a Planner task(s) each time a OneNote page is created. I would like the Planner task name to mirror the task verbiage used in the new OneNote page. If what I am trying to accomplish is possible, how do I create the flow in Power Automate?

In searching for assistance, I found a similar question submitted on 8/11/22 by Annrin. I am l looking for clarity to the information provided in the response and some additional information.

Create Planner task from OneNote for Windows 10 - Microsoft Community

Must each new page created in the OneNote notebook have to include"

Remove \n from HTML to Text:

Compose2: replace(outputs('Compose'),decodeUriComponent('%0A'),';')

Get Task1 text:

Compose3: substring(outputs('Compose_2'),0,5)

Get Task2 text:

Compose4: substring(outputs('Compose_2'),0,5)

When I attempted to duplicate the flow as shown in the example none of the functions shown for compose 2 thru compose 4 "replace(..), substring(...) are available for me to load into my flow. I did make sure that used the show more in all function areas to be sure they were not just hidden.

Thank you in advance for any assistance you can provide.

Microsoft 365 and Office | OneNote | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

10 answers

Sort by: Most helpful
  1. Anonymous
    2023-01-14T06:09:29+00:00

    Dear Denise,

    Thanks for your updates.

    It seems that the OneNote API call can't find the section or page you specified. Please check whether you rename the section or the page. If yes, you may wait some time for the flow to update and then re-add the connector to the flow and then do a test to see the result.

    Thanks for your effort and time!

    Sincerely,

    Cliff | Microsoft Community Moderator

    3 people found this answer helpful.
    0 comments No comments
  2. Anonymous
    2023-01-10T05:20:32+00:00

    Dear Denise,

    Thanks for your updates and screenshots.

    Based on your scenario, the way I provided above may not be applied to it. You may use the flow as follows to see the result.

    Compose: split(replace(outputs('Html_to_text')?['body'],decodeUriComponent('%0A'),';'),';')

    Filter Array:

    empty(item()) is not equal to true

    Compose2: item()

    Result:

    Thanks for your effort and time!

    Sincerely,

    Cliff | Microsoft Community Moderator

    2 people found this answer helpful.
    0 comments No comments
  3. Anonymous
    2022-12-21T21:27:48+00:00

    Hello Cliff,

    The text I would like to extract from each new section page created for each new meeting (once the meeting is held and the page is completed) are tasks as a result of the meeting. The task text needed to be extracted will be different each time. Is it possible to extract the task verbiage if I start each task with "Task 1", "Task 2", etc. and if so, what would the needed flow steps be?

    See screenshot below of the flow I have started.

    Thank you for your assistance!

    2 people found this answer helpful.
    0 comments No comments
  4. Anonymous
    2022-12-22T08:28:51+00:00

    Dear Denise,

    Thanks for your updates.

    From your description, it seems that you send the meeting notes from Outlook to OneNote. If yes, when you use the When a new page is created in a section trigger, the flow should be triggered.

    Here is a demo for your reference. For example, you want to extract meeting1 and please complete task for the task title. Yoy can create the flow in your environment as follows.

    Compose2: split(outputs('Compose'),',')

    Compose3: first(outputs('Compose_2'))

    Compose4: substring(outputs('Compose_3'),8,sub(lastIndexOf(outputs('Compose_3'),'Link'),8))

    Compose5: last(outputs('Compose_2'))

    Compose6: replace(outputs('Compose_5'),decodeUriComponent('%0A'),' ')

    Compose7: lastindexof(outputs('Compose_6'),'Notes')

    Compose8: add(int(indexOf(outputs('Compose_6'),' ')),3)

    Compose9: substring(outputs('Compose_6'),outputs('Compose_8'),sub(outputs('Compose_7'),outputs('Compose_8')))

    Result:

    Thanks for your effort and time!

    Sincerely,

    Cliff | Microsoft Community Moderator

    0 comments No comments
  5. Anonymous
    2022-12-17T07:56:53+00:00

    Dear Denise,

    Welcome to the forum here.

    For Power Automate, you may use some expressions like substring, replace and so on to extract the text from the converted text from the notebook pages. You may use different formula to make the flow extract the text based on the scenarios in your environment.

    If it is convenient, could you upload some screens showing the text you want to extract in the notebooks for our confirmation?

    Meanwhile, about "When I attempted to duplicate the flow as shown in the example none of the functions shown for compose 2 thru compose 4 "replace(..), substring(...) are available for me to load into my flow. I did make sure that used the show more in all function areas to be sure they were not just hidden.", could you upload some related screenshots for us to clarify the scenario in your environment as well?

    Note: Remove any private information before uploading the screenshots.

    Thanks for your effort and time!

    Sincerely,

    Cliff | Microsoft Community Moderator

    0 comments No comments