I have an excel file containing a list of email domains that I’d like to use to filter through my emails to get emails sent only by those domains. I managed to convert the excel into a list variable but I’m not sure how to go about applying the list to the filter. All of the solutions I’ve seen are for small number of conditions (like 2 or 3) where they manually key in each address in the filter, but for larger numbers (like more than 10) doing that seems rather messy and troublesome to maintain if I have to add more to the list. Is there any way to use a list within a variable for filtering?
Place your get outlook activity inside a for each activity. and then parse
item.ToString inside the filter property.