Skip to main content

I am trying to use the Add row in MS Excel action. I have selected Sharepoint as the source but when I try to select the folder, I am getting this shown only 

 

Hi there @automate_with_rezwan,

Welcome to the Community! 🎉

Before we dive deeper, could you please try reconnecting your Microsoft Excel account here: https://zapier.com/app/connections/excel

After that, please head to the “Folder” field again, and see if it’ll load the folders you’re looking for.

Please keep us posted! 😊


https://temu.com/u/nN9KdU3JPGvsph


@ken.a  I did that but the results are same.


Thanks for the update @automate_with_rezwan!

I have a few questions for you:

I'm asking because it is only possible to work with folders in the Default Sharepoint at the moment. I wonder if this may be the issue.

90cefa98b4b37395cbe1843919c6da39.png
(view larger)

Please keep us posted! 😊


@ken.a This is url structure for the sharepoint Exel file 

https://xxxxxxxx.sharepoint.com/:x:/s/xxxxxxxxxxxx/ETyP4Gt9XiZLgiHfAKaL_awBvN55eNXW7iqF2Xz5SUsD4Q?rtime=l_YDpsOx20g

So I think it’s a custom one ( though I am not sure )


Hi @automate_with_rezwan,

My hunch here that it’s a custom Sharepoint site. Unfortunately, we don’t support custom Sharepoint sites at the moment. We do have an open feature request to add Support for custom SharePoint sites as a Storage Source in Microsoft Excel. I have added your email address to the feature request. That does a few things:

  • Bring this to the attention of the integration developers
  • Help track interest in this feature being implemented
  • Allows us to notify you via email if this feature becomes available in the future

While I don't have an ETA on when this feature might be implemented, we will notify you via email if it is!

Now, regarding your current situation, there's a similar case where a user moved their folders back to the default SharePoint site, and it worked for them. I'm not too familiar with the process of moving folders back to the default SharePoint site, but it might be worth giving it a try.

Hopefully, this helps!


I would also like to be added to this feature request or tell me how to upvote! In meantime, I’ll subscribe to this community thread in case any updates come along. Thx.


Hi @awoodcock,

 

I’ve added your vote for this feature request, and we’ll notify you via email once an update is readily available. Thanks.


@ken.a I too would like to be added to this feature request and upvote this! Thanks!


Hi @Nikki Peace,

 

I’ve added your vote for this feature request, and we’ll notify you via email once an update is readily available. Thanks.


I am surprised that this is not already a feature. Currently, I am having to use an alternate automation tool to make the changes to SharePoint Excel files which is creating a lot of extra work. Having this available in Zapier would allow me to keep everything in my Zap!

@JammerS Please add my vote and my email to this feature request.


I would like to add my vote to this feature request! Without it we’d have to store a random folder on our company intranet site which is far from ideal. Getting this feature added would be a game changer for our using of Zapier with Microsoft products.


Hi @darvinm and @Austin_Hallman,

 

I’ve added both of your votes for this feature request, and we’ll notify you via email once an update is readily available. Thanks.


Hi folks, 

I’m happy to report that the feature request has been implemented! 🎉

In case you missed the email notification that went out here’s the key details from it that you need to be aware of:

“we've added support for Sharepoint sites to all our Excel features! When you select sharepoint as your storage source, you can now also select a specific site.

To use this new feature in a new Zap you'll need to reconnect your existing account, or connect a new account. This will ensure your permissions are up to date and ready to load your Sharepoint sites. If you want to edit an existing Zap that is using Microsoft Excel (Legacy), you'll need to update when prompted before connecting a new account.”

Hope you’re able to give this a try soon and if you run into any issues do let us know. In the meantime, happy Zapping! ⚡️