cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
dmxrob
Level: Power Up

Extracting data from Office365 email

Is there a connector out there that will help me extract data from an email?  I only need certain fields, etc., not the entire body of the message.

 

Robert

 

1 REPLY 1
Community Support Team
Community Support Team

Re: Extracting data from Office365 email

Hi @ dmxrob,

 

Could you please share a bit more details about the email that you would receive?

What is the “certain fields” that you mentioned and want to extract from the body of the email?

Maybe you could use the connector “Data Operations” and workflow definition language to extract “certain fields” from the body of the email.

Please provide more information about your requirement so I could try to help you.

I have made a test on my side, the screenshot of the email’s body as below:

If I want to get the value of start time “20180101” and endtime “20180105” , I could create a flow as below:

1.png

  1. Add a trigger “When a new email arrives”.
  2. Add a Compose, choose the “Body dynamic” content of the trigger in the input field.
  3. Add a compose 2, the expression of the compose 2 as below:

         split(outputs('Compose'),'start time:')?[1]

     4.Add a compose 3, the expression of the compose 3 as below:

        split(outputs('Compose_2'),'</p>')

     5.Add a compose 4, rename the Compose 4 to “start time”, the expression of the “start time” as below:

        outputs('Compose_3')?[0]

     6.Add a compose 5, rename the Compose 5 to “end time”, the expression of the “end time” as below:

      split(outputs('Compose_3')?[1],'end time:')?[1]

 

When a new email arrives, the flow would run successfully as below:

 2.png3.png

 

Regards,
Alice Zhang

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020.

thirdimage

Flow Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Flow Community Video Gallery!

Users Online
Currently online: 337 members 5,319 guests
Please welcome our newest community members: