I need help with creating this flow. I am receiving data(multiple records) from a trigger and I need to look into AI table to see if the record already exists or not in AI Table. If not then create a new record otherwise do nothing. I am comparing two fields from the passed data but the looping operating on find records data is logically failing.
I need to create record once the step 5 (loop on existing records) finishes and there is no records found. This will involves having a track of record being passed but I am not sure how it can be implemented.
Hello @digi-cat1 , Welcome to the community ,
You may not need step 5 (loop for existing records). You can use the Exists condition from the router to check if step 4 returns any records.
Hi @kishanprmr,
Thanks for your response. The “Exists” condition is not working as expected. I am expecting this to work by checking the router condition value in existing records of table, however I believe it behaves if a value exists in the key which is passed as a condition parameter in router.
Please see image