Skip to main content
Question

Can only choose top directory in OneDrive

  • November 4, 2023
  • 9 replies
  • 71 views

freezedriedusa

I’m trying to take a form submission and add it to a new row in an Excel spreadsheet in a OneDrive sub-folder.

The spreadsheet is located in “/Freeze Dried USA/docs/zapier/submissions.xlsx” but when I try to specify the folder, I can only choose one of the top folders. Whether I click the dot, the name or the arrow on the right, it puts “Freeze Dried USA in the folder field, and acts like it’s done. I cannot view or choose any of the subfolders. 

If I choose “Load more” it just lists the same top-level folders again below the original folder list. 

How do I drill down to the sub-folders where the spreadsheet is stored? 
 

 

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

9 replies

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • November 4, 2023

Hi @freezedriedusa 

Good question.

Try clicking the right arrow on an option.

 


freezedriedusa

That’s what I thought, but when I click the arrow, it puts the “Freeze Dried USA” folder in the field and doesn’t give me any other options, besides “Go to top folder”. I thought it might be a wierd caching issue, but I tried in a private browser and it still does it. 

 


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • November 4, 2023

@freezedriedusa 

Try clicking the [Load More] button.

 


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • November 4, 2023

@freezedriedusa 

If you know the internal ID of the Folder, then you can set that using the ‘Custom’ tab.

 

 

 


freezedriedusa


When I click “Load more” it gives me a 2nd (duplicate) directory listing of the root directory… 

Here’s the start of the directory listing the first time...

 

 

This is the end of the first list, and the beginning of the duplicate directory listing. You can see the folders in the 2nd listing are the same as above…

 

 


freezedriedusa

This is weird… I tried another folder, and it let me drill down to the sub-folders. I’ll dig into that and see where it gets me. Thanks for you help! 


ken.a
Forum|alt.badge.img+6
  • Zapier Staff
  • November 6, 2023

Hi there @freezedriedusa,

How's everything going with this issue? Were you able to sort it out? If you still need some assistance, I'm more than happy to help! 😊

 


freezedriedusa

Thanks Ken! I didn’t realize I needed to keep clicking on the Load more button until the sub-folder I want appears. I guess I was expecting a directory tree I could browse, similar to a file manager. 


ken.a
Forum|alt.badge.img+6
  • Zapier Staff
  • November 7, 2023

Hi @freezedriedusa,

Thanks for the update!

You’re correct. You’d need to click on the “Load more” button until your desired sub-folder appears. I know this is not an ideal solution, but I’ll be passing over this feedback to our internal database, which our product teams use when looking to make improvements and changes to Zapier.

I appreciate your understanding!