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


Report
All responses (
Answers (