Hello everyone and thank you for your time,
I often use n8n for small, simple automations on Excel spreadsheets shared on corporate and private SharePoint. In the past, I have never had any problems authenticating either directly with n8n applications hosted in the Cloud version or in self-hosted versions.
Lately, with a specific tenant, it has been happening that after completing the authentication on a colleague’s account, who has visibility on several worksheets in their corporate SharePoint, I am unable to retrieve any results from the dropdown menu for selecting tables, sheets, or workbooks.
From the GetMany (Resource: Workbook) I simply get an empty array as result, not a single error about wrong credentials.
I followed the authentication procedure exactly as described in the official documentation for that node. I also tried modifying the Azure portal by granting additional and more permissive scopes or authenticating with accounts that have global administrative roles on the entire tenant, but it never works.
What could be happening in this case?
- Running n8n via (Docker, npm, n8n cloud, desktop app): n8n cloud
