Skip to main content

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

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions 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.

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? 
 

 

Hi @freezedriedusa 

Good question.

Try clicking the right arrow on an option.

 

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. 

 

@freezedriedusa 

Try clicking the Load More] button.

 

@freezedriedusa 

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

 

 

 


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…

 

 

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! 

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

 

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. 

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!

Reply


Terms & Conditions