Skip to main content
Best answer

Zap cannot find a folder in SharePoint even though it exists


Hello! Very new to Zapier but I’m having trouble with trying to find a specific folder in SharePoint…

 

Long story short I’m using a Bubble.io trigger to pull data from. Here is the data record being pulled.

 

The main thing here is the Client Folder Name that I’m trying to find. Just to show that the folder currently exists, here is the folder in SharePoint.

 

After the trigger I have the zap search for the file in SharePoint.

 

The site is the client report center, the folder is the share documents (which is the correct path, as I have double checked twice), and the folder is the client folder name from the record that bubble pulled. But once I test to see if it can find the file (which currently exists) it gives me this error.

 

I’ve already made sure that I and pulling the most recent data from Bubble. I’m not sure why it cannot find the file and I’ve been racking my brain for hours trying to troubleshoot. Anyone know what the issue could be?

Best answer by SamB

Hi there, ​@colibri23! 👋

We’ve got a feature request open for a “Find Folder” action to be added so I’ve added your vote to that. While I can’t guarantee if or when it will be added, we’ll be sure to notify you via email once it becomes available!

In the meantime you could try using an API Request action to search for the folder to see if it exists. It looks like Microsoft Sharepoint has an API endpoint that would allow you to search for a folder by it’s name. Check out their API documentation for more details here: Files and folders REST API reference > Folder resource. API Requests are a bit more advanced but we have a general guide on how to set them up here: Set up an API request action. And we’ll be happy to assist if you run into any trouble in setting it up, just let us know! 

View original
Did this topic help you find an answer to your question?

5 replies

JammerS
Forum|alt.badge.img+6
  • Zapier Staff
  • 2087 replies
  • January 16, 2025

Hi ​@colibri23,

 

Welcome to the Community.

 

If you're facing issues with SharePoint in Zapier, ensure you're using the correct relative path for folder access. The path starts from the SharePoint site level ("SharedDocuments/ClientFolderName") and is case-sensitive, excluding leading or trailing slashes. Additionally, verify that the connected account has the necessary permissions to access the folder. If problems persist, check the exact error message for further troubleshooting clues.

 

I hope this helps. If you have any other questions, don't hesitate to ask.


  • Author
  • Beginner
  • 2 replies
  • January 16, 2025
JammerS wrote:

Hi ​@colibri23,

 

Welcome to the Community.

 

If you're facing issues with SharePoint in Zapier, ensure you're using the correct relative path for folder access. The path starts from the SharePoint site level ("SharedDocuments/ClientFolderName") and is case-sensitive, excluding leading or trailing slashes. Additionally, verify that the connected account has the necessary permissions to access the folder. If problems persist, check the exact error message for further troubleshooting clues.

 

I hope this helps. If you have any other questions, don't hesitate to ask.

Hello, thank you for responding!

Yes I am using the correct path, in fact I was able to get Zapier to create the initial “Vince Co” folder as you see in the pictures. initially I had it search for a file and if it cannot find it, then to create it. Here’s what the entire workflow looks like…

 

Basically if it cannot find the file, it goes to the left path to create the client folder, then once its called again I want it to actually find the file (since now it exists) and then move to the path on the right, but step 2 cannot seem to find the file now, even though it exists. So the permissions are correct on SharePoint, its letting me add files, but can’t seem to find them. The exact error message is what you see in the last photo.


ken.a
Forum|alt.badge.img+6
  • Zapier Staff
  • 6252 replies
  • January 17, 2025

Hi ​@colibri23,

The Microsoft SharePoint app doesn’t have a “Find Folder” action. Are you using the “Find File” action here? If so, unfortunately, it won’t find the folder that you’re looking for since the “Find File” step only works for files.


  • Author
  • Beginner
  • 2 replies
  • January 20, 2025
ken.a wrote:

Hi ​@colibri23,

The Microsoft SharePoint app doesn’t have a “Find Folder” action. Are you using the “Find File” action here? If so, unfortunately, it won’t find the folder that you’re looking for since the “Find File” step only works for files.

Is there anyway for Zapier to recognize if a folder exists? That’s all I really need, to see if it can recognize that a client folder exists.


SamB
Community Manager
Forum|alt.badge.img+11
  • Community Manager
  • 7195 replies
  • Answer
  • January 21, 2025

Hi there, ​@colibri23! 👋

We’ve got a feature request open for a “Find Folder” action to be added so I’ve added your vote to that. While I can’t guarantee if or when it will be added, we’ll be sure to notify you via email once it becomes available!

In the meantime you could try using an API Request action to search for the folder to see if it exists. It looks like Microsoft Sharepoint has an API endpoint that would allow you to search for a folder by it’s name. Check out their API documentation for more details here: Files and folders REST API reference > Folder resource. API Requests are a bit more advanced but we have a general guide on how to set them up here: Set up an API request action. And we’ll be happy to assist if you run into any trouble in setting it up, just let us know!