Microsoft SharePoint can't upload aexcel file when it is open onSharepoint

Questions
,
1

Hey guys,

I created a flow using Microsoft Sharepoint node to read a excel file, process some data and updated the file again.
However I see when excel file is open in navigator, Microsoft Sharepoint node gets this error:

“Your request is invalid or could not be processed by the service”

When that file os not open in navigator, the file is updated correctly.

Is there any way to update the file in Sharepoint no matter if the file is open by other person?

Thanks

What is the error message (if any)?

Please share your workflow

(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.)

Share the output returned by the last node

Information on your n8n setup

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:
2

HI Guys, I finally found the issue in Sharepoint, by default any file is related to a repository, if the file is open Shatepoint locked it, that’s cause that n8n can not be updated the file and throw an error
the Solucion is unbind the file in sharepoint from the repository

1 Like