web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / How to add dataverse f...
Finance | Project Operations, Human Resources, ...
Suggested answer

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

(0) ShareShare
ReportReport
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
I have the same question (0)
  • Suggested answer
    Charan Raju C R Profile Picture
    Charan Raju C R 3,155 Moderator on at
    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 Profile Picture
    Shaju Samuel 5 on at
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Private forums Quick links

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

more Community News

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Last month Overall leaderboard

Featured topics

Test Comment 26-09-2024 16:14pm

Product updates

Dynamics 365 release plans