I created a customfield at the standardobject Contact (PID) and I created a new customobject Contract which have also a field with the name PID. The contract should connected to the contact in order to archieve this I compare the PID. A contact can have more than one contract.
If the contact already exist the contact should connect to the contract. If the contact does'nt exist the contact should be created and than connected to the contract.
For this case I created an autolunched flow which runs if a contract is created or updated. I tried often to upload the data to realize what is going wrong.
- I have two contracts which have been updated with the same ID - the flow created two new contacts (WRONG)
- I have two contracts one have been updated and one have been created with the same ID - the flow created just one new contract (CORRECT)
it is not easy to explain, if you need further information please just ask.