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
Hi @Veblitz
Question
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