Power Automate expressions - LEFT RIGHT

[SheilaMullane]

Hi All,

I'm trying to extract from Email Subject: Q3 FY20 Quarterly Lease Request due EOD Monday, June 8th.

I used this expression to extract Q3 FY20: substring(triggerBody()?['subject'],0,7)

But how do I extract the date at the end of the Email Subject? (anything after the comma).

Thanks!

[Jay-Encodian · Accepted solution]

Hi @SheilaMullane 

Try - substring(triggerOutputs()?['body/subject'],add(lastIndexOf(triggerOutputs()?['body/subject'],','),2))

 Output

Kind regards

Jay

[SheilaMullane]

Hi Jay,

thank you for the prompt reply! it works now! appreciate it!