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