List showing count of categorised entries in a different list

(1) Share

Report

Posted on by jamiem4

Hi,

I feel like this should be straightforward but I'm struggling!

I have a SharePoint list acting as a service desk, and I'm trying to use PowerAutomate to populate a separate list with a count of how many entries from the service desk are in each category. The 'count' list is then feeding a SharePoint site quickpart pie chart.

E.g. service desk:

Issue 1 - Plumbing

Issue 2 - Electrical

Issue 3 - Plumbing

Issue 4 - HVAC

Issue 5 - Electrical

Count list:

Plumbing - 2

Electrical - 2

HVAC - 1

Do I need a filtered 'Get Items' for each category or something? How do I map these to different rows of the Count list?

Thanks,
Jamie

All responses (1)

Answers (0)

ManishSolanki 15,085 Super User 2025 Season 1 on at

Like (0)

Report

Re: List showing count of categorised entries in a different list

Hi @jamiem4

You can refer the logic mentioned in one of my previous solutions to get count of each category:

Solved: How to create a monthly summary table from sharepo... - Power Platform Community (microsoft.com)

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.