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!
Solved! Go to 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
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
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.
User | Count |
---|---|
93 | |
46 | |
20 | |
20 | |
16 |
User | Count |
---|---|
135 | |
56 | |
44 | |
36 | |
26 |