web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Count column data

Power Automate

Answered

Count column data

(0) Share

Report

Report

Posted on by knsrinath

527

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

Categories:

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-yetonggu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
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

Join the conversation