Re: Create a section in OneNote and then create a ...

Anonymous · ‎04-11-2018

Hello,

actually I have the same question as in this topic https://powerusers.microsoft.com/t5/I-Found-A-Bug/OneNote-create-section-then-create-page-in-that-se.... But I didn't find any answers. Can anyone help me?

I want 1. to create a section with the same name as tittle of the item in sharepoint list.

2. check, if there already exists a section with the same name

a. if yes, create a page inside this section.

b. if no, create a section with this name

Regards,

User_sen

v-xida-msft · ‎04-11-2018

Hi @Anonymous,

Thanks for your feedback, I have made a test on my side and I faced same issue with the thread that you provided. My flow's configuration as below:

Within "Create page in a section" action, Section Id field set to following formula:

item()?['id']

But even though I get the section id of the section, the flow still failed as below:

I have posted this this issue to my product team, if this issue is solved, I would reply here.

Best regards,

Kris

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous · ‎04-12-2018

Thank you Kris, please keep me updated if you get any answer.

NIKKO · ‎08-11-2018

Doing the same thing for me.. I tried to take back the created name or ID, but alwayse the message "The section id is invalid. If a custom value was entered, please try selecting from the supplied values., clientRequestId: "

Does someone has an update?

plessor88 · ‎10-30-2018

I'm a total nube to Flows so if my solution is not elegant, "Oh well".

I was banging my head up against the wall with this same problem.

The "sectionid" field does not work for the "Create page in a section" action, even if you pull it from a "Get Sections in Notebook" action. The flow just does not read it or recognize it.

I noticed in the description of the section id that it says you can use the id OR the url. I also noticed in another test that I did that when you manually select the section from the drop down menu, run the flow and look at the output, the flow uses a URL, not the big long section id number.

Bottom line: you can create the page if you use the PagesURL field as the sectionid.

I used "Get sections in notebook", filtered the results to the section I wanted, put the value into a string variable and then used that value in the "create page in a section" action and Voila!

Here is a screenshot. Ignore the extra steps, they were other attempts at troubleshooting the problem.

I left out identifying info. You can see part of the URL.

GabrielStJohn · ‎10-30-2018

Hello, @Anonymous!

Thank you for posting on the Flow Community Forum! Have you had an opportunity to apply @plessor88‘s recommendation to adapt your Flow? If yes, and you find that solution to be satisfactory, please go ahead and click “Accept as Solution” so that this thread will be marked for other users to easily identify!

Thank you for being an active member of the Flow Community!

-Gabriel
Flow Community Manager

- Gabriel
Community Manager
Power Automate | Power Virtual Agents
Super User Program Manager

Anonymous · ‎05-15-2019

You did just what I am trying to do. Can you help me out? I cannot follow form your screenshots.

I am:

Taking a value form a new email subject line

Storing that as a variable

Using that variable to make a new section in OneNote

(all of this works fine)

Creating a page in that section with the body of the email

That last step fails because I cannot use the variabel to select the very section I just made. From your post I understand that I have to resolve the variabel into the URL for the section. I see you are doing this with a 'get sections in notebook' function and doing something with an array variable. But I get lost there.

Can you help?