About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Best answer

Can't find Excel sheet on SharePoint or OneDrive.

A
  • Anonymous
  • 0 replies

Is there an answer?  I’m having same issue.  Should I be linking to the admin email? 

 I have both a personal OneDrive and a business OneDrive on my computer.  Nothing in the business file appears.

If I can’t send Jotform submissions to Excel, are there any other products that work?

 

icon

Best answer by Danvers 11 May 2022, 12:56

View original
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

5 replies

nicksimard
Userlevel 7
Badge +11

Hi @Dawn M!

Have you tried clicking on “/root? in the Zap, do other folder appear? Is that the issue you’re having, or is it something different?

As for other apps you could use, Google Sheets and Airtable would be great options :)

A

Thanks for the tip -  I entered “/root? as you suggested and I did see a folder that I set up.  However, no worksheets or files appear.  I’m trying to integrate with a sheet in a workbook.  I’ve saved it as an .xlsx incase it was looking for a later version file.  Are there any good instructions anywhere?

Here’s what I get:

 

Folderrequired

Test Folder

Spreadsheetrequired

Choose value…

Worksheetrequired

Choose value…

We’re having trouble loading 'Worksheet' data (Required field "Spreadsheet" (workbook_id) is missing.)

Refresh

Danvers
Userlevel 7
Badge +12

Hi @Dawn M!

From what you’ve described above, it sounds like you need to select a value for the spreadsheet. In the Zap you have to choose the Speadsheet first so that it knows where to look for the worksheet:

I hope that’s clear, if you’re still having trouble with your Zap step, could you please share a screenshot like the one here? That’ll really help us to understand what’s going on 😊

A

Thanks Danvers,

 

I actually have made progress but hit a wall again today:

 

jesse
Userlevel 7
Badge +9

@Dawn M happy to help here! I wasn’t able to find anything about this error in our internal documentation but after some digging, I found a Microsoft document for this error that said:

The failed request conflicts with other clients accessing the workbook (for example, another client has locked the workbook for edit). The Microsoft Graph client is not expected to resend the failed request until the conflict is resolved. An end user can choose to manually perform the same operations with Excel Online to get more details about the conflict.

I am not super familiar with the nuances of workbook access by other clients so this might be something you either want to raise with our support team or the Microsoft team that supports Excel. Best of luck! 

Terms & Conditions