Check if an email subject matches a SharePoint List items

[sragot]

Hi everyone,

First, I'd like to say I'm not a pro developer, so go easy on me 🙂

What I'm trying to do is pretty much just check and archive emails based on their subject line. If it contains a matching case number in my SharePoint list, I save the email to a corresponding folder.

What I have tried so far is :

1. start the flow with the "When a new email arrives" trigger.
2. Get list items from SharePoint
3. Try to have an Apply to each loop to test if my subject line contains an items in the SharePoint list.

It seems easy enough, but I can't make it work. I'm having trouble with the step 3. I'm sure there is something very easy that I'm not doing properly (maybe finding a way to isolate the item title and comparing it with the email subject line).

Anyway, any help would be appreciated !

[v-litu-msft · Accepted solution]

Hi @sragot,

How does the case number in Subject line look like? Could you please share an instance of subject line?

This is an example to check Email Subject if contains title of an item of SharePoint:

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[sragot]

Well, this finally works !

It's the first thing I tried, but somehow I couldn't make it work...

Thank you !

[sudosaurus]

@sragot how did you fix this?