Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Answered

Filtering different entries in a column in Excel

(0) ShareShare
ReportReport
Posted on 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 at
    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 at
    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

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May 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 >