How to add dataverse filter condition for a lookup field in dual-write?

(0) Share

Report

Posted on by Charan Raju C R

3,155 Moderator

Hi,

We need to synchronize data from Dynamics 365 CE to F&O using dual-write when a lookup field contains data. We have tried CE filter condition - LookupFieldName ne null, but getting below error while creating a record in CE.

    Exception Message: Object reference not set to an instance of an object.
    
    ErrorCode: -2147220891
    HexErrorCode: 0x80040265
    
    ErrorDetails: 
        OperationStatus: 0
        SubErrorCode: -2146233088
        Plugin: 
            ExceptionFromPluginExecute: Microsoft.Dynamics.Integrator.DualWriteFpRuntime.Plugins.PreCommitPlugin
            ExceptionRetriable: False
            ExceptionSource: PluginExecution
            OriginalException: PluginExecution
            PluginTrace: [INF] - [2022-02-10T06:17:12.794Z] - plugin [PreCommitPlugin] invoked with the message of [InternalPipeline] for target

How to add dataverse filter condition for a lookup field in D365 dual-write mapping?

Categories:

Other

All responses (2)

Answers (0)

Suggested answer

Charan Raju C R 3,155 Moderator on at

Like (0)

Report

RE: How to add dataverse filter condition for a lookup field in D365 dual-write?

Hi Shaju,

We couldn't find a right filter solution to check whether a lookup field has value or not but managed with a work around. Created a boolean field on the entity and this field will be set when the lookup field is set with non-blank value. Added a dataverse dual-write filter to sync to F&O only when this boolean field value is set (filter: booleanField eq true)
Shaju Samuel 5 on at

Like (0)

Report

RE: How to add dataverse filter condition for a lookup field in D365 dual-write?

Hi Charan,

did you manage to find the solution to your query. We too have a similar requirement but do not have a working solution as yet.

Thanks in advance

Sam