Move All Folders with Names Starting with a b or c including Files

[Hom3World]

Hi Power Automate

Looking to move all folders that start with a for example a , b or c to new SharePoint location. So, process is as follows

Department uploads random name.zip file into the upload directory. The extract is easy, but first issue would be zip extract process creates the folder using the randomized zip name scheme this contains directory list of sub folder with files within each of those folders.

My current file structure.

1. Staff Employment

Sub Folders
1. Data
2. Staging
3. Upload

So after this point i need to pick the sub folders folders with the files within the the random zip folder. But i need to only move folders that start with aaa , xxx for example.

Any one that can assist with this?

Regards Jordan

[annajhaveri]

@Hom3World  the random zip folder, is it getting created at specific location always? Do you want to move the random zip folder as soon as it is created, or do you want the flow to run at specific schedule like daily or weekly and then scan for random zip folders and move the folders?

[Hom3World]

Hi Anna

The random zip file name will be export from a website by our HR team and they will drop it into the upload directory. So, script will start the extract upon zip being added to the "Upload" folder.

Regards Jordan

[annajhaveri]

@Hom3World , you can create the flow as follow:

1. Use "When a file is created (properties only)" trigger for the flow, this will also trigger when folder is created. Select the SharePoint Site, Document Library and Folder (where the zip folders will uploaded)

2. Now you may want to add Delay action here, as it will take few seconds/mins to subfolders to get created. Add delay action with delay of 1-2 mins.

3. Now check if the new item that is added is folder, if file is added we dont want to do anything, so add Condition action, and configure it as below

4. Under the Yes branch of condition add Move Folder action, you will add this action 3 times, as you have 3 sub folders,  Data, Staging and Upload, configure each move action as below, the only thing that will change between these actions is Folder to Move path, and destination folder only if you want these 3 folders to go to different locations.

[Hom3World]

Hi @annajhaveri 

See below, dont think pervious item works as below  

Zip with random name is export by HR and added to “Upload”

• Currently I am extracting zip to “Staging” then deleting the zip file ready for the next upload.

Randomized Zip File Name	Folders Within Zip	Files Within Folders
Random.zip	Newusers	Files
	Newusers2	Files
	Newemployee	Files
	Newempoyee2	Files
	newsite	Files
	workload	Files
	shifts	Files
	timesheets	Files
	Timesheets2
	Lots of other folders

After Extraction – the file structure within Staging is more a less like below.

Folder with random name	Sub Folders	Files Within Folders
Random	Newusers	Files
	Newusers2	Files
	Newemployee	Files
	Newemployee2	Files
	newsite	Files
	workload	Files
	shifts	Files
	timesheets	Files
	Timesheets2	Files
	Lots of other folders

Final location “Data” should only have specific folders with

Logic thinking

If folder "Staging" contains or starts with Newusers or Newemployee or timesheets move to “Data”

Don’t wish to keep the “random” folder only want the sub folders within in the match parameters. Once move is complete delete all remaining items read for next run.

Imagined Final status 

Root	Sub Folders	Files Within Folders
Data	Newusers	Files
	Newusers2	Files
	Newemployee	Files
	Newemployee2	Files
	timesheets	Files
	Timesheets1	Files

Not sure I gave enough information originally sorry. Any help would be apricated.

Regards Jordan

[Hom3World]

currently got all the below working as expected in my main flow, testing the follow-up parts in a manual flow. Till i can figure out how to get it to work

[annajhaveri]

@Hom3World  Okay, let me know how it goes and if you have any questions or issues while testing.

[annajhaveri]

@Hom3World  can you describe what is not working?

[Hom3World]

Hi @annajhaveri 

Current Extracted Structure

[annajhaveri]

@Hom3World Please configure the flow as follows after the Delete file action:

1. To get the folder at location where you file was unzipped, configure the actions as follows (this is done because you may not have New Folder (4) always when you unzip the zip file)

2. Then add condition action to determine the list of folders that you have got is one or more. This is done if you have more folders along with New folder (4)

Use following expression in condition

length(outputs('List_folder_-_get_zip_folder')?['body'])

3. Now in No Branch of condition add following actions to get the sub folders of New Folder (4)

Here use this following expression

first(body('List_folder_-_get_zip_folder'))['Name']

4. Then add List Folder action and configure it 

5. Now add Apply to each action and provide Body as input of apply to each (Body from the above List Folder action). Then add condition action to determine which folders you want to copy, the expression i have provided below as well. Then in Yes branch add Move Folder action to Move the required folders to desired location

Expression for condition action to check the folders you want to move, add more equals conditions as per the folders you want to move, i have created expressions for four folders for example

or(equals(items('Apply_to_each_2')?['Name'],'Newmployee1'),equals(items('Apply_to_each_2')?['Name'],'Newmployee2'),equals(items('Apply_to_each_2')?['Name'],'Newmployee3'),equals(items('Apply_to_each_2')?['Name'],'Newmployee4'))

Now we need to add same set of actions under Yes branch of Condition 3 action (the same actions we added to No Branch of Condition 3 action) the only difference is add Apply to each action and provide body (from List Folder - Get Zip folder action) as input to apply to each and then add same actions which we added in the No branch..

I know its lot of instructions, if you feel confused let me know. 

[annajhaveri]

Also one more thing add below trigger condition to your trigger of the flow from settings, so that your flow doesnt trigger for every subfolder created when the zip file is extracted in SharePoint

@endsWith(triggerBody()?['{FilenameWithExtension}'], '.zip')

This way the flow will only trigger when zip file is added to the folder.

[Hom3World]

This is awesome, no longer need that staging folder now.

Thanks.

[Hom3World]

@annajhaveri 

or(equals(items('Apply_to_each_2')?['Name'],'Newmployee1'),equals(items('Apply_to_each_2')?['Name'],'Newmployee2'),equals(items('Apply_to_each_2')?['Name'],'Newmployee3'),equals(items('Apply_to_each_2')?['Name'],'Newmployee4'))

How does this work if i want to match contains ? If name contains xxx or yyy?

As the data will actual have 100s if not thousands to employees 

folder names would only start with 

Newemployee
Newuser

ie

Newemployee_Staff member name
Newuser_Staff member name

Regards Jordan

[annajhaveri]

@Hom3World to check contains, just replace the equals with contains as shown below

or(contains(items('Apply_to_each_2')?['Name'],'Newmployee1'),contains(items('Apply_to_each_2')?['Name'],'Newmployee2'),contains(items('Apply_to_each_2')?['Name'],'Newmployee3'),contains(items('Apply_to_each_2')?['Name'],'Newmployee4'))

[Hom3World]

Hi @annajhaveri 

Getting an error saving?

Get folder only available e under the when item created is this the issue

Correct to include a valid reference to 'List_folder_-_get_zip_folder' for the input parameter(s) of action 'Get_folder_metadata_using_path'.

[annajhaveri]

@Hom3World  It looks correct, not sure why it is erroring out. Try renaming the action to ListFolderGetZipFolder, then use 'ListFolderGetZipFolder' instead of 'List_folder_-_get_zip_folder' in the expression.

[Hom3World]

Hi @annajhaveri 

Got that one path working, but if i try upload live data i get a failure on zip extract now? Folder base is around 100 folders. But this size is only around 4 megs currently. Seems a bit odd

  "status": 413,

  "message": "Archive content is too large. It contains more than '100' files or more than '314572800' bytes in total.\r\nclientRequestId: 85926fed-6bfb-4942-bef5-7b38fd5ae57e\r\nserviceRequestId: 7103a79f-40b9-2000-6f5b-917084cd567d;7103a79f-30bc-2000-6f5b-9b0bb41d0a2e;7103a79f-10bf-2000-6f5b-94ae073e8935",

  "error": {

    "message": "Archive content is too large. It contains more than '100' files or more than '314572800' bytes in total."

  },

  "source": "sharepointonline-ne.azconn-ne.p.azurewebsites.net"

}

[annajhaveri]

@Hom3World  It looks like extract folder action has limitation on zip file size. Is it possible for the user to extract the zip contents and then upload to SharePoint?

[Hom3World]

Hi @annajhaveri 

Is there anyway to work around this issue? Folder structure is always going to have more than 100 folders, but data size is currently only around 4-10 megs. Seems crazy this cant be done with such small amounts.

Can we maybe move data to azure server then extract. Move back to sharepoint?

Also one last question on the yes branch what conditions have been set?

Regards Jordan

[annajhaveri]

@Hom3World  you can create you own API to extract zip and upload files to SharePoint folder and then call that API using HTTP action or Custom Connector in Flow. 

Below is the explanation of question of condition you have asked for: 

1. List folder - get zip folder - this action gets all the folders where the zip folder is extracted. So there could be other folders at same location or just the zip folder which was extracted. So there could be one or more folders. So that condition is to check whether the action "List folder - get zip folder" returned one folder or more than one. If it returned just one folder (which would be the folder which we got from unzipping the file), then we directly use that folder and do further processing, and if it returned more than one folder, then we need to loop through the resulting folders and find the unzipped folder and do further processing. I hope that makes sense?