web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Split email subject an...

Power Automate

Unanswered

Split email subject and put into excel table?

(0) Share

Report

Report

Posted on by Bobby_John

8

How can I get specific text from an email subject to put into excel table?

For example, e-mail subject would be:

XXXL Order 555 to 10001 - Please Review

XXXL Order 9555 to 10025 - Please Review

i want to put into a table like below for every email that comes through like this

Order	Location
555555	10001
9555	10025

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

tom_riha 10,185 Most Valuable Professional on at

Like (0)

Report
Hello @Bobby_John ,

you can use the split(...) expression on the subject and split it by ' ' (space).

split(<email subject>, ' ')

then you can extract the specific parts using and index

split(<email subject>, ' ')[0] = XXXL split(<email subject>, ' ')[1] = Order split(<email subject>, ' ')[2] = 555 split(<email subject>, ' ')[3] = to split(<email subject>, ' ')[4] = 10001 etc.

Was this reply helpful? Yes No
Pocoloco 12 on at

Like (0)

Report

@tom_riha
Is that possible to show the flow please :-)?

Was this reply helpful? Yes No

Join the conversation