Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Unanswered

Flow to count how many times an items appears in a column

(0) ShareShare
ReportReport
Posted on by 18
Hi
 
I have build a flow that works perfectly if i filter on one specific item in the list. then it counts perfectly how many times this item appears in the list.
My flow of course has to do this but for the whole list not just the one item. i have tried but not found a good way to make it work just yet. I also did some research on what i could use, and what i could do. But it usually seems to run forever without getting anywhere.
 
This is my flow (with a filter on one item in the column: SPO_CODE eq '1517':
 
Get items - (list1)
get items - (list2)
initialize variable - codecounts: integer, 0
initialize variable - codecounted: integer, 0
apply to each: value -> get items - (list2)
condition: length(outputs('Get_items_-_(list2)')?['body/value']) is greater than 1
if yes:
increment variable: codecounts, 1
after apply to each: set variable: codecounted, variable codecounts
then i do a get items again, and update a list with the variable i counted.
 
Any advice is welcome!
Thanks
-Nele

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 >