Getting Started with Salesforce Flow – Part 11 (Count Number of records in a Record Collection Variable)

Getting Started with Salesforce Flow – Part 11 (Count Number of records in a Record Collection Variable)

Last Updated on December 19, 2020 by Rakesh Gupta

Salesforce Flow allows us to automate business processes by building applications, known as FlowsUsing Flows, a user can collect information; or, they can update, edit, or create records in Salesforce. Furthermore, Flows can execute logic, interact with the Salesforce database, call Apex classes, Platform Events, and guide users through various screens to streamline the process of collecting and updating data

Once a Flow is built, an Admin can make the Flow available to the right users or systems.

If you have a basic understanding of Apex then, you can write a query to get records and count the list size. For example, using Apex, one can get all Contacts that belong to city Alpharetta and, count list size, by writing the following code:

List<Contact> myContact = new List<Contact>();
myContact = [Select id, Email from contact where Mailingcity ='Alpharetta'];
system.debug('Size of List'+myContact.size());

Now suppose you wonder, can I achieve the aforementioned outcome by using Flow? Well, you are in luck! For, before the recent release, it was very complex to count the records in a Record Collection Variable (Kind of equivalent to Apex list). 

Count Records in a List

But, since Spring’18 release, a user can use an Assignment element to count the Record Collection Variable size and store that number in a variable without using the Loop element! 

Business Use Case

Edward Backhouse is working as a System administrator at GurukulOnCloudHe received a requirement to count Contact records where Mailing city equals Alpharetta. The new feature of Flow to rescue! 

The solution for the above business requirement

There are a few possible solutions for the above business scenario. One of them, of course, is to continue to use the old method, as shown in the preceding screenshot

But, Edward is a Salesforce Ninja-like us! And, therefore, he is always on the lookout for feature enhancements. As a result, Edward knows that, after Summer’18, he can solve the above requirement efficientlySo, instead of resorting to the old method, he takes following the steps:

  1. Edward navigates to Setup (Gear Icon) | Setup | Process Automation | Flows in Lightning Experience.
  2. Then he clicks on the New Flow button – which, in turn, opens the Flow canvas.
  3. Edward creates a Variable (to store record count) as shown in the following screenshot:
  4. The next step is to use the Get Records element to get all contact records where MailingCIty is Alpharetta. Edward clicks on the Palette tab and drag and drops the Get Records element onto the canvas; this opens a new window. Next, he maps the Record Create element according to the following screenshot:
  5. The next step is to use an Assignment element to count the record in a Record Collection Variable. Edward clicks on the Palette tab and drag and drops the Assignment element onto the canvas; this opens a new window. Next, he maps the Record Create element according to the following screenshot:
  6. In the end, Edward’s Flow will look like the following screenshot:
  7. Basking in his success, Edward Saves the Flow (Type: – Screen Flow) and named it Record Counts in SOCFinally, he and closed the canvas.
  8. As soon as he runs the Flow, voila! He gets the count of Contact records where Mailing City equals Alpharetta! 

 

You too can follow Edward’s footsteps literally and figuratively! Just like Edward, keep an eye out for feature enhancements – such as the one we just discussed above. Don’t want to miss out on any enhancement? Then, visit https://automationchampion.com/ often to keep yourself abreast of any and all developments!

But for now, go ahead! Show off your newly acquired skills to your friends, colleagues, and families!

Please feel free to add constructive comments, insights – and yes, challenges too! – to the blog. Good Luck in your Journey towards becoming a Salesforce Ninja!

Have feedback, suggestions for posts, or need more information about Salesforce online training offered by me? Say hello, and leave a message!

6 thoughts on “Getting Started with Salesforce Flow – Part 11 (Count Number of records in a Record Collection Variable)

  1. This doesn’t account for records being deleted. If one of the contact records gets deleted the count wont update. How would you account for this?

  2. Great post Rakesh. Super helpful as always. Seriously, Salesforce should be paying you for the all the detailed documentation you have put out! With only Salesforce documentation, I literally never would have been able to accomplish what I needed.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.