cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mdemarici
Frequent Visitor

when a document is uploaded, create a folder with the client's name and put the document in the folder.

Hello everyone,

 

I would like to build a flow that helps with aggregating client documents. For context, we receive a lot of different types of documents for our clients. these documents come from different companies that both us and our clients deal with. 

 

Currently when we receive a document we tag it with the client's name who it is associated with, the type of document it is, and the Company it came from.

 

Here is what I would like to do with flow but currently stuck on how to do so.

 

for context, Let's say I received a file for my client, Chris, and the file came from the company, Microsoft. 

 

I would upload that file to my general document library, tag it with "Chris" "Microsoft" and doc type "Financial"

 

I would like the flow to Create a "Chris" folder under a parent folder labeled "Clients" --> if "Chris" folder is already there skip this step --> then create a "Microsoft" Folder under the "Chris" Folder ---> if the "Microsoft" folder is already there skip this step ---> then finally copy the file with all the tags to CLIENTS/Chris/Microsoft. 

 

so then if I received a document for Mike from Skype, ultimately the document would end up in CLIENTS/Mike/Skype whether or not the Mike or Skype folder existed.

 

how would I go about checking if these subfolders exist, creating them if they do not, and then finally copying the file over to that subfolder?

 

Thank you so much for reading!

 

 

2 REPLIES 2
efialttes
Super User
Super User

Hi!

"Currently when we receive a document we tag it with the client's name who it is associated with, the type of document it is, and the Company it came from."

 

Sharepoint? If so, can you share more details on the way you tag it? Do you store it in a library, created metadata columns to add type of document, company, client name? THe more information context, the faster will be to get useful insights

 

Thanx!

 



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Thank you for your response, @efialttes 

When we receive the file we upload it to a SharePoint site where our document library is. Our document library has multiple levels of folders - Company --->  Type (Financial, legal, reports, etc.) ---> year. Once it is uploaded in the correct folder, we currently tag document type, client, and department of the company it came from. For this flow, I've built managed metadata term stores for the client names which populates the column in which i hope to trigger this flow. The most important columns for this flow so far would be Client (managed metadata), Document type(Choice), and Company name(default, or choice).

 

The goal would be to aggregate all of the Client documents into their individual folders once a file is uploaded to the document library and tagged. I don't plan on the Client folders to have as many levels of folders that we implement in our main document library.

 

The goal would be for the flow to trigger when a document is added to our document library and is tagged. Ideally it would copy the file to a Folder with the Clients name (if not there create it) ---> then to a folder with the company's name it came from (if not there create it). Within this last folder the document would maintain all tags and be sorted by them instead of the folder structure in our main document library. (type --> year, etc.)

 

The part where I am specifically stuck is where the flow makes folders based on the clients name/company of origin or copies the file to the correct folder if it is already there. 

 

Thank you!

Helpful resources

Announcements
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

PA Survey Carousel Image.png

We want to hear from you!

If you are a small business ISV/Reseller, share your thoughts with our research team.

Users online (1,152)