Microsoft 365 credential not showing all excel files in my onedrive

Questions
1

Describe the problem/error/question

I added a Microsoft 365 Node
Created a credential to my o365 subscription account.
Had already created a new Excel workbook in my onedrive.
In my Office.com account I see the file.
I chose From List, but the search box only sees 2 of my Excel workbooks, I have many more in that account.
I am signed into the same office account that I signed in to create the credential.
I also tried from ID, and the node recognizes the workbook ID but then it says can’t load list in n the sheet drop down. I tried changing to by ID but can’t find where to get the sheet ID.
I would really prefer to solve why the credential doesn’t see all of my onedrive workbooks because I will want to use this node type in other workflows.
Oh I also went to the file in my office.com account, clicked on share, selected with link edit/delete and used that as well, but that didn’t change the node’s ability to see more than just 2 of my workbooks.

Only things I can think of is maybe I need to put the workbook file into a specific share mode other than just using the share link?
Or if I need to have the workbook in a specific folder?
I definitely need to not have it in the Public folder but I don’t know why n8n would need that given I have created the auth credential.

Right now this is just a very very basic workflow, my first one, I’m just using this to test receiving messages from my Discord server and then intended to use the Excel node to store the messages.

The AI assistant has no help on this either.

I tried just now to copy/paste the workflow but error there says
Your organization’s data cannot be pasted here. Only 300 characters are allowed, so can’t paste it in the way the instructions below say.

(Select the nodes on your canvas and use the keyboard shortcuts CMD+C/CTRL+C and CMD+V/CTRL+V to copy and paste the workflow.)

First time in and not having much success.

Information on your n8n setup

  • **n8n version: 1.67.1 latest stable

  • Database (default: SQLite):

  • n8n EXECUTIONS_PROCESS setting (default: own, main):

  • Running n8n via (Docker, npm, n8n cloud, desktop app):

  • Operating system:

  • Windows 11

2

Hi @vitaminbp1,

Is there anything different about the Excel workbooks that are not returned in n8n? Are they for example shared with you, or part of a Sharepoint site instead of your OneDrive?

I found this related support thread on Microsoft’s forum.

The n8n Excel 365 node uses the https://graph.microsoft.com/v1.0/me/drive/root/search(q='.xlsx') endpoint but maybe you could have more luck with these endpoints:

You can try these endpoints in the HTTP Request node with your existing Microsoft 365 credential.

Hope this helps!

3 Likes
3

Thank you very much for that information, I will try that!

4

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.