Status in the html table in this pic is in progress how can i show status count and distinct user name
Announcements
Status in the html table in this pic is in progress how can i show status count and distinct user name
If you need to get distinct values in a JSON array based on set columns, try this template: https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/Get-Unique-Records/td-p/2191533
I have a SharePoint list called CSO_Support where i have two columns, one called "CSO User" and another "Current Status", where you have three options "In Progress","Resolved","Escalated". I would like to be able to create a flow how many tickets, for example how many In Progress Resolved Escalated done tickets counts by CSO User in such a month.
I have a SharePoint list called CSO_Support where i have two columns, one called "CSO User" and another "Current Status", where you have three options "In Progress","Resolved","Escalated". I would like to be able to create a flow how many tickets, for example how many In Progress Resolved Escalated done tickets counts by CSO User in such a month.
Are you able to show the actual output you are looking for? Sorry, just a bit confused what the final result would be.
Michael E. Gernaey
497
Super User 2025 Season 1
David_MA
436
Super User 2025 Season 1
Riyaz_riz11
244
Super User 2025 Season 1