Count occurrences of a value in an array

[cbohlman]

Hello,

I am looking for solutions to counting the number of times a value occurs within an array.

I have a SharePoint list that has an award nomination as an item. I've added columns for each committee member (9 members) to select their vote for that nomination. 

I want to build a flow that will get the item, store the values of the vote columns in an array and count the number of times a 'Yes' type vote occurs. I want this to loop through until the 'Yes' value appears 3 or more times in the array (send notification to the committee) or a vote of 'Discussion needed' is selected.

I have an idea of how to append the values to an array after the get items though I have not built it yet.

Has anyone had a similar scenario or ideas on how to accomplish this?

[Rhiassuring]

You could use Get Items, filter on Vote eq 'Yes', and then use the Filter Array action for each Nominee; Filter Array - look at the output from Get Items, filter on Employee eq 'Suzy', then length('Filter Array'). 

Then you can make a condition - if the output of that Length check is equal to 3 or more, then, email the committee. 

What I'm curious about is - is this all going to happen at once? Or are you re-counting for every vote that comes in? Is this an annual voting kind of thing?

[cbohlman]

Hi there,

The way I have this set up, is that each nomination is an item on the SharePoint list, and that item has a column for each committee member to assign their vote to that nomination. There are a total of 9 different 'Vote' columns, and any combination of 3 yes's need to trigger the notification of approval.

This actually being added to an existing flow that populates the list with the nomination from a Microsoft Forms. I plan to put the 'Check for Yes's' in a Do Until loop so it can cycle through and check the results of each committee member's vote as they may enter their votes at various times. So this is a repetitive process.

I am not sure I can filter the Get Item by the multiple 'Vote' columns...