cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

When File is created move to dynamic folders

Hello all,

 

My Supervisor gave me a project to automate appraisals, So I started thinking and came to a solution with use from SharePoint.

So what I managed to make is a simple Approve/Reject Flow and my supervisor was very happy.

 

THIS IS WHAT HE ASKED, IF IT'S NOT POSSIBLE IT'S NOT A PROBLEM

What he asked next if it's possible to place newly created files in folders for each employee.

 

This is the structure: VNR Appraisals(Main doc Library) > Production(Sub Folder) > Tom,Hank,John,Doe(each employee has it's own folder) within that folder there will be folders based on the year (2016,2017,2018)

 

Next, He Has a excel file I coded some functions inside VBA so the filename wil be "text" from a CELL. When he saves this file It will be saved to /VNR Appraisals(Main doc Library/ Now the workflow should Copy/Move the File to one of the Employees folder

" /VNR Appraisals/Production/Tom/FILENAME.XLS " 

 

If the flow can move it to the date of the file this would be even more amazing.
" VNR Appraisals/Production/Tom/2017/FILENAME.XLS" 
Year will be decided by creation date, or string in the filename

 

I tried some stuff already and saw Flow can make folders based on filename.

(/VNRAppraisals/production/File name×(Dynamic content inside flow)​​/File name×(​​Dynamic content inside flow) 

 

Problem with this the Folder created during this process will have te file type at the end. ".XLS"  and the file won't be moved to the folder of current year.

 

Is my supervisors idea possible? If not the answer will simply be NO

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: When File is created move to dynamic folders

Hi @Anonymous,

 

Copying file to proper folder is possible for Microsoft Flow, but for nested folders, it would require nested Apply to Each.

And nested Apply to Each currently is not supported under Microsoft Flow.

So I am afraid currently moving the file into the proper year sub-folder is not possible.

The available workaround which I think is, rename the file name with the combinantion of people name and the proper year, then use this file name as the corresponding parameter.

Further, you may take a try with the steps provided by petervdzande in the following thread:

Create folder in SharePoint library

Which is another workaround.

For the corresponding idea:

Sharepoint Create Folder

Hope the information above is helpful.

Regards,

Michael

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Highlighted
Community Support
Community Support

Re: When File is created move to dynamic folders

Hi @Anonymous,

 

Copying file to proper folder is possible for Microsoft Flow, but for nested folders, it would require nested Apply to Each.

And nested Apply to Each currently is not supported under Microsoft Flow.

So I am afraid currently moving the file into the proper year sub-folder is not possible.

The available workaround which I think is, rename the file name with the combinantion of people name and the proper year, then use this file name as the corresponding parameter.

Further, you may take a try with the steps provided by petervdzande in the following thread:

Create folder in SharePoint library

Which is another workaround.

For the corresponding idea:

Sharepoint Create Folder

Hope the information above is helpful.

Regards,

Michael

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Highlighted
Helper V
Helper V

Re: When File is created move to dynamic folders

You can use the Move SharePoint Document from Library action to move file to nested structure of folder.

 

This action is in "Plumsail SP" connector, which is a part of Plumsail Actions product.

 

Note, it is a paid third-party solution. But it provides a rich set of actions that simplify working with SharePoint, permissions and documents.

Helpful resources

Announcements
firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Users online (6,818)