Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Unanswered

How i do distinct the multiple value from parse json

(0) ShareShare
ReportReport
Posted on by 4

Status in the html table in this pic is in progress how can i show status count and distinct user name 

  • takolota1 Profile Picture
    4,896 Super User 2025 Season 1 on at
    Re: How i do distinct the multiple value from parse json

    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

  • Shaikh_208 Profile Picture
    4 on at
    Re: How i do distinct the multiple value from parse json

    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.

  • Shaikh_208 Profile Picture
    4 on at
    Re: How i do distinct the multiple value from parse json

    @grantjenkins 

     

     

    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.

  • grantjenkins Profile Picture
    11,059 Super User 2025 Season 1 on at
    Re: How i do distinct the multiple value from parse json

    Are you able to show the actual output you are looking for? Sorry, just a bit confused what the final result would be.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1