Unanswered

Returning Unique values and counts

(0) Share

Report

Posted on by nikkil

Hi,

I am currently attempting to use Power Automate to go through an excel table/array, and list out each unique value under a certain column I have called "Reason for Return by Contractor", and the counts of how many times each value appears. I have attempted this using apply to each loops but get many errors. Does anyone know how to do this or have done something similar in the past?

Thank you,

Nikkil

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

David_MA 12,982 Super User 2025 Season 2 on at

Like (0)

Report
You can try this:

Initiate three variables in your flow (use the names you prefer):

Values of type Array and no initial value

Unique Values of type Array and no initial value

Value Count of type string with a default value of Value,Count@{decodeUriComponent('%0A')}

Follow these with a List rows present in a table action.

Add an Apply to each with the Value output from the List rows present in a table action.

In the Apply to each, add an Append to array variable and populate it with the column that contains the value you want to get a count of.

Add a Set variable action to set the value of Unique Values using the expression, which will return just the unique values: union(variables('Values'),variables('Values'))

Add a second Apply to each and use the Unique Values variable for the output

Inside the second Apply to each, add:

List rows present in a table and add a filter query on the column with the values where it is equal to the Current item from the dynamic content. Be sure to choose the Current item value from the second Apply to each action.

Follow it with an Append to String value on the variable Value Count with the following: @{items('Apply_to_each_Unique_Value')},@{length(outputs('List_rows_present_in_a_table_Unique_Value')?['body/value'])}@{decodeUriComponent('%0A')}

The value count will generate comma separated values.

Your flow will look like this:

If you change the variable names, you will need to adjust the flow accordingly. You will also need to adjust the expressions to account for how I renamed actions. The expression decodeUriComponent('%0A') is a line break.

Was this reply helpful? Yes No
claudiovc 94 on at

Like (0)

Report

Hi @nikkil

Please try this

My data:

complete flow:

Flow detaill:
List rows present in a table

union(body('AllValues'),body('AllValues'))

Initialize varable counts as array

items('Aplicar_a_cada_uno')
item()

items('Aplicar_a_cada_uno')
length(body('Filtrar_matriz'))

This las action is for show the output flow

I hope it helps you

Greetings!

Was this reply helpful? Yes No