Answered

Splitting email subject string

(0) Share

Report

Posted on by Community Power Pla...

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

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Community Power Pla... on at

Like (2)

Report

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.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Thanks so much - worked perfectly!!

Was this reply helpful? Yes No
jslsmithyx 97 on at

Like (0)

Report

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

Was this reply helpful? Yes No