web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : 8gLSNfstnJyUM9h+VEtxrd
Power Platform Community / Forums / Power Automate - General Discussion / Power Automate express...
Power Automate - General Discussion
Answered

Power Automate expressions - LEFT RIGHT

Like (0) ShareShare
ReportReport
Posted on 16 Sep 2020 09:48:50 by SheilaMullane 7

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!

I have the same question (0)
  • SheilaMullane Profile Picture
    SheilaMullane 7 on 16 Sep 2020 at 10:03:42
    Re: Power Automate expressions - LEFT RIGHT

    Hi Jay,

     

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

  • Verified answer
    Jay-Encodian Profile Picture
    Jay-Encodian 2,920 on 16 Sep 2020 at 09:52:07
    Re: Power Automate expressions - LEFT RIGHT

    Hi @SheilaMullane 

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

    1.jpg

     Output

    2.jpg

    Kind regards

    Jay

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Tom Macfarlan – Community Spotlight

We are honored to recognize Tom Macfarlan as our Community Spotlight for October…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 626 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 374 Moderator

#3
Expiscornovus Profile Picture

Expiscornovus 284 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Survey: Power Automate mobile app
How to Ask for Help with Your Power Automate Workflow

Product updates

Microsoft Power Platform Community release plans