How can I not create duplicates with my flow? I want to create records from List A into List B IF they don't already exist in B, if they already exit, DO NOT create them, as it is creating duplicates.
I've added the condition to check if item exists and then if it exists do not write:
However this does not work and does not create any records even if the list is empty.
Center eq 1463 and (AutomationType eq 'Management Reporting' or AutomationType eq 'Testing') and Repeatable eq 'Yes'.
all these values are from list A.
Any help would be appreciated.