Splitting email subject string

[Anonymous]

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!

[Anonymous · Accepted solution]

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.

[Anonymous]

Thanks so much - worked perfectly!!

[jslsmithyx]

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