Skip to main content

Flow Loop Basics

Have you ever been stumped by those weird "Fast Lookup" things? Or do loops and collection variables have you puzzled? This post hopes to explain those concepts while covering some of the basics of using a loop in a flow.

I'm going to cover the basics of using a loop in a flow. To save you the time, here's a link to install the config I'll be using if you'd like to follow along: Basic Flow Loop Config

When you feel good about this, learn how to launch the flow from Process Builder or a Visualforce page in my next post: Launch a Flow From Process Builder or Visualforce.

Highlights from the video

Variable Naming Convention

Make one that works for you, but this is what I use.
Variable: v_{name}
Collection Variable: vColl_{name}
SObject Variable: so_{name}
SObject Collection Variable: soColl_{name}
*{name} is the name of the variable

Variable Input/Output Type

Private: Only accessible within the flow. The value cannot be set by something outside of it (Process Builder, another Flow, a Visualforce Page, etc.)
Input Only: Private + its value can be set by something outside of it. Its value cannot be passed to anything else (ie. You *cannot* pass this variable to another Flow and use it there)
Output Only: Private + its value can be passed to something else (ie. You *can* pass this variable to another Flow and use it there)
Input/Output: Private + Input + Output. I use this just about every time


  1. HI Brett. Nice Blog thanks. I'm new to flow and want to create some forms. For example, when a person is attending 4 weeks of on-the-job-training, the trainer needs to review his/her performance every day to 5 sets of criteria. Each criteria could hace a score of 1-5 via radio buttons and, at the end of the week and at the end of the course, simply aggregate the scores to give an overall performance profile. So, I was thinking of creating a custom object, Performance Record and via flow, update the record as and when. Maybe even use the new Guided Actions feature to help collecting this. Is Process Builder & Flow the way to go? How can I get help on this? I also want to become more proficient on the entire flow and SOQL thing so, other than Trailhead what help can I get?

    1. From the info you gave I would suggest going the custom object route you described but make sure it is a child in a master-detail relationship to the parent object. With this relationship you can use a rollup summary field to aggregate the scores.

      Trailhead and other blogs are great resources to use in learning flow. I have a few other posts on it but they are pretty specific. I'd recommend looking for resources that cover the topic more generally and applying those to what you're working on


Post a Comment

Popular posts from this blog

Salesforce Lighting Migration: Plan for Success

In April 2018, I led the Salesforce Lightning Migration at Postmates. This is how I would do it over again if I could.

Define Goals The goals of a Lightning Migration are: Enable Lightning ExperienceConfigure Lightning ExperienceDocument all Salesforce processesCreate training and support materialsLightning Experience is adopted Easy enough right? Let's go though the plan to see how we accomplish each one. Enable Lightning Experience Just turn it on right? Well, kinda.
Although it may be controversial, I recommend turning it on and hiding the option from all users. This can be done by removing the Lightning Experience User permission from your custom profiles. 
And yes, turn it on in production
Why? You're going to turn it on anyway. Salesforce has declared this as the path forward, so you either turn it on now or wait until they flip the switch for you.
Plus, turning this on ahead of time will make deploying from a sandbox much easier. Trust me.
Goal #1 Enable Lightning Exp…

SOQL from the Command Line

SOQL and the Command Line go together better than peanut butter and jelly. Here's why.
Once upon a time, I got tired of running Salesforce Reports to get miscellaneous data. I found Workbench and started using their interface to run SOQL queries. This was great for a while, but I knew there was a better way.

Pro-tip with Workbench: If you set a browser bookmark after your query runs, you can return to that bookmark and it will re-run your query!

Enter the SFDX Command Line Interface (CLI). Get ready to take your productivity into hyperdrive! 🚀🚀🚀
sfdx force:data:soql:query If there's one command you learn, this is the one. All you have to do is pass a query string into the -q parameter and you're in business. Check it out:
-r | --resultformat This is my 2nd favorite thing. How often do you need to export a csv from Salesforce? And how annoying is it to make throwaway Salesforce reports each time? Yeah, it's the worst.
-r to the rescue! Just add "-r csv" to …

Why should I use SOQL?

You need data, fast!
Whether it's exporting a csv or answering a question, SOQL can get you the result much faster than creating a Salesforce report.

My top 3 reasons to use SOQL are:
Get data fastGet answers fastFlexible access Get Data Fast How often do you find yourself making a throwaway report to check what is happening in the system? For example, you updated your Lead routing and want to see if it's been assigning Leads as you expect. Well you could make a report, run it and review the results. Or you could run a SOQL query.
The benefits of running a SOQL query in this case is that you can retrieve different data sets much quicker. In a Salesforce report, you are stuck with the Report Type you selected when creating the report. With SOQL, you can traverse object relationships in a much more natural way. Get Answers Fast Have you ever been in a meeting and someone asks a data question that no one has the answer to? Well SOQL comes in handy here because you can run a quick …