Skip to content

Account Record Match Flow

Note

This flow is self-documenting and should be viewed within Salesforce (Setup -> Process Automations -> Flows). This document is to support working through a visual flow. Please Note: The flow commentary is produced using AI.

Overview

  • Flow Name: MoveData_Donation_Account_Duplicate
  • Label: [MoveData] Donation: Account - Record Match
  • Type: Auto-Launched Flow Template
  • API Version: 60.0
  • Status: Active

This flow performs duplicate detection for account records by using platform keys to identify existing account in Salesforce, enabling proper record matching and preventing duplicate creation.

If there is no match, MoveData will execute the Salesforce Duplicate Detection rules after the flow (if configured).

Purpose

The flow provides duplicate detection capabilities that:

  • Uses generated platform keys to look up existing account records
  • Checks the movedata__Account_Platform_Key__c.movedata__Platform_Key__c field for matches
  • Returns Salesforce Record IDs when existing records are found
  • Supports both Salesforce Key and Platform Key lookup strategies

Salesforce Fields

This flow interacts with the Account Platform Key custom object and its related fields. Below is a mapping of all fields utilized:

Field API Name Field Type Purpose in Flow
movedata__Platform_Key__c Text Stores external platform identifier for matching

Input Variables

Variable Type Required Description
SalesforceKey String No Existing Salesforce Record ID (if known)
PlatformKey String Yes Generated platform key for lookup matching

Output Variables

Variable Type Description
Result String Salesforce Record ID of matching account (if found)

Flow Logic

1. Salesforce Key Priority Check

The flow first determines the lookup strategy:

  • If SalesforceKey is provided: Returns the existing Salesforce Key immediately
  • If SalesforceKey is null: Proceeds to platform key lookup

2. Platform Key Validation

The flow checks if a platform key is available:

  • If PlatformKey is provided: Proceeds to platform key lookup
  • If PlatformKey is null: Flow terminates without returning a match

3. Platform Key Lookup

When a platform key exists, the flow performs platform key matching:

  • Uses movedata__PlatformKeyLookupComponent Apex action
  • Searches Contact records by movedata__Account_Platform_Key__c.movedata__Platform_Key__c field
  • Returns the matching Salesforce Record ID if found

Lookup Strategy

The duplicate detection follows this hierarchy:

  1. Direct Salesforce Key: If provided, use immediately (highest priority)
  2. Platform Key Lookup: Search existing records using platform key matching
  3. No Match: Returns null if no duplicate found
  4. Salesforce Duplicate Rules: MoveData will execute the Salesforce Duplicate Detection rules after the flow (if configured)

Dependencies

  • movedata__PlatformKeyLookupComponent (Apex action)