Skip to main content

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

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions 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.

I have an Excel file stored in a SharePoint site. On one of the sheets, there’s two rows - a header row with the ‘ID’ of the KPI, and then a formula underneath it that returns a number (it’s counting from another table in the workbook, so it's a COUNTIFS formula).

I’ve tried access this number in Zapier by connecting to the document via SharePoint, and I’ve also linked the SharePoint folder to my OneDrive and connected it that way. Both ways Zapier is able to find the document, the sheet, and the first row without any issues, but it always seems to think the number in row 2 is 0 - regardless of whether it is or not. This is an issue regardless of what the number in this row actually is. 

Any ideas what could be going wrong? Or what I could try to troubleshoot?

Hi ​@duanehumphreys,

 

Welcome to the Community.

If your Zap isn't reading calculated values from an Excel file on SharePoint, check that your account has the correct permissions. Zapier may not evaluate formulas directly, so try storing the result in a separate static cell. Manually recalculate and save the workbook, and ensure you're using the "Excel Online (Business)" integration. Test with a static value to isolate the issue, and confirm the cell's data type is compatible. If problems persist, consider using Power Automate to copy formula results into a static cell that your Zap can access.

Feel free to ask if you need further help or have additional questions. We're here to assist you.
 

Hi there, ​@duanehumphreys 👋

How did you get on with Jammer’s suggestions here? Was it a permissions issue that was preventing the value from being read correctly?

Happy to lend a hand if you’re still stuck at all, want to make sure this gets sorted! 🙂

Hello ​@SamB and ​@JammerS 

Turned out this was actually something to do with the formula - I moved some of the calculation into the table it was referencing and simplified the COUNTIFS formula, and that seemed to fix it.

Hi ​@duanehumphreys,

 

Thank you for sharing your solution with us. Moving part of the calculation into the table and simplifying the COUNTIFS formula helped resolve the issue you were experiencing. That's great to hear.

Feel free to reach out if you have any further questions or need additional assistance with Zapier or any other integrations. We're here to help.

Terms & Conditions