Hello everyone,
Whenever a record is added to my SQL table, I verify whether a record with the same publication date already exists in my publication table in Dataverse. If no such record exists, I create a new entry in this Dataverse table.
The challenge arises when I add multiple records (e.g., 20) to the SQL table simultaneously. This triggers my flow 20 times, and despite the publication date being the same in all 20 records, multiple records (e.g., 4) are created in Dataverse when it should only be one.
Due to simultaneous triggering, I assume there is a lack of awareness that a record is being created through another flow. Is there a way to address this issue?
Thanks!
