Unanswered

How to find OneNote Notebook key

(0) Share

Report

Posted on by Community Power Pla...

I'm new to PowerApps and I'm trying to create a simple app that allows me to query information from my OneNote notebook. User enters a string, I look for pages that match that contain that string and list those pages to the user.

Is this possible?

I've read the documentation of the OneNote connector for PowerApps and can't make heads or tails of it.

If I wanted to use a function such as GetPageContent, where would I find the values for its parameters? Where do I find the values for notebookKey, sectionID, and pageID.

Any help here would be much appreciated.

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

v-monli-msft on at

Like (3)

Report
Hi @Anonymous,

To get the notebookKey, insert a dropdown control and set its Items property to:

'OneNote(Business)'.GetNotebooks()

Then getting the sectionId, by inserting the 2nd dropdown control, and set its Items property to:

'OneNote(Business)'.GetSectionsInNotebook(Dropdown1.Selected.Key).value

Add the 3nd dropdown control to get the pageId, set its Items property to:

'OneNote(Business)'.GetPagesInSection(Dropdown1.Selected.Key,Dropdown2.Selected.pagesUrl).value

Notice for Dropdown2 and Dropdown3, you could change the Value property to more user-friendly value by selecting on the right side panel:

Regards,

Mona

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Thank you very much @v-monli-msft. This helps alot. Kind of a dumb follow up question, but how can I copy the values from the dropdown boxes so that I can use them elsewhere in the application?

Was this reply helpful? Yes No
v-monli-msft on at

Like (0)

Report
Hi @Anonymous,

That depends. But mostly for dropdown controls, the formula should be something like:

Dropdown1.Selected.xxx

Regards,

Mona

Was this reply helpful? Yes No
Kurry 69 on at

Like (0)

Report
Thanks for this guide, but to be able to retrieve the page content, I use the folowing code:

Dropdown2.items:
'OneNote(Business)'.GetNotebooks()

Dropdown3.items:
'OneNote(Business)'.GetSectionsInNotebook(Dropdown2.Selected.Key).value

dropdown4.items:
'OneNote(Business)'.GetPagesInSection(Dropdown2.Selected.Key,Dropdown3.Selected.pagesUrl).value

On a RichTextEditor2.default I set this:
'OneNote(Business)'.GetPageContent(Dropdown2.Selected.Key,Dropdown3.Selected.id,Dropdown3.Selected.id)

The error I get is:

{ "duration": 48.9, "size": 307, "status": 400, "headers": { "Content-Length": 307, "Content-Type": "application/json", "x-ms-client-request-id": "ae21e304-aec3-49b6-b363-1055a51043bb" }, "body": { "error": { "code": 400, "message": "The section id is invalid. If a custom value was entered, please try selecting from the supplied values.", "source": "europe-002.azure-apim.net", "path": "choose[3]\\when[1]", "clientRequestId": "ae21e304-aec3-49b6-b363-1055a51043bb" } } }

I can use the section id for the retrieval of the page id's, so I guess the key should be ok?
What am I doing wrong?

Any help would be appreciated.

Was this reply helpful? Yes No
Ammanas7077 19 on at

Like (0)

Report

Anyone has any solution to displaying page content in a html window?

Was this reply helpful? Yes No