Hi
I'm trying to log emails from certain domains to an Excel list. How can I specify the list of domains to watch for by using a table in an Excel file? i.e. if email is from [any of the domains in table 1] add the message to [table 2].
I've managed to do this, but need to 'hardcode' the domains into the flow. Can anyone tell me how I can read them from table 1?
thanks!
Hi @ineichenM
You can achieve this using a filter array action.
Get rows from your excel table, filter the result based on the domain of the incoming email, using a condition on the length of the filter array greater than 0 (i.e. filter returns a match) you either have a match -> yes or no match -> no branch.
So:
List Rows
Filter Result from above on Domain
Check if length(filterarray)> 0
Yes or No
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien
P.S. take a look at my new blog here and like & subscribe to my YouTube Channel thanks 😉
User | Count |
---|---|
88 | |
39 | |
23 | |
20 | |
16 |
User | Count |
---|---|
127 | |
49 | |
46 | |
27 | |
25 |