web

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

Power Platform CommunityForums Power Automate Count column data

Power Automate

Unanswered

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:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-yetonggu-msft on at

Like (0)

Report
Re: Count column data

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

Was this reply helpful? Yes No

Join the conversation