cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sragot
New Member

Check if an email subject matches a SharePoint List items

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 !

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-litu-msft
Community Support
Community Support

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:

Screenshot 2020-09-17 150455.jpg

 

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.

View solution in original post

3 REPLIES 3
v-litu-msft
Community Support
Community Support

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:

Screenshot 2020-09-17 150455.jpg

 

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.

Well, this finally works !

 

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

 

Thank you !

@sragot how did you fix this?

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (3,185)