Answered

Splitting email subject string

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

I'm a new Flow user and need to understand how to build a Flow to split/manipulate an email subject line which then populates a Sharepoint list. I have the "When new email arrives" and "Create item" connectors sorted, just need to understand how to split up an email subject line.

The standard subject line looks like:

xxxxxx xxxxxxxxxxx XXX0000/XXXXXXXXX/00000 XXXXXXXXX

Where x = letters and 0= numbers

The numbers in red are the ones that I want. They can vary between just 1 digit to up to 5 (or theoretically more)

Assuming I will need to use split but not sure how. In current attempts the flow runs but the no splitting results in the sharepoint list.

Any help appreciated!

Categories:

Building flows

All responses (3)

Answers (1)

Sort by

Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(2)

Report
Copy link

Link copied!

Combine different string and collection operations to extract the value from the email subject

function in set variable

first(skip(split(replace(triggerBody()?['Subject'],' ','/'),'/'),4))

function replaces the space in the subject with '/'.
splits the subject into array elements delimited by '/'.
deletes the first 4 elements from the array.
then takes the first element in the new array which is the number you are looking for.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks so much - worked perfectly!!
jslsmithyx 97 on at

Like
a
(0)

Report
Copy link

Link copied!

Really helpful thank you! I'll now be looking into extracting multiple words from an Emails Subject Field using this method 🙂