Flow Utility - DedupeStringCollection

-
Have you ever needed to deduplicate a String Collection in a Flow? You could use Loops, Decisions and Assignments to do this but it's not efficient and will fail if your Collection is too large. Instead, just pass this Flow Utility the String Collection you need to dedupe and it'll return a deduped version.

Check out FlowUtilities on Github


Comments

Post a Comment

Popular posts from this blog

Joins in SOQL

-
Image
If you are familiar with SQL, the biggest gotcha when writing SOQL is how joins are done. You'll see the term  Sub-Query  used instead of  JOIN  because of how queries are done on the Salesforce platform. You can still do joins; it's just done a little differently than you're used to. Sub-Query (Outer Join) In SQL, a join is when rows are selected from multiple tables and joined together on common columns. Thinking about your tables like a Venn Diagram is a great analogy for this. Let's say you want to query all Accounts and also include their related Opportunities. This is an example of an Outer Join because it selects all Accounts and will include their related Opportunities via the sub-query. If an Account does not have an Opportunity, it will still be returned here. An Outer Join is similar to selecting one whole circle in a Venn Diagram, including the area that overlaps with the other circle. Sub-Query (Inner Join) An inner join can seem a little m
Read more

SOQL from the Command Line

-
Image
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! Ju
Read more

Salesforce Lighting Migration: Plan for Success

-
Image
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 Experience Configure Lightning Experience Document all Salesforce processes Create training and support materials Lightning 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  e
Read more