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

Community site session details

Session Id : KpPg/K7tX6Ibgw3ZPdYWgp
Power Automate - Building Flows
Answered

Filtering different entries in a column in Excel

Like (0) ShareShare
ReportReport
Posted on 6 Jul 2023 12:34:53 by 212

Hello Community,

 

I would like to query in a flow how many different values are in a column in excel.

Is there a function via "Filter Array" and "Compose" to give me the number of different values in a column?

 

Thanks in advance.

 

Many greetings

Patrick

  • Verified answer
    v-xiaochen-msft Profile Picture
    on 07 Jul 2023 at 03:55:11
    Re: Filtering different entries in a column in Excel

    Hi @PatrickSched ,

     

    I made a sample for you.

    vxiaochenmsft_0-1688702005734.png

    vxiaochenmsft_1-1688702046818.png

    vxiaochenmsft_2-1688702068926.png

    vxiaochenmsft_3-1688702093251.png

    [
     {
     "1": 2
     },
     {
     "2": 2
     },
     {
     "3": 2
     },
     {
     "4": 1
     },
     {
     "5": 1
     }
    ]

     

    Best Regards,

    Wearsky

  • PatrickSched Profile Picture
    212 on 06 Jul 2023 at 12:49:09
    Re: Filtering different entries in a column in Excel

    I have "I" numbers in the template. Some occur several times, some not at all or only once or twice. I would like to query how many different values occur in the column "I".

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

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

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!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2

Loading complete