Dynamics 365. Trying to update two tables when a third table is updated, but I'm having trouble with duplicate detection.

[Balgaire2814]

So, I have way to get data into a staging table from SQL. This contains information that will end up in two different tables, Contacts, and a custom entity that is similar to a case entity (event). 

I have successfully created a flow that will update the contact table with a new contact, and the event table with the new event when a single row with all the data is added to the staging table. The problem is, that this does not seem to trigger the duplicate detection rules we have set up in dynamics to avoid duplicate contacts (last name and a customer ID) and and duplicate events (an event ID and customer last name).

Since the event is tied to the contact, I need to check and see if the contact exists. If so, skip to event creation. If not, create the contact with first name, last name, and customer ID.

Then I need to see if the event already exists. If not, create it linking it to the contact. If so, do nothing.

The Dataverse connectors have not been playing nicely with me, so I have been using the deprecated D365 connectors. Everything is working fine without duplicate detection.

I'm relatively new to PA and suggestions of how to move forward greatly appreciated.

[abm · Accepted solution]

Hi @Balgaire2814 

You could do the filtering check using the new Dataverse connector?  

Can't see what's stopping you to filtering like the above to make sure the record exists or not?

Thanks

[Balgaire2814]

Hi @abm , thanks for replying. This was helpful and I did figure out the Dataverse connector. Ultimately, I think this was a concurrency issue. Some flows further downstream were completing after the duplicate check of the original, and that's how the duplicates were getting through. I set concurrency to 1 things seem to be working now.