Answered

Check if Records are Duplicated in existing table / Dataverse and Delete / Duplicate Rows

(0) Share

Report

Posted on by BcooS

Hello community,

I want to build a flow that checks if the new item/record added into the dataverse table, its duplicated from an existing item already in the table. If so, then delete one of the records.

This is tricky because, in order to be considered as duplicate, the values of the fields needs to be exactly for some columns.

Example,

I have columns ID , Article Number, and PO, so if new item added has the same ID, Article number and PO, than an existing record with same ID Article number, and PO , then one of these two "lines" needs to be deleted.

I cannot use the Duplicate Detention Rules in Dynamics because condition must met that ID Article number and PO are the same. Three columns at the same time.
Detention rules as far as i understood are when one of the condition fields is met.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-xiaochen-msft on at

Like (1)

Report

Hi @BcooS ,

I made a sample for you.

Create a table in Dataverse with the following data.

Create the following flow, I will explain it step by step.

Add a trigger that fires when a new row is added.

List rows in the table where the ID, Article Number, and PO are equal to the new row.

crba2_id eq '@{triggerOutputs()?['body/crba2_id']}' and crba2_articlenumber eq '@{triggerOutputs()?['body/crba2_articlenumber']}' and crba2_po eq '@{triggerOutputs()?['body/crba2_po']}'

Set conditions to determine whether the number of filtered rows is greater than or equal to 2.

length(outputs('List_rows')?['body/value'])

If yes, delete new row.

Best Regards,

Wearsky

Was this reply helpful? Yes No
BcooS 9 on at

Like (0)

Report

Thank you !!!
It really worked ! I appreciate the quick response 🙂

Was this reply helpful? Yes No