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
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:
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.
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?
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.
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!
Flow Community Manager
You did just what I am trying to do. Can you help me out? I cannot follow form your screenshots.
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?
Hi @Anonymous , I hope the images below will guide you better.
My flow sends an email to a wider group based on a daily file under a "month" section.
Let me know if it works for you.
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!
We've given our badges an overhaul and also added some brand new ones!
Learn how to build the business apps that you need.
Find out where you can attend!
Watch & learn from the Power Automate Community Video Gallery!