You’re offline. This is a read only version of the page.
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
Hi @jamiem4
You can refer the logic mentioned in one of my previous solutions to get count of each category:
If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.
Share
Report
All responses (
Answers (
15,169
