Power Platform Community Forum Thread Details

Hi!

I'm looking for some help to create a Power Automate.

Goal

Put simply, I'm trying to create an instant flow that :

1. Scans files/folders from SiteA ;

2. Looks for specific strings in file name (ie. contains "XYZ" and ".pdf") ;

3. If found, copy that file from SiteA to SiteB with same folder structure;

If folder structure exists, place file in same location as SiteA (mirror);
If part of, or full path is non-existent, create the part of, or full path, then copy this file at end of Path ;

This flow would be to set-up the SiteB for use. Afterwards, I would use an Automated Flow that uses the same logic, but on an Added/modified file trigger.

What I made so far

I'm working in a french environment in Sharepoint so I'll textually describe my flow instead of posting screenshots :

Initialise empty variable "FullPath"
Initialise empty variable "FolderPath"
Get file properties in SiteA
Loop all file
1. IsFolder = true
  1. If yes
    1. Set "FullPath" Variable to dynamic Full Path
    2. Set "FolderPath" Variable to expression :

substring(variables('FullPath'),18, sub(length(variables('FullPath')),18))

(This trims down the "Shared Documents" string since dynamic Full Path starts at the Site's root)

Create Folder with "FolderPath" variable in SiteB
Then I use the dynamic Folder Path to copy the files satisfying the string conditions to SiteB.

What I don't like about this flow is that it takes a lot of time to complete since it scans all files AND folders, plus it creates superflous folders that won't contain any files in SiteB.

It seems to me that it would more optimal if the folder creation portion of the flow would be on a "per file" basis. I've searched through forums and I can't seem to find a simple way to do this, unless I'm missing something?

I'm not a programmer, but I learn fast. I'm not afraid of using variables and expressions to make this work if needed. I would just need a programmer's perspective/experience to help me understand how to make this work.

Thanks for you help!

Categories:

Building flows