Flow data pill resolved to null: expected value not available

The source record or trigger that initiated the flow does not contain a value in the field being referenced by the data pill. (high likelihood)

A previous action in the flow returned an empty result set or null value, causing downstream data pills to resolve to null. (high likelihood)

The data pill is referencing a field that exists in the table dictionary but is not populated for the specific record being processed. (medium likelihood)

The flow trigger conditions are not properly filtering records, allowing records with missing required field values to initiate the flow. (medium likelihood)

A lookup or query action is using incorrect filter conditions, returning no results when a value was expected. (low likelihood)

Step 1: Navigate to Process Automation > Flow Designer > Executions and locate the failed flow execution to identify which specific data pill resolved to null.

Step 2: Click on the execution record and review the execution details to see which action step generated the null data pill error.

Step 3: Examine the source record that triggered the flow by checking the trigger record details in the execution log to verify if the referenced field contains a value.

Step 4: If the source field is empty, modify the flow trigger conditions to exclude records where the required field is empty using condition like 'field is not empty'.

Step 5: For null values from previous actions, add condition checks before using the data pill by implementing If conditions that verify the data pill 'is not empty' before proceeding.

Step 6: Consider adding default values or alternative logic paths using Flow Designer's decision logic to handle cases where expected data is not available.

Step 7: Test the modified flow with sample records that both contain and lack the referenced field values to ensure proper handling of null scenarios.

Step 8: Enable flow debugging by setting the system property 'glide.flow.debug' to true temporarily to get more detailed execution information for complex troubleshooting.