Hey everyone,
I keep having this issue with Excel file on Sharepoint - When I edit the zap, the connection works fine and the test pass with not issue, but when it is running, I keep getting the error and nothing is being updated in my spreadsheet.
I looked through the articles, but nothing helps.
Best answer by christina.d
Hiya! I wanted to pop in the recommendations from the support ticket in case it’s helpful to anyone following along!
I'm curious if reselecting the folders would do the trick here:
If a file is moved at all between folders, there can be a disconnect. I do recommend starting here for troubleshooting.
I would also recommend Sharing the connection with your team to ensure there aren't any permissions barriers here:
https://zapier.com/app/connections/excel
Hopefully this helps! 🤗
+14Hi
Good question.
Please post detailed screenshots with how your Zap steps are configured in order for us to have more context.
You can also try opening a ticket with Zapier Support: https://zapier.com/app/get-help
Here are some screenshots of my Zap.
So the trigger works - shopify - paid order
I just filter and format - no error here
Excel - says it is connected and I have the file in the default sharepoint site, so it has access and per the screenshots, it shows the folder, the file and it has access. Then testing the zap - works fine.
Then - I just sent an email as notification.
The zap history says it runs all the steps, except for the Excel, that keeps saying the recourse is not found…
+14This may be why…
We only support OneDrive for business right now - as the Excel API comes out of beta status we expect to support any version of Excel online.
Personal Outlook accounts do not work unfortunately!
It could be that. I was also going by this. Assuming it will work, and that’s why I’m using the default Sharepoint site.
+14Might be best to open a ticket with Zapier Support for additional help: https://zapier.com/app/get-help
+9Hiya! I wanted to pop in the recommendations from the support ticket in case it’s helpful to anyone following along!
I'm curious if reselecting the folders would do the trick here:
If a file is moved at all between folders, there can be a disconnect. I do recommend starting here for troubleshooting.
I would also recommend Sharing the connection with your team to ensure there aren't any permissions barriers here:
https://zapier.com/app/connections/excel
Hopefully this helps! 🤗
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
