About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

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

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

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.

Best answer

Copy New OneDrive File to existing but unknown-named Folder in OneDrive

S
Userlevel 1
Badge +1

HI,

For the purpose of this question, all files and folders are in OneDrive.

I have a new client JotForm that is used to kick off some automations.  The built in JotForm/OneDrive integration uploads a New Client PDF file to an existing folder in OneDrive. That all works fine.  

At the same time, I have a Zap that creates a new folder based on the client’s name from the JotFrom in an existing Master Client Folder.  At this point I have the desired PDF in one subfolder and the new desired target subfolder created.  All good so far.

Next, I would like a Zap to copy that New Client PDF from its current subfolder (I think I use the Zap/OneDrive integration New File trigger) to the New Folder named for the new client that was just created in the Master Client Folder.  I can’t figure out how to tell Zapier how to find/identify the newly created folder to deposit the PDF.

Any suggestions are appreciated!!

icon

Best answer by Troy Tessalone 9 May 2022, 18:04

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

5 replies

Jillian
Userlevel 4
Badge +6

Hello @Scott3294!

Alright, so it sounds like you have a few Zaps running to make this process work. Just to check my understanding, you have:

Zap 1 - JotForm to OneDrive: Client fills out a JotForm which creates a PDF that is uploaded to an existing “Master Client” folder on OneDrive.

Zap 2 - JotForm to OneDrive: Client fills out a JotForm which creates a folder on OneDrive.

You’d like to have a third Zap. Zap 3 - OneDrive to OneDrive: Copy of PDF in “Master Client” is moved to new “[Client Name]” folder on OneDrive. Correct?

 

If I’m understanding your workflow correctly, you should be able to achieve Zap 3 in Zap 2 by using the “Find Folder” trigger and then adding in an additional “Upload File” step. Keeping it all in the same Zap lets you reference previous steps.

 

Let us know how it goes!

Troy Tessalone
Userlevel 7
Badge +14

Hi @Scott3294 

Perhaps consider a different execution of your Zap steps.

 

One thing to keep in mind is that you could encounter a race condition where one Zap triggers/finishes (new file in folder) before the other (create folder) which actually needs to be completed first.

 

Zap Steps

  1. Trigger: Jotform - New Submission
  2. Action: OneDrive - Create Folder
  3. Action: OneDrive - Upload File
    1. Map the Folder ID from step 2
    2. Map the PDF from step 1
⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
S
Userlevel 1
Badge +1

HI,

Thanks for the suggestions!  Sorry for the delay...have not had a chance to get back to this.

I worked on it tonight and the hold up is that I can’t find the PDF.  I set up the order like Troy suggested...having the folder create as the first step after the New Submission.

When I get to the point of uploading a file...I map the folder ok, but then have no way to find the PDF that was created by the New Submission.  The only options presented are the Jot Form submission (which does not contain the PDF) or the create folder routine.  

I know where the PDF is saved from another process, but I don’t know how to find it in this step.

Thanks!!

Troy Tessalone
Userlevel 7
Badge +14

@Scott3294 

If you know where the PDF is being saved in a GDrive Folder, then try using a GDrive Find File step in the Zap if it uses a consistent file naming convention.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
S
Userlevel 1
Badge +1

Thanks Troy!  It took me a bit to figure out which action to select, but with a little trial and error, it worked.

Thanks for your help!!!  Jillian also!

 

Scott

Terms & Conditions