Power Platform Community Forum Thread Details

I am looking to list all of the files in a well organised folder structure in onedrive.

The end result is to use the folder names as metadata for the files in a flat sharepoint document library.

I can across this thread, and obadiahjohnson has posted the answer I am looking for but some of the linked pictures are broken.

https://community.powerplatform.com/forums/thread/details/?threadid=2e5c0247-e56c-412d-ab6e-eb1308ef6ccf

I am struggling to figure out the condition inside the apply to each and I think that is what is shown in the missing picture. There must be a list files in folder action in there somewhere.

Thanks very much for any help or pointers!

Categories:

Building flows

That's how I would do it.

Initialize 3 variables

To get the id of your initial folder, add an action "List files in folder", select the folder and open the actions "Peek code". Copy the value of the object's input/parameters/id

Do until

Do until Index is greater or equals length of FolderProps

Change the count limit to an appropriate value.

List files in folder

variables('FolderProps')[variables('Index')]['Id']

Filter array Files

Filter for files (isFolder is false)

Compose NewFileProps

union(variables('FileProps'), body('Filter_array_Files'))
 
Set variable 2
Set variable FileProps to Compose_NewFileProps

Do the same with FolderProps

Last action in the loop:

Increment Index

It might be a good idea to check all boxes in its Run after configuration

After the loop is ready, the FileProps variable contains the file properties of all files in all folders including subfolders.

Community site session details

How to get a flat listing of all files with path for all subfolders in onedrive

Helpful resources

News and Announcements

Quick Links

Forum hierarchy changes are complete!

Ajay Kumar Gannamaneni – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Power Automate

Featured topics

Product updates