Excel workbook does not appear

Hi guys, I have a problem with the microsoft node. I’m using one drive and excel for my project. The credential are connecting fine and i see all the permission on my Entra ID but when i go on my microsoft node, and i try to list my workbook they does not appear like they were not even created and when i try to search a file in my One drive it’s the same thing. I tried with the ID and the name of the files too but it’s not working. Thanks for your help.

Hi @Traffiq_Growth ,

Even though your credentials are connected, the OAuth scopes might not include the right permissions for accessing files.

For OneDrive and Excel access, you need these scopes:

  • Files.Read or Files.ReadWrite

  • Files.Read.All or Files.ReadWrite.All (for shared files)

  • Sites.Read.All (if files are in SharePoint/Teams)

  • offline_access (for token refresh)

can you try verifying your scopes?

So i need to created a custom app on my Entra ID with the callback and those scopes? If yes do i need to have a client secrets or do my n8n cloud app will be in charge of that and the custom app will only be for the callback with the right scopes?

This is the permission i have for the n8n cloud that is ask when i create my credential. Am I supposed to do something else after creating that?

Hi @Traffiq_Growth

You might need to reauthenticate your account in n8n if the permissions have changed :slight_smile:

Open the credentials for excel or drive, and check if you can reauthenticate.

What do you mean by reauthenticate? Like delete the previous credential and redoing it? I already did that and it’s still not working :frowning:

I have a admin account that is controling all my account via Entra et azure. The account that my excel are on is a user account in this business, maybe the problem is that i need to do all the connection and the excel directly from my admin account but I don’t think it’s supposed to work like that.

Hi @Traffiq_Growth

So Entra works in multiple ways, it can be hard to explain.

When you’re authenticating with delegate access, as you are here the application is requesting access on your behalf. In short this means, that the action is linked to your account. For delegate access to surely work, you need admin consent, as far as i can see this is done correctly.

You can read more her: Overview of permissions and consent in the Microsoft identity platform - Microsoft identity platform | Microsoft Learn

When you authenticate your own account through n8n in Entra, you should be asked if you give permission, you should be able to see this on the “User consent” tab.

Are you self–hosting n8n?

How is your credential setup in n8n?

My n8n is not self-hosted, it’s cloud and when I do the credential in n8n i have to ask the permission to the admin account and from there they granted the access to my user with all the permission list before. So im not supposed to need more than that to list my workbook but i know there is rule about file in one drive that they need to be created a certain way?