Extracting variables from excel list to use as elements of an 'OR' condition

[ineichenM]

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!  

[DamoBird365]

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 😉