Hi All,
I am creating flow with below fucntionality.
1. Whenever record is created in MS CRM create some folder structure in SharePoint.
2. Count no of files in each folder and update that number in MS CRM.
Example: On Create of Account create "Contact" and "Related Document" folders in SharePoint and count files in each folder and update in "Contact count" and "Realted Document Count" fields in Dynamics respectivly.
I completed point 1 succesuuflly but I am not able to count no of files in each folder in SharePoint.
How can we add filter query on "Get item" to retrieve and count no of files in that particular folder
Below is the screen Capture:
Solved! Go to Solution.
Hi,
If you only want to count the files in the specific folder you can maybe use the action 'Send an HTTP request to SharePoint':
As Uri: /_api/web/getfolderbyserverrelativeurl('/sites/testflow/LibraryTitle/foldername')/ItemCount
As a result you get the items in this specific folder.
Hope this helps! Otherwise let me know 🙂
Willemijn
Hi,
If you only want to count the files in the specific folder you can maybe use the action 'Send an HTTP request to SharePoint':
As Uri: /_api/web/getfolderbyserverrelativeurl('/sites/testflow/LibraryTitle/foldername')/ItemCount
As a result you get the items in this specific folder.
Hope this helps! Otherwise let me know 🙂
Willemijn
User | Count |
---|---|
38 | |
35 | |
15 | |
13 | |
12 |
User | Count |
---|---|
23 | |
20 | |
18 | |
13 | |
13 |