Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Building Flows / Filter incoming emails...
Power Automate - Building Flows
Unanswered

Filter incoming emails for specific text and attachments

(0) ShareShare
ReportReport
Posted on by wherdzik

Hello great community!

I am trying to figure out how to build a flow that would automatically save signed contracts to SharePoint.  The trick would be to match the SharePoint row to the attachment.   The email comes in and it will say something like this...

 

"Dr. Smith has signed offer off employment...."

It can be varied but should say something to the effect that it has been signed.

 

The contract will be attached and it always contains the word signed.  So here is an example of a file name.

T. Smith MD Offer Letter 4.15.23 Revised signed

Is there a way to match the name of the name.  Lets say its Thomas Smith in the provider column in SharePoint list.  Or is this too difficult?

 

Thanks!

 

  • Nived_Nambiar Profile Picture
    Nived_Nambiar 17,895 Super User 2025 Season 1 on at
    Re: Filter incoming emails for specific text and attachments

    Hi @wherdzik 

     

    Ok 

     

    I would suggest the below logic

     

    First extract the name of person from attachment, (for this use split operation and then take the first 2 text values and join them both by space ) 

     

    Next filter the result from get items by converting the name column value to Format First name first character. lastname. like T. Smith and then compare with value obtained from step 1, use filter array for this operation

     

     

    Hope it helps !

     

  • wherdzik Profile Picture
    wherdzik on at
    Re: Filter incoming emails for specific text and attachments

    It appears that this is a trend. It seems to be Always First initial followed by a period and then last name.

  • Nived_Nambiar Profile Picture
    Nived_Nambiar 17,895 Super User 2025 Season 1 on at
    Re: Filter incoming emails for specific text and attachments

    Hi @wherdzik 

    Does the name in contract file always appears like T. Smith 

     

    Like first name is short followed by last name in full name format ?

     

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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans