Master complex automation scenarios with these proven Flow patterns. Includes downloadable templates, troubleshooting tips, and best practices for building scalable, maintainable automations.
Download our collection of 25+ production-ready Flow templates with detailed documentation and setup instructions.
Download TemplatesFlow Builder has evolved into Salesforce's most powerful automation tool, capable of handling complex business logic that previously required custom code. However, building efficient, maintainable flows requires understanding advanced patterns and best practices.
This guide covers 10 essential automation patterns that every Salesforce admin should master, complete with real-world examples, implementation tips, and common pitfalls to avoid.
"The best flows are designed for future maintenance. Use clear naming conventions, add descriptions to every element, and design for scalability from day one." - Salesforce MVP
Create related records only when specific criteria are met
Create case records automatically when opportunity amount exceeds $50K
Use bulkification-friendly patterns for large data volumes
Update multiple related objects in a single transaction
When account is marked inactive, update all related contacts and opportunities
Implement proper error handling and rollback procedures
Send personalized emails based on record data and user preferences
Send custom welcome emails based on customer industry and size
Store email templates as Custom Metadata for easy maintenance
Handle complex approval routing and post-approval actions
Route discount approvals based on amount, territory, and user role
Design for approval recalls and reassignments
Call external APIs and handle responses within Flow
Validate addresses using external API and update records accordingly
Implement timeout handling and retry logic for API failures
Process large datasets in scheduled batches
Daily calculation of account health scores based on activity metrics
Use SOQL limits efficiently and implement proper chunking
Perform complex calculations when records change
Calculate opportunity probability based on stage, amount, and historical data
Cache lookup values to avoid hitting SOQL limits
Generate reports spanning multiple objects with custom logic
Create monthly sales summary reports with territory roll-ups
Consider using Platform Events for real-time reporting updates
Automate user interface behaviors and guided processes
Guide users through lead qualification with dynamic form sections
Design mobile-friendly interfaces and provide clear navigation
Implement complex data validation and cleansing rules
Standardize address formats and validate against external databases
Provide clear error messages and suggested corrections
Design flows to handle multiple records efficiently in single transaction
Impact: 10x performance improvement for bulk operations
Consolidate Get Records elements and use Collection operations for filtering
Impact: Avoid governor limit issues and improve execution speed
Configure Get Records with specific field requirements and filters
Impact: Reduce memory usage and improve query performance
Add Fault paths and provide meaningful error messages
Impact: Better user experience and easier debugging
Cause: Attempting to create records with duplicate unique field values
Add Get Records element to check for existing records before creation
Implement duplicate checking logic using Collection Filter
Cause: Multiple processes trying to update the same record simultaneously
Implement record locking strategy and retry logic
Design flows to minimize concurrent updates on same records
Cause: Flow exceeding the 100 SOQL query limit per transaction
Consolidate queries and use Collection operations for filtering
Plan query strategy and use bulkification patterns
Cause: Too many flow interviews running simultaneously
Implement queuing mechanism or process records in smaller batches
Use scheduled flows for bulk processing instead of record-triggered
Comprehensive testing is crucial for reliable flow automation:
Mastering Flow Builder is an ongoing journey. Start with simpler patterns and gradually work your way up to more complex scenarios. Each pattern you master expands your ability to solve business challenges through automation.
Remember that the most elegant solution is often the simplest one that meets the business requirement. Focus on building maintainable, documented flows that your future self (and colleagues) will thank you for.
Our technical architects can help you design and implement complex automation solutions. Get expert guidance on Flow best practices, performance optimization, and scalable architecture.
Schedule Technical Consultation