
Hi,
I have a SharePoint List column data (This data will be changing daily based on requirement)
Department |
STORES |
Machine Shop |
PUA4 |
HR |
MAINTENANCE |
STORES |
STORES |
Machine Shop |
My Flow
I am getting unique department details by Compose action
Request your support to Count department wise (length) function in power Automate or any other alternate method.
Final output required as follows in html table.
Department | SUM |
STORES | 3 |
Machine Shop | 2 |
PUA4 | 1 |
HR | 1 |
MAINTENANCE | 1 |
Thanks & Regards
Hi @knsrinath ,,
Do you want to count every item in the same department?
If so, I have a test for your reference.
In my scenario:
union(body('Select_2'),body('Select_2'))
items('Apply_to_each')['Title']
length(body('Filter_array'))
Best Regards,
Sunshine Gu