Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

predefined subject matches sharepoint list

(1) ShareShare
ReportReport
Posted on by 2,185

I have a list subject and it has Title column

Subject list:

Title

New

Renew

Amend

 

when  a new email arrives it should check if subject of email matches this subject list predefined values so please help me as its dynamic so we have created sharepoint list 

 

  • Verified answer
    FLMike Profile Picture
    FLMike 31,580 on at
    Re: predefined subject matches sharepoint list

    Hi @Veblitz 

     

    Question

    • Will the Subject match in length, capitalization etc?

     

    Its pretty simple really though

    1. Add your trigger to receive email

    2. Add a GetItems SharePoint Action

    3. Add a Condition

    In the left do length()

    inside the () put the Dynamic Property for the value/body from GetItems

    middle put is greater than

    right put 0

     

    This way it only processes if at least 1 row is in your list.

     

    In the Yes side

    1. Put an Apply to each

    In the from/input put the body/value dynamic property from the Get items

     

    Inside the Apply to each

    Add a condition

     

    I would suggest on the left do 

    toLower(item()?['Title']) 

    middle equals

    right

    toLower(Add the Dynamic property for Subject here)

     

    In the Yes side

    You didnt say what you wanted to do with it so I have no idea what you would put here.

     


    If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

    Cheers

    Thank You
    Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
    https://gernaeysoftware.com
    LinkedIn: https://www.linkedin.com/in/michaelgernaey

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,666

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,996

Leaderboard