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.

Syntax

(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.