web

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

Power Platform CommunityForums Power Automate - Building Flows How to get list count ...

Power Automate - Building Flows

Answered

How to get list count by category and populate another list with these values

(0) Share

Report

Report

Posted on by abhikhopade

7

Hi ,

I have a list List-A which has category column with values (-5, 'Select','5), What I needed is to populate another list List-B with values

Title Count

Total Count 25 (Total List-A Count)

Completed 10 (With Positive values)

In-Complete 5 (With negative values)

Pending 5 (With 'Select' Values)

How to achieve that in one flow?

Regards,

Abhijeet

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

PrasadAthalye on at

Like (0)

Report
Re: How to get list count by category and populate another list with these values

You can follow these steps...

Use Get Items to query all items.

Use Compose One and Take count of Get Items Output Value Collection for Total Count

Use Filter array and filter category is equal to -5.

Use Compose 2 and Take count of Filter Array Output Collection for Completed Count

Similarly add Filter Array and Compose 3 and 4 and collect counts.

Finally Create new List Items using these Compose objects.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Leaderboard > Power Automate

#1

Michael E. Gernaey 691 Super User 2025 Season 2

#2

Tomac 431 Moderator

#3

developerAJ 266

Last 30 days Overall leaderboard

Featured topics

Share your ideas and struggles with building Power Automate flows!

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans