Unanswered

Apply to each results from condition

(0) Share

Report

Posted on by esang

Is there a way to count the amount of true/false results from a condition within an apply to each action?

Currently I only have a formula set to count the total items but I would like to be able to count how many resulted in true and how many resulted in false.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

creativeopinion 10,508 Moderator on at

Like (0)

Report
Copy link

Link copied!

You should use a Filter Array action instead if you are looking to count the number of true and false items. Can you upload a screenshot of how your flow currently looks?

Was this reply helpful? Yes No
JoseC12 390 on at

Like (0)

Report
Copy link

Link copied!

Hi @esang,
You can employ the 'Increment variable' action. Let me provide an example:
Initially, initialize two variables to determine whether each item is true or false.
Upon retrieving the items, such as checking whether an item is Active (1) or not, you can increment the 'countTrue' variable by 1 if it is true. Otherwise, if it's not active, increment the 'countFalse' variable by 1.
Finally, you can retrieve a message to check the final result.
Hope it helps,
Best regards!
Jose Donayre

Was this reply helpful? Yes No
creativeopinion 10,508 Moderator on at

Like (1)

Report
Copy link

Link copied!

@esang
Depending on how many items you need to loop through, it would be more efficient to use a Filter Array action. The Apply to Each + Condition actions will work as @JoseC12 indicated above. However it needs to loop through each item and run a check then increment the variable.

Instead I would recommend the Filter Array action that can filter out the true and false values and provide you with a count. These two actions can run parallel to each other.
Add Filter Array Action
Add a Filter Array action to check for each each condition.

Count Items Returned
Add a Compose action under each Filter Array action and use the length() function to count the number of items returned from the Filter Array action above.

The total flow run for my list of 24 items was about 1 second. This will vary based on the number of items you have in your list.

Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!

👉 Watch my tutorials on YouTube
👉 Tips and Tricks on TikTok

Was this reply helpful? Yes No