Unanswered

Copy folders within SharePoint that begin with a certain name

(0) Share

Report

Posted on by Community Power Pla...

Hi Everyone,

I'm new to using Power Automate, but it has me intrigued and eager to learn more about it. I've searched online for similar examples but I don't see a clear answer to what I'm trying to do. It's probably fairly simple.

Want I want to do is build a flow which looks at and copies all folders (and it's contents) within a SharePoint document library that start with the name "ARC" to a second document library, while maintaining the original folder structure.

Example: When the flow runs:

It finds any folder starting with ARC in the SharePoint document library:

Document Library > My Folder 1 > ARC Documents

Document Library > My Folder 2 > ARC Administration

It will be copied to:

ARC Library > My Folder 1 > Documents (dropping the ARC if possible).

ARC Library > My Folder 2 > Administration (dropping the ARC if possible).

Any help would be appreciated.

Categories:

Building flows

I have the same question (0)

All responses (9)

Answers (0)

v-litu-msft on at

Like (0)

Report

Hi @Anonymous,

We could use the condition action to determine a file in the SharePoint if it is a folder by judge IsFolder property, it is a boolean type. Then determine the folder name whether contains "ARC Documents". If the two conditions met at the same time, copy folder to destination folder in the other SharePoint library.

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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Thanks for taking the time to help me v-litu-msft! Really appreciate it.

I modified my flow just like the example you shown me. Using a condition for yes/no is a good idea. I was trying to filter my results by using the filter within "get files" itself.

My flow seems to run, but it is giving me a false result at the condition, so the 'yes' action is not taken. In my test document library I have a folder with the name "ARC Documents", but it does not seem to locate it. Is there something I need to add to my "get files" action?

Was this reply helpful? Yes No
sebastian3 51 on at

Like (0)

Report
Hello,

If you want to safe time and performance I would recomend filtering it within the get file(properties).
I recently had some trouble with filtering foldernames as you can see in this thread.
https://powerusers.microsoft.com/t5/Building-Flows/Problems-filtering-the-Title-on-Sharepoint-Get-Files-Properties/m-p/642106#M85607
You could try this to filter the folder.
startswith(FileLeafRef,'ARC')

Afterwards you can copy the folders.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hey sebastian3, thanks for the reply.

That is what I was trying to do previously but I didn't know what the exact command was.

I tried adding the string "startsWith(FileLeafRef,'ARC')" to the get files (properties) filter, but it says it's invalid. Should I add this as an initialize variable before the step?

Was this reply helpful? Yes No
sebastian3 51 on at

Like (0)

Report

You can't save the flow or waht exactdly is invalid?

For me it works like this.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

The message I get when running the flow is this:

The function operator 'startsWith' is not supported or its usage is invalid.\r\nclientRequestId: 3c4dd7cd-435d-401c-89c2-75db298169f8\r\nserviceRequestId: 3c4dd7cd-435d-401c-89c2-75db298169f8

Was this reply helpful? Yes No
sebastian3 51 on at

Like (0)

Report

Hm it should be supported. See the documentation:
https://docs.microsoft.com/en-us/sharepoint/dev/sp-add-ins/use-odata-query-operations-in-sharepoint-rest-requests#supported-odata-query-options
Maybe its casesensitive? Can you try to write everything small?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

I think you're right. I changed it to lower case and I didn't get any errors this time. Though it appears to have successfully run, it doesn't look like anything actually happened. The folder "ARC Documents" didn't get moved.

Was this reply helpful? Yes No
sebastian3 51 on at

Like (0)

Report

I was on vacation and didn't check this site out.
Have you figured it out?

Was this reply helpful? Yes No