Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

Getting an email address out of planner body

(0) ShareShare
ReportReport
Posted on by

I'm fairly new to flow and wanted to extract an email address out of a planner tasks body. They body always looks the same. The very first row always looks like his:

 

Contact: something@whatever.com (can vary in length)

text text text

 

I would like to send out an email if the task is closed to the mail address in the first row. How could I achieve this?
This is what I've tried so far and it's not working at all:

substring(body('get_task_details')?['description'], 10,lastIndexOf(body('get_task_details')?['description'],))
 
But I can not quite wrap my head around it yet, it looks like this thus far:
 
I appreciate your help!
  • Re: Getting an email address out of planner body

    Thank you so much, you helped a ton!

  • Verified answer
    v-yamao-msft Profile Picture
    v-yamao-msft on at
    Re: Getting an email address out of planner body

    Hi @Anonymous ,

     

    Have you figured out a solution for this issue?

     

    Please take a try with the following code to see if it will work for you:

     

    substring(body('Get_task_details')?['description'],add(indexOf(body('Get_task_details')?['description'],'contact'),8),sub(lastIndexOf(body('Get_task_details')?['description'],'.com'),4))
    
    

     

    I have made a test and it is working fine.

    1.PNG

     

    Best regards,

    Mabel

     

  • Re: Getting an email address out of planner body

    @efialttes wrote:

    @Anonymous 

    If all email addresses ends with .com, you can use the following

    lastIndexOf(body('get_task_details')?['description'],'.com')

    Hope this helps



    Thank your for the response!

     

    This came back though because it tried to send the message to "22" instead of the mail address, I'm assuming because he's counting the characters before ".com"?

    {
    
    "status": 400,
    "message": "One or more recipients are invalid.\r\nclientRequestId: 5a8df2c4-07b3-4acc-b634-00a0cd9906c3\r\nserviceRequestId: 67781085-ed45-44af-9e8d-ac2b29f1fc40",
    "source": "office365-we.azconn-we.p.azurewebsites.net"
    }

     

     

    Edit: Oh sorry, I get it now > will try tomorrow and report back

  • efialttes Profile Picture
    efialttes 14,756 on at
    Re: Getting an email address out of planner body

    Hi again

    As an alternative approach, you can use replace() and indexof() instead

     

    Step #1: replace 'Contact: ' (including the space separator) by '' (empty)

    Step #2: use indexof() to find the first space (' ')

    Step#3: use substring to extract the email address, starting from 0, taking the result from indexof() as the target length.

     

    Hope this helps

     

     

  • efialttes Profile Picture
    efialttes 14,756 on at
    Re: Getting an email address out of planner body

    @Anonymous 

    If all email addresses ends with .com, you can use the following

    lastIndexOf(body('get_task_details')?['description'],'.com')

    Hope this helps

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

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,567

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,907

Leaderboard