I am trying to create a CRM Dynamics case when receiving an e-mail to a specific address. To create the case, I need to add a customer.
To prevent redundancy I want to check if the customer already exists in the CRM accounts list. So I receive this list in my flow and want to compare this with the email sender, but it goes wrong here. I cannot immediately check if the customer exists because this will create an apply to each inside a condition and this is not possible so far.
I tried to filter the accounts list immediately, this works, but Flow recognizes the 1 item output still as an array. I even tried to export the list to a temporary (Excel) database and loop again through that list to give a related field (customer id) back but this also is not possible.
So my question is: does anyone know if there is a possibility to achieve this comparison?
Hi Glenn9138,
Currently, it seems that checking if a customer already exists in the CRM accounts list is not supported, as flow is being improved, you could submit an idea at “Flow Ideas” about this issue.
The link of “Flow Ideas” is:
https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas
Best regards,
Mabel Mao
Michael E. Gernaey
497
Super User 2025 Season 2
David_MA
436
Super User 2025 Season 2
Riyaz_riz11
244
Super User 2025 Season 2