Answered

Filtering a list base on values contained in an email

(0) Share

Report

Posted on by ezFlow

100

Hi Everyone,
We have a shared mailbox that gets notification from our vendors. If the subject line contain a certain value, I would like to pull the branch email, to fw them the email.
So for example, if the email subject contains the word "300", I would like to get the user2@domain and dw them the email.

I have a list "Branches"
Branch Branch email
100 user1@domain.com
300 user2@domain.com
560 user3@domain.com

I have the same question (0)

All responses (4)

Answers (2)

Verified answer

Expiscornovus 32,914 Most Valuable Professional on at

Like (1)

Report
Re: Filtering a list base on values contained in an email

Hi @ezFlow,

I would use an array for this mapping and filter that based on the subject field. In a condition you could check if it has found a match. If that is the case you could forward the e-mail to the correct branch e-mail.

Below is an example of that approach.

[ { "Branch": "100", "Branch e-mail": "user1@domain.com" }, { "Branch": "300", "Branch e-mail": "user2@domain.com" }, { "Branch": "560", "Branch e-mail": "user3@domain.com" } ]

Was this reply helpful? Yes No
ezFlow 100 on at

Like (0)

Report

Re: Filtering a list base on values contained in an email

Thanks
How can I make the variable dynamic as it can be any other value in the list?

Was this reply helpful? Yes No
Verified answer

Expiscornovus 32,914 Most Valuable Professional on at

Like (1)

Report

Re: Filtering a list base on values contained in an email

Hi @ezFlow,

Apologies, I missed the part where you said you already had a list. My bad.

Yes, you can use the same approach with a list. Just use a get items and use the value in the From field of the Filter array action.

Was this reply helpful? Yes No
ezFlow 100 on at

Like (1)

Report

Re: Filtering a list base on values contained in an email

Test and it worked 🙂
Thanks

Was this reply helpful? Yes No