Count Number of files in SharePoint folder

Introduction:

This blog explains how to Count No of files in SharePoint folder using MS Flow.

Steps to be followed:

1. Select “Send an HTTP request to SharePoint” from Actions.
2.  Enter below details:Site Address: Select the site address from the list.Method: GETUri: _api/web/GetFolderByServerRelativeUrl(‘LibraryTitle/foldername’)/ItemCountExample: _api/web/GetFolderByServerRelativeUrl(‘account/CFS Organization_584732FD1267E911A997000D3AA2C8D1‘)/ItemCount

   -> It will count the no of files in “CFS Organization_584732FD1267E911A997000D3AA2C8D1” folder.

Output of above request: 

Accessing value of ItemCount:

1. Add Compose Action.
2. Add below expression in Inputs:

body(‘Send_an_HTTP_request_to_SharePoint_’)[‘d’][‘ItemCount’]

The post Count Number of files in SharePoint folder appeared first on Cloudfronts - Microsoft Dynamics 365 | Power Bi | Azure.