How do I check if Get Records returned no records in Flow?

Add a Decision element after Get Records with the condition {!Get_Records} Is Null True. For a record collection you can also use Is Empty True.

Should I use Is Null or Is Empty?

Is Null works for both single records and collections from Get Records. Is Empty is meant for collections. Is Blank is for text and other single values, not records.

What does assignNullValuesIfNoRecordsFound do?

It is the "When no records are returned, set specified variables to null" option for manually assigned variables. When false, the variables keep their old values if nothing is found, so a stale value can look like a found record.

Does a Loop fail if Get Records is empty?

No. A Loop over an empty collection simply doesn't run, but the elements after it still do, so check for empty results with a Decision first.

Can I count how many records Get Records returned?

Yes. Use an Assignment element with the Equals Count operator on the collection, then check the number in a Decision.

Salesforce Flow: Check if Get Records Is Empty

To check if Get Records is empty in Salesforce Flow, add a Decision element right after the Get Records element with the condition {!Get_Records} Is Null True. When Get Records finds nothing, its output is null, so this outcome catches the “no records” case before later elements try to use the data. For a collection, the newer Is Empty operator works too.

Below is a complete example, a record-triggered flow that emails an account’s contacts only when the account has contacts, plus the difference between Is Null, Is Empty and Is Blank, and what the old “Assign null values to the variables if no records are found” option does.

This Tutorial Covers: