Answered

Count number of files in OneDrive folder

(0) Share

Report

Posted on by Community Power Pla...

Hello Everyone,

i have a OneDrive folder with X amount of files in it (less then 100). Every X hours i want to compose them all into one file and have a new file that includes how many files there have been.

20221212_fileA

20221212_fileB

20221212_fileC

20221212_fileD

-> Composed to 20221212_filesComposed_4files

The flow starts with a "get files" and so i thought i could just use this solution presented here:

https://powerusers.microsoft.com/t5/Building-Flows/count-files-folder-onedrive/m-p/275945#M28379

It does however not work so i am looking for help from you all if possible.

Kind regards

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Expiscornovus 33,195 Most Valuable Professional on at

Like (1)

Report
Hi @Kastore,

Like in that link you can use a length function in an expression to get a file count.

Below is an example

The expression is used in the File Content of a new text file.

string(length(outputs('List_files_in_folder')?['body/value']))

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

Like (0)

Report

Hello @Expiscornovus

that works like a charm.

Only point is that there is also a folder in that directory which is also included in the count. Is there a way to skip the folder or just substract one from the "length" expression?

Was this reply helpful? Yes No
Verified answer

Expiscornovus 33,195 Most Valuable Professional on at

Like (1)

Report
Hi @Kastore,

You can filter on the IsFolder property and make sure it is false. This way if in the future you add even more folders to it, it will still work 😉

The length expression will be a bit different because it counts the outputs of the Filter Array action instead:

string(length(body('Filter_Array')))

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

Like (0)

Report

Cheers mate.

that is basically the same solution as in the link that I saw but reduced down to what matters. The link with the variables always made troubles - the direct route via "filter array" works like a charm and filters out the folder.

Was this reply helpful? Yes No