FlowFest V4 Challenges - Challenge 2

FlowFest V4 Challenges - Challenge 2

FlowFest is a competition that lasts for 50 minutes and is held online, where participants compete to build flows. FlowFest V4, the fourth version of this event, was held on February 22nd, 2023, and was hosted by Salesforce Ben and Ohanaly, just like the previous events. This time, the competition had a different format where four finalists were chosen after completing the first three challenges, and they shared their screens for the final challenge. Let's take a look at the challenges of FlowFest V4. Here is the answer of FlowFest V4 - Challenge 2.

FlowFest V4 - Challenge 2 - Question

Universal Containers is approaching their fiscal year end and have asked their sales reps to follow up on any outstanding Opportunities. To ensure a good customer service experience remains their highest priority, we want to exclude any Accounts that have Open Cases. Once you have that list of Accounts, get all Open Opportunities for those accounts. Once you have that information, make sure to submit the values requested below.

Submission Variables:
NumberAnswer1= {!countOpenOpportunitiesNoCases}
NumberAnswer2= {!countOpenCases}

FlowFest V4 - Challenge 2 - Answer

1- Add a get records element to get all the open cases.

Get Open Cases

2- Add a loop element to loop through the open case records. Create a text collection variable and add an assignment element to prepare a text collection of account ids.

Add Case Ids to a Text Collection - FlowFest V4 - Challenge 2

3- txtAccCollection variable stores the ids of the accounts that have open cases. These are the accounts that you don't want. Add a get records element to find the open opportunities that are not related to those accounts. Use the not in operator for this purpose.

Get Open Opportunities - FlowFest V4 - Challenge 2

4- Create a number variable and add an assignment element to store the opportunity count.

Store the record counts

At the end, your flow should look like this. The last subflow submits your answers, it is not a part of the challenge.

FlowFest V4 - Challenge 2

Submission Variables:
NumberAnswer1= 36
NumberAnswer2= 65

FlowFest V4 Challenges

Here are the answers of all the FlowFest V4 challenges.

1st Challenge
2nd Challenge
3rd Challenge
4th Challenge


  1. I would like to suggest a correction regarding the decision element. I think there should be a decision element after the 'get cases' and 'get opportunity' step for null check. This will help us ensure that we have a valid product before proceeding further. What do you think about this suggestion?

3 Trackbacks / Pingbacks

  1. FlowFest V4 Challenges - Challenge 4 - Salesforce Time
  2. FlowFest V4 Challenges - Challenge 3 - Salesforce Time
  3. FlowFest V4 Challenges - Challenge 1 - Salesforce Time

Leave a Reply

Your email address will not be published.