Unanswered

Extracting and splitting Email Subject

(0) Share

Report

Posted on by Cgasedward

Hi, I am receiving emails with the Subject containing: name, address, subject and reference all split by an - and the reference is encased in []. I need to split this into separate cells within excel when running the flow. The body of the email also contains the persons email address, but I need flows to be able to pick up where this is and put this in excel. Also look for a phone number if there is one and enter that into excel.

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

MaleselaR 83 on at

Like (0)

Report
Copy link

Link copied!

Hi @Cgasedward,

If the structure of the subject doesn't change you could use the split function to separate the different fields from the subject variable generated by the trigger (When new email arrives). To extract email addresses and phone numbers from the message body I would recommend using a regular expression activity.

I hope this gives some direction

Was this reply helpful? Yes No
Cgasedward 4 on at

Like (0)

Report
Copy link

Link copied!

Thank you MaleselaR, I will give it a go. I am very new to Power Automate, so it might take me a little while.

Was this reply helpful? Yes No
tom_riha 10,187 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hello @Cgasedward ,

there're three expressions you could use to extract the information, slice(...), substring(...) and split(...), I believe this article might help you with the task.

Was this reply helpful? Yes No
Cgasedward 4 on at

Like (0)

Report
Copy link

Link copied!

Thank you so much. I will look into that this evening.

Was this reply helpful? Yes No