web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Filtering different en...

Power Automate

Answered

Filtering different entries in a column in Excel

(0) Share

Report

Report

Posted on by PatrickSched

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

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

PatrickSched 212 on at

Like (0)

Report
Copy link

Link copied!

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".

Was this reply helpful? Yes No
Verified answer

v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @PatrickSched ,

I made a sample for you.

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

Best Regards,

Wearsky

Was this reply helpful? Yes No

Join the conversation