Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to parse the incoming email subject (having multiple phrases) where each phrase needs to be inserted into different fields on sharepoint list

Resident Rockstar
Resident Rockstar

Hi @Anonymous 

If I am understanding correctly, are you saying that you want to update fields in a SharePoint list. Diferent fields get updated depending on the "phrase" in the message title?

"Email 1 Subject/Title" - Update Field 1

"Email 2 Subject/Title" - Update Field 2

"Email 3 Subject/Title" - Update Field 3

... and so on ...

If so, a good starting point for you may be to look at this blog -

Using the Try, Catch, Finally approach with the "Scope" connector will mean each Try (Scope) can check with a condition, if that fails, it will move on and check the next one and so on.

Here is what you would start out with: (You may want "Get Item" or "Get Items" to suit)Capture-198.png

Here would be your first TryCapture-199.png

Each Try that comes after would target a diferent subject/title until you've covered them all.

Worth a go?


If you have found my post helpful, please mark thumbs up.

If this post has solved your problem, please click "Accept as Solution".

Any other questions, just ask.

Thanks, Alan

Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!

Not applicable

Hi @AlanPs1,

Thanks for this but this won't suit for my requirement as the no. of combinations would be too many to match for each.

Instead if there's a way to parse the subject line using one or more delimiters, store each section identified as variable to be interested onto respective SP list, it'd be great.

Perhaps I am not able to find the right article as I am pretty sure this functionality would be available.



Helpful resources

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!


Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Users online (44,740)