Counting Values in Sharepoint List with Power Automate

(0) Share

Report

Posted on by glandrum

Howdy I am trying to figure out how to create a flow to count how many times either of 2 out of 4 values occur in a choice column in a sharepoint list. Then i need to take that number and update another list

Categories:

Building flows

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Kalathiya 209 on at

Like (0)

Report
Hello @glandrum,

If you need to count how many times specific values appear in a SharePoint choice column and then update another list based on those counts, you can use Power Automate's union() function along with filtering and iterating logic to achieve this efficiently.

Seps to Count Unique Values and Update a SharePoint List in Power Automate:

1. Get Items from SharePoint.
2. On Select action select the choice column value.
3. Use union() to get distinct values from the choice column.

union(body('Select'), body('Select'))

4. Loop through the unique values.
5. Filter the items for each unique value and count how many match.

@equals(item()?['ChoiceColumnName/Value'], items('Apply_to_each'))

6. Add compose to store the length

length(body('Filter_array'))

6. Update the target list with the counts.

Output:

📩 Need more help? Mention@Kalathiya anytime!
✔️ Don’t forget to Accept as Solution if this guidance worked for you.
💛 Your Like motivates me to keep helping

Was this reply helpful? Yes No