web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id : QPTsqWgGzz6GFQy66+9Uoz
Power Platform Community / Forums / Power Automate - Building Flows / How i do distinct the ...
Power Automate - Building Flows
Unanswered

How i do distinct the multiple value from parse json

Like (0) ShareShare
ReportReport
Posted on 9 Mar 2023 10:49:53 by Shaikh_208 4

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

powera Questiom.png
I have the same question (0)
  • takolota1 Profile Picture
    takolota1 4,925 Moderator on 09 Jun 2023 at 00:30:50
    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
    Shaikh_208 4 on 13 Mar 2023 at 06:58:16
    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
    Shaikh_208 4 on 13 Mar 2023 at 06:57:47
    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
    grantjenkins 11,059 Moderator on 09 Mar 2023 at 12:17:04
    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

News and Announcements

Welcome to the Power Platform Communities
Announcing our 2025 Season 2 Super Users!
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Telen Wang – Community Spotlight

We are honored to recognize Telen Wang as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 986 Moderator

#2
stampcoin Profile Picture

stampcoin 699 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 577 Super User 2025 Season 2

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans