E-mail autoreply

[MAPA_James]

I'm trying to make a Flow that automatically sends an auto-reply to every mail that is sent to it. It works like a charm but there are some e-mail addresses and domain names that I'd like to exclude from it. Speaking in numbers, I need about 70-80 exclusions...

About two weeks ago I added those in the form of an 'OR'-expression but some days later I got the warning that those can only be boolean values and not strings (which is weird to me because upon trying it this way the first couple of days, I didn't get any errors and it worked perfectly).

Now I'm wondering how to add these exclusions since adding a condition limits me to 10 values and I can't just add up to 7 or 8, later maybe 9 or more of these conditions.

My current flow looks like this:

The first line in the condition is checking domain names, the second one is for full e-mail addresses.

Someone else advised me the following: 'create an array of exclusions and organize a loop' but that all sounds a bit abstract to me, if you could maybe help me with that or show an example it may help me as well.

Thanks in advance and hopefully we can find a solution together as soon as possible!

[manuelstgomes · Accepted solution]

Hi @MAPA_James 

I think there's a more straightforward way. You can create a simple list with the exclusions and then do a SharePoint "Get items" with an OData query "Title eq 'gmail.com'". After that, you can have a condition that checks the return and counts the values. If it's more than one, then the domain is on your exclusion list; if not, you can send the email.

Makes sense? If something is not clear please let me know, and we'll try to figure this out together.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

[MAPA_James]

Hi Manuel

Thanks a lot for your answer! 

It sounds a bit abstract to me though, I'm not as skilled in Power Automate.

Could you maybe show an example of it?

I managed to create and OData query but now I'm uncertain as of how to link it to a condition.