Check if an email subject matches a SharePoint List items

(0) Share

Report

Posted on by 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 :

start the flow with the "When a new email arrives" trigger.
Get list items from SharePoint
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 !

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

v-litu-msft on at

Like (0)

Report

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.

Was this reply helpful? Yes No
sragot 4 on at

Like (0)

Report

Well, this finally works !

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

Thank you !

Was this reply helpful? Yes No
sudosaurus 1,599 Super User 2024 Season 1 on at

Like (0)

Report

@sragot how did you fix this?

Was this reply helpful? Yes No