Answered

Flow to Count files in a Sharepoint Folder

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

We have a task that requires a staff member to process files in a group of sharepoint folders, and once completed, move the file into a "Done" folder.

I want to create a flow that runs daily via the Recurrence Trigger, does a count of all the files within the root folder, and adds that to a variable to be emailed.

Any advice/ideas on the best way to go about doing this?

Categories:

General topics

I have the same question (0)

All responses (17)

Answers (1)

aprildunnam 704 on at

Like (0)

Report
Copy link

Link copied!
You can use the Get Items Action and point that to your SharePoint Library. Then add a Compose action and use this formula to get the number of items:

"@length(body('Get_items')?['value'])"

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

Like (1)

Report
Copy link

Link copied!

@aprildunnam Thanks for the reply, i'll have a go at using the formula and let you know how i go. Appriciate the help.

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

Like (1)

Report
Copy link

Link copied!

@aprildunnam Tried the Get Items function, but this seems to only pull from a sharepoint list, but i want to count the files in a folder.

Was this reply helpful? Yes No
Verified answer

aprildunnam 704 on at

Like (6)

Report
Copy link

Link copied!
Sorry I should've read your message better. You need to use Get Files Action instead. That one lets you get documents from a library.

The formula would be slightly different. Need to change it to the name of the Get Files action

"@length(body('GetFiles')?['value'])"

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

Like (0)

Report
Copy link

Link copied!

Is this the Compose step your describing? If so this is the error im getting

Was this reply helpful? Yes No
aprildunnam 704 on at

Like (0)

Report
Copy link

Link copied!

Yes that's it. The issue is the text where is says "Get Files" in the parenthesis needs to match the name of your action above. So if you click the "..." in your Get Files action and rename it to "GetFiles", just like that, all one word then the compose action will work

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

Like (0)

Report
Copy link

Link copied!

Awesome, that did the trick, thanks for the quick replies 🙂

Was this reply helpful? Yes No
scoombs 12 on at

Like (0)

Report
Copy link

Link copied!

Can you provided a little more inforamtion about the Get File Action. Under Sharepoint I see no option for Get Files alone. There is Get File Properties, and Get Files (Properties Only).

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

Like (1)

Report
Copy link

Link copied!

@scoombs i used Get Files (properties only) for sharepoint.

Was this reply helpful? Yes No
scoombs 12 on at

Like (0)

Report
Copy link

Link copied!

Im also trying to get a file count on a folder within Sharepoint. I've setup a recurrence schedule to send out email every hour. This folder is under another folder. The address appears http://mysharepointsite. sharepoint.com/site/IT and a directory under IT.

Within the Disaster Recovery folder there are five files I would like to count. When I run my flow

I get an email with the Output values of 100.

Was this reply helpful? Yes No