How to add filter in Dual-write

In today’s article, we will see how to add filter in Dual write when syncing data from FinOps to Dataverse and vice versa.

For Dataverse, we can use Odata filter expression using Dual-write but for FinOps, we have to use different techniques which can be later in this article.

Step 1: Go Data management > Dual-write and select your table map.

In this case, I am using worker entity.

Step 2: Click on filter button.

This will edit query dialog box and specify your filter in ( )

For example, you want to sync few workers to dataverse or only one then your condition should be below.


(your condition)

We can use below examples to filter expressions.

If you like this article, feel free to share it with others who might find it helpful! If you have any questions, feel free to reach out to me.

One thought on “How to add filter in Dual-write

Add yours

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Create a website or blog at

Up ↑

%d bloggers like this: