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

Excel to Buffer -- invalid image error

  • 9 September 2021
  • 2 replies
  • 94 views
M
Userlevel 1

I’m using a Microsoft form on our sharepoint which populates an excel worksheet. The image url is something like https://XXXXXXX-my.sharepoint.com/personal/XXXXXXX_YYYYYY_ie/Documents/Apps/Microsoft%20Forms/Book%205/Question/pic_MY%20IMAGE%202.png

I have a zap setup to read from the worksheet and send it to our buffer scheduler but it complains of an invalid image when it gets to that point.

A URL of this form is ok tho - https://www.chortle.co.uk/images/layout/chortlelogo_small.jpg

Is Zapier unable to read sharepoint images urls or would it be a Buffer.com problem?

 

Thanks

 

 

 
https://dubcfm-my.sharepoint.com/personal/jamesgouldsbury_dublincityfm_ie/Documents/Apps/Microsoft%20Forms/Book%205/Question/pic_James%20Gouldsbury%202.png
icon

Best answer by SamB 9 November 2021, 15:05

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.

2 replies

jpot
Userlevel 4
Badge +5

Hello! If I understand correctly, you’ve got a list of image links in a spreadsheet. Is that right? I tried opening the image URL at the bottom of this post and was asked to sign in. I suspect that’s what’s happening with your Zap—it can’t pull in the image. Zapier can’t pull in an image from a URL unless it’s public, I’m afraid, and we don’t have a Sharepoint integration. Is there some way you could host the images somewhere else? 

SamB
Rank
Userlevel 7
Badge +11

Just wanted to follow up here to confirm that if the image isn’t publicly accessible (meaning a login is required to view it) then, as jpot mentioned, Buffer won’t be able to access it. You can find out more about this here: Send files in Zaps
 

It looks as though it’s possible to create sharing links for files in SharePoint, but if the files are uploaded directly via the form then it may not be possible to use a sharing link in this case. 

An alternative would be to either alter the settings on the form’s file upload fields so that the files are publicly accessible. Or to make sure that they are uploaded to a shared folder that is publicly accessible. That should then allow Buffer to be able to access the images that are uploaded.

Terms & Conditions