How to deal with the behavior of replacing hard-coded organization IDs in formulas when creating or refreshing a sandbox

To prevent the Organization ID replacement and correctly identify the Production environment, create a formula resource and use it in a Decision element. This method compares the last 13 characters of the ID.

1.In Flow Builder, click [New Resource] in the Toolbox.

2.For Resource Type, select [Formula] and enter an API Name.

3.For Data Type, select [Boolean].

4.In the [Formula] field, enter the following formula:

==

IF( RIGHT( $Organization.Id , 13)="DXXXXXXXXXXXX" , true, false)

==

Note: Replace "DXXXXXXXXXXXX" with the last 13 characters of your Production Organization ID (excluding the leading "00").

5.Click [Done].

6.In a Decision element, configure the outcome to check if the formula resource is {!$GlobalConstant.True}.

This setting allows the flow to correctly determine whether the environment it is currently running in is the production environment, and prevents values ​​from being accidentally changed when creating a Sandbox.