Power Platform Community Forum Thread Details

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

Categories:

General topics

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