Unanswered

Getting properties of all subfolders within a main folder

(0) Share

Report

Posted on by benny_blanco

Trying to get the name of each SharePoint folder inside of a main folder using Power Automate and then compare it with a column value in a SharePoint list. And then if these values match, if the folder name contains the value that is in the list column, to move that same subfolder to a new location. So let's say we have a main folder entitled Library1 and inside of it we have many subfolders with different names. And then we have a SP list. I want when a new item is submitted in that list, to get the value of let's say the Title of the submitted item, compare it to all subfolder names in the main Library1 and if it finds a subfolder name that contains the value from the list item Title field, to move the matching subfolder with its content to a new location. Any ideas would be appreciated!

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

danvarga Microsoft Employee on at

Like (0)

Report

Hi @benny_blanco ,

Unfortunately, Power Automate does not have an action for getting a list of folders. You can get the folder metadata, but is only for one folder. I was thinking about this a way to do this and maybe works if you get all folders from Power Shell and then execute the Power Shell in Power Automate.
Here is a PowerShell for getting the information: http://johnliu.net/blog/2018/4/run-any-pnp-powershell-in-one-azurefunction-from-microsoft-flow

And here you can find an example for executing a script in Power Automate: http://johnliu.net/blog/2018/4/run-any-pnp-powershell-in-one-azurefunction-from-microsoft-flow

Hope it helps.

Was this reply helpful? Yes No
Verified answer

benny_blanco 68 on at

Like (0)

Report

I managed to make it work with Power Automate alone. So basically what I did is to trigger the automation when a new item is created in the list. Then get the list item via the Get item action. After that I used the List folder action to get the information of the mentioned folder. Then I used the Filter array to check only for folders within that folder, so any other files could be skipped. And after that I'm comparing if the Name of the folder contains the Title of the list item, to move that folder with all of its content to a new destination.Here's the Flow and the way I've set it:

Was this reply helpful? Yes No