Applies to Product - Microsoft Dataverse
What’s happening?
ImportAsHolding failed with exception: Error while importing Formula fields name [...].
What’s happening?
ImportAsHolding failed with exception: Error while importing Formula fields name [...].
Reason:
The error occurs when a datetime field is being used by another calculated field, and changing its behavior will corrupt the dependent field's formula.
The error occurs when a datetime field is being used by another calculated field, and changing its behavior will corrupt the dependent field's formula.
Resolution:
To resolve this, you need to apply the same changes first to its dependents or dependencies respectively. If you want to update the behavior of these fields, it is suggested to remove the dependencies of these fields from the target environment and try the solution import again. Alternatively, you can exclude these fields from the solution import. Additionally, ensure that the formula field is updated to something that does not impact the behavior of the field. Using "UTCNow()" is recommended as it is a timezone-independent function, while "Now" is a user-local function that can impact behavior.
To resolve this, you need to apply the same changes first to its dependents or dependencies respectively. If you want to update the behavior of these fields, it is suggested to remove the dependencies of these fields from the target environment and try the solution import again. Alternatively, you can exclude these fields from the solution import. Additionally, ensure that the formula field is updated to something that does not impact the behavior of the field. Using "UTCNow()" is recommended as it is a timezone-independent function, while "Now" is a user-local function that can impact behavior.