@Anonymous you can do this with nested conditions and increment variables. In this example I've got a list of jobs and the position group that each one is in: Technical, Management or Marketing/Admin. The flow loops through each one, increments the variable for each group and then at the end sends me an email with the totals.
The SharePoint list with Yes/No columns:
I've manually triggered the flow but you could do it when a new is created or on a schedule. Next add one Initialize variable for each of your Yes/No columns, set it to Float and set the initial value to 0 or leave it blank:
Next, get the items from your SharePoint list:
Add an Apply to each control and select value from the dynamic content box. Next add a Condition to look at the first column, in this case Technical. In the If yes green channel and an Increment variable, select the variable and set the value to 1 - in other words for each item it finds where Technical is yes in the SharePoint column it will add 1 to the variable.
Next, in the red If No channel add another condition. In my case the second condition is Management, so in the green If yes channel add an Increment variable, select the appropriate variable and set the value to 1. As this example only has 3 yes/no columns we can now just add another Increment variable for the last variable.
Next, outside the apply to each, add 3 Compose controls and set the input for each to be one of the variables:
Finally, add a Send an email (V2) and select the outputs of the 3 Compose controls for the relevant lines of the email. YOu could of course save the totals to a SharePoint list or do some other action, but this is just a simple email which I haven't formatted:
And this is the result:
If you have more than 8 columns then a different solution would be needed, probably using a switch case. But have a go with this and come back with any questions.
Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.
