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

Power Platform Online Conference

Speakers, submit your sessions now! Call for speakers ends Feb. 10!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

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

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

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 Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (5,345)