NinjaForms to SharePoint Excel - Failing to find resource on first attempt

Question

Hello,

I have a support ticket open with Zapier, however they appear to be stumped on this one, as is our IT department.

I have created 3 spreadsheets (excel) within a Sharepoint site, in a folder. I then have a zap picking up form submissions (3 different ones), and adding a new row into the spreadsheets. Basic stuff really.

It works perfectly well apart from on occassion, the zap fails to do it first time around and returns an error of ‘can’t find that resource’.

If I hit the replay button it works fine.

Has anyone else run into this one? There doesn’t appear to be any fixes I can see, and I am not sure if it is a permissions issue in Sharepoint on these files, or whether I am asking too much of Zapier, which would be really disappointing.

Thanks in advance.

icon

Best answer by PaulKortman 25 July 2020, 01:33

View original

PaulKortman · Accepted Answer

I’ve run into something very similar and it can be very frustrating.

You have a couple of options.

Option 1: Turn on auto replay

See here for the documentation on how to enable auto replay

Option 2: Add in extra steps to replay the specific step that fails.

I wrote about how to do this in another post. The example in this other post does use Google Sheets as the failing app, but you could apply this logic to any step that fails on occasion.

Let us know which option you go with and how it works for you.

Option 1: Turn on auto replay

Option 2: Add in extra steps to replay the specific step that fails.

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded