Unable to load Sharepoint folder when adding a new row in Microsoft Excel.

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:

• Are the folders in the default Sharepoint site? 
• Or do you have custom Sharepoint sites? 
• See here how to know if it is a default or custom Sharepoint site. 

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.

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