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

Posting a row to Sharepoint Excel Sheet always fails on first try

  • 7 February 2023
  • 8 replies
  • 227 views
C

I have Gravity Forms integrated with my Sharepoint to populate a form entry submission to a Sharepoint Excel file, but every time it tries to add a new row when it hasn’t in a day or so, the process is ‘stopped’ and it fails to populate the row. But if there are two consecutive form entries, the first will not be added to the excel sheet, but the second third etc. ones will. I believe this may be an issue with zapier not having initial access to sharepoint - could any one confirm if this might be the issue or what next steps to take?

 

Thank you

icon

Best answer by SamB 8 February 2023, 13:31

View original

8 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @Cwalk23 

Good question.

Help articles for using Excel in Zaps: https://zapier.com/apps/excel/help

About the Excel Integration

  • Admin/owner permissions: Sufficient permission is needed to view information from a spreadsheet or make changes to it.
  • Paid/versioned account: Only OneDrive for Business is supported and able to integrate with Zapier. Federated accounts, consumer accounts, Outlook accounts are not.

 

SharePoint is not yet supported as a Zap app.

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
C

I

Hi @Cwalk23 

Good question.

Help articles for using Excel in Zaps: https://zapier.com/apps/excel/help

About the Excel Integration

  • Admin/owner permissions: Sufficient permission is needed to view information from a spreadsheet or make changes to it.
  • Paid/versioned account: Only OneDrive for Business is supported and able to integrate with Zapier. Federated accounts, consumer accounts, Outlook accounts are not.

 

SharePoint is not yet supported as a Zap app.

 

I marked the excel file as shareable to anyone and it is able to post but just not on the first go at it - I was wondering if there was any way to forego the initial error since I manually have to click on rerun when the initial entry is not added to excel

SamB
Rank
Userlevel 7
Badge +11

Hey there @Cwalk23! 👋

I did some digging and it seems you’re running into a known bug with the Microsoft Excel app where new rows aren’t added to spreadsheet files hosted on Sharepoint the first time round. they’re added successfully when the failed run of the Zap is replayed but they should be able to go through successfully the first time round! 

I’ve added you to the list of affected users on the bug report for this issue. This will allow us to email you directly as soon as that issue is fixed. We’ll keep this page updated with any news or further workarounds as soon as we have them. 

It’s not possible to forego the initial error. But we do have an Autoreplay feature that would save you having to manually replay the errored runs of the Zap. That feature is only available on Professional plan or higher so depending on what plan you’re on that might not be a viable solution.

Alternatively, you could try saving the file to OneDrive instead of SharePoint as this issue only seems to affect new rows added to spreadsheets on SharePoint. Not sure whether you have OneDrive but might be worth looking into using it while this bug is still affecting the Microsoft Excel app. Hopefully that’ll help! 🙂

C

@SamB Great! Thank you for the help - will be looking forward to a response towards the bug. I have seen the auto replay feature but am not upgraded to the plan currently. Thanks for your help on this!

iceman

Is there an update on this? We’re also experiencing this issue.

JammerS
Userlevel 6
Badge +3

Hi @iceman 

I’ve added you to the list of affected user, and we’ll  notify you via email once an update is readily available. Thanks.

jammer․solijon
A

Any update on this? We’re experiencing the same issue. Although with some Zaps it refuses to successfully run even on replay. 

ken.a
Userlevel 7
Badge +6

Hi there @Adam Bakal,

Unfortunately, there are no new updates regarding this open bug. In the mean time, I've added you to the list of affected users for the ongoing bug report. We'll notify you via email once it's resolved.

Please note that the duration to fix bugs can vary due to several factors. We prioritize based on the bug's complexity, the number of impacted users, and the overall scope. The resolution might also depend on whether it's an issue within our domain or if collaboration with partner apps is required.

Thank you for your patience and understanding.

Reply


Terms & Conditions