Create a Flow that Generates a FIELD_INTEGRITY_EXCEPTION Error

To solve this requirement, we will use the After-save Record-Triggered Flow. Check out this article to understand why we are using after-save record-triggered flow for this scenario. 

There are 3 steps to solve Tamara’s business requirement using After-Save Record-Triggered Flow. We must:

Step 1: Define Flow Properties

1. Click Setup.
2. In the Quick Find box, type Flows.
3. Select Flows then click on the New Flow.
4. Select the Record-Triggered Flowoption, click on Create and configure the flow as follows:
   1. Object: Case
   2. Trigger the Flow When: A record is created
   3. Set Entry Criteria
      1. Condition Requirements: None
   4. Optimize the Flow For Action and Related Records
5. Click Done.

Step 2: Using Decision Element to Check the Case Status 

Now, will use the Decision element to check if the case is closed or not. 

1. On Flow Designer, click on the+icon and select the Decision element.
2. Enter a name in the Label field; the API Name will auto-populate.
3. Under Outcome Details, enter the Label the API Name will auto-populate.
4. Condition Requirements to Execute Outcome: All Conditions Are Met (AND)
   1. Row 1:
      1. Resource:{!$Record.IsClosed}
      2. Operator: Is Null 
      3. Value: {!$GlobalConstant.True}
5. When to Execute Outcome: Only if the record that triggered the flow to run is updated to meet the condition requirements
6. Click Done.

Step 3: Add Action – Update Records 

 The next step is to update the owner of child cases, for this, we will use the Update Records element.

1. On Flow Designer, below the Closed node, click on the +icon and select the Update Records element.
2. Enter a name in the Label field; the API Name will auto-populate.
3. For How to Find Records to Update and Set Their Values select Specify conditions to identify records, and set fields individually
4. Object: Case
5. Select All Conditions Are Met (AND). 
6. Set Filter Conditions
   1. Row 1:
      1. Field: ParentId
      2. Operator: Equals
      3. Value: {!$Record.Id}
7. Set Field Values for the Opportunity Records
   1. Row 1:
      1. Field: OwnerId
      2. Value: {!$Record.AccountId}
8. Click Done.

Proof of Concept

1. Update a case record to closed, which has at least one child case.
2. Once you’re done, click on the Save button. Boooommmm, you encounter a FIELD_INTEGRITY_EXCEPTION error, as shown in the following screenshot:

👉  As mentioned earlier, the reason behind the error is, that we are wrongly updating Case record ownership to an accountId. 

Fix FIELD_INTEGRITY_EXCEPTION Error

To fix the FIELD_INTEGRITY_EXCEPTION error in a Flow, you have to pass the correct Id for a lookup field. let’s modify the flow to pass the right value to the OwnerId field. 

Step 1: Clone Existing Flow 

1. Click Setup.
2. In the Quick Find box, type Flows.
3. Select Flows then click on the Flow Name that will be modified. In this case Update Child Case Owner.
4. Click on the Save As button at the top right of the Flow builder.
5. Click Save.

Step 2: Modify Update Records Element 

Almost there! Once everything looks good, click the Activate button.  

Proof of Concept

1. Update a case record to closed, which has at least one child case.
2. Once you’re done, click on the Save button. 
3. Notice that, Child Cases owners are correctly updated by the Flow.