Power Automate flow that checks for duplicate in another list, expression result always false even though condition met

Question

I created a flow that when a new item is created in a list (List A) power automate checks to see if that item is already in another list (List B) and sends an email if the new item created already exists in List B - it is a duplicate. The expression always results in false though. I tested and changed the condition to 'does not equal' and it sends the email so I don't think it is an issue with a data mismatch, whitespace or case sensitivity. Not sure if the issue is with the filter array portion.

Answer 1

Hi Kay Wen Tee,

Based on your description, it seems like you have successfully created a Power Automate flow to check for duplicates between two lists (List A and List B). When a new item is added to List A, the flow checks if it already exists in List B and sends an email if it does. However, the expression always returns false, even when the condition is met. After your check, changing the condition to 'does not equal' works, so the issue might be with the filter array portion, and you want to get clear confirmation with that.

I'd like to provide more information for you but since our category is mainly focus on the general and build-in features queries of SharePoint Online, and your concern is related to build a Power Automate flow. Due to this situation, to help you get more dedicated support and we currently have specific channel for Power Automate. I sincerely suggest you can post the question in the related Power Automate community: Microsoft Power Platform Community Forum Thread. It is the specific channel handling this kind queries, members and experts are professional and will assist you to make a perfect approval workflow based on your environment and requirement.

Please accept my apologies for redirecting you to different community as the members in the category posted focus on the users with out of the box features and functions on SharePoint Online and have limited knowledge and support resources about making a workflow with Power Automate platform, so to get the fast and better assistance, we have redirected you in the correct path.

Appreciate for your patience and understanding.

Hope you having a nice day and wish you a brilliant year ahead as well😊.

Sincerely,

Mia | Microsoft Community Moderator

Answer 2

Thank you very much! I was not aware of this other form. Will post there :)