Trying to parse the end of a string in the subject line of an Outlook message

(0) Share

Report

Posted on by angelr107

I'm attempting to parse the name at the end of an email subject line, but I'm not sure how to the get the rest of a string after a given index. The string always reads "Your Ticket #20200908-0727-EU-387 has been assigned to <Assigned To Name>", where the <Assigned To Name> can be a different name each time a ticket is generated. I have something that works, that's not extremely dynamic, but it gets the job done.

substring(triggerOutputs()?['body/subject'], add(indexOf(triggerOutputs()?['body/subject'], 'to'), 3))

So I'm grabbing everything up to the 'to' string, and the 'add' function is adding three characters to the right which passes 'to' and the space to get to the beginning of the full name.I guess this can be considered an answer to my question, but I'm open to any ideas that may be a bit more dynamic. Thanks!

Categories:

Building flows

All responses (1)

Answers (1)

Verified answer

ScottShearer 25,331 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

@angelr107

Try usin the split() expression along with last() - see my example below: