web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Filtering a list base ...
Power Automate
Unanswered

Filtering a list base on values contained in an email

(0) ShareShare
ReportReport
Posted on by 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 
       

Categories:
I have the same question (0)
  • Verified answer
    Expiscornovus Profile Picture
    33,175 Most Valuable Professional on at
    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"
     }
    ]

     

    branch_mapping.png

  • ezFlow Profile Picture
    100 on at
    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?

  • Verified answer
    Expiscornovus Profile Picture
    33,175 Most Valuable Professional on at
    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.

     

    getlist_filterarray.png

     

     

  • ezFlow Profile Picture
    100 on at
    Re: Filtering a list base on values contained in an email

    Test and it worked 🙂
    Thanks

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 462 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 456 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard