My text has been translated into English using AI, so please forgive me if a menu item is not named exactly the same way as it appears in your interface.
My goal:
- In Copilot Studio, I would like to teach my agent to read information from OneNote.
- To do this, I need four connectors under "Tools" → "Add Tools", all of them prebuilt OneNote connectors.
- The connectors are called:
- Get recent notebooks
- Get sections in notebook
- Get pages for a specific section
- Get page content
In theory, this creates a coherent workflow.
In practice, however, the connectors seem to make things unnecessarily difficult.
One of the challenges is the issue discussed here.
The "Get recent notebooks" connector retrieves notebook keys.
Some of these notebook keys follow a standardized naming format that contains spaces and other special characters.
For example:
Temmie @ Work|$| @ Work
This key allows me to access the notebook and appears to be passed to the second connector.
However, when the key is passed to the second connector ("Get sections in notebook"), it seems to be URL-encoded and ends up looking something like this:
Temmie%20%40%20Work%7C%24%7Chttps%3A%2F%2Fsage365-my.sharepoint.com%2F.... etc.
The same connector ("Get sections in notebook") appears to expect the key in its raw format:
Temmie @ Work|$| @ Work
Because the URL-encoded version is being passed, the connector returns an HTTP 400 error.
What I need is for the automatically retrieved key to be passed to the next connector and accepted in its original, unmodified format.
One additional observation:
If I use a notebook that follows a different naming convention without spaces or special characters, for example:
TR_Backup
the issue does not occur. It appears that no encoding is applied in this case.
Renaming notebooks would therefore be a viable workaround, but it is not a real solution, since the overall functionality is intended to work dynamically with any notebook based on the logged-in user.
The goal must therefore be to ensure that notebook keys are transferred between the two OneNote connectors without any conversion or URL encoding.
Does that help at all?
Does anyone know how to solve this?
