Skip to main content
Best answer

Can't find Excel sheet on SharePoint or OneDrive.


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?

 

Best answer by DanversBest answer by Danvers

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 😊

View original
Did this topic help you find an answer to your question?
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
Forum|alt.badge.img+11
  • Zapier Staff
  • 2115 replies
  • May 11, 2022

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 :)


  • 0 replies
  • May 11, 2022

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
Forum|alt.badge.img+12
  • Zapier Staff
  • 3731 replies
  • Answer
  • May 11, 2022

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 😊


  • 0 replies
  • May 17, 2022

Thanks Danvers,

 

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

 


jesse
Forum|alt.badge.img+9
  • Architect
  • 1348 replies
  • May 17, 2022

@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!