Extracting Dynamic Data from Received Email

Like (0) Share

Report

Posted on 8 Feb 2023 02:09:04 by Shaebert

107

Hello,

I want to take data received from an outlook email and send those to their corresponding fields in an excel spreadsheet.

I am skilled enough to be able to utilize the split function to extract the data. However, the order of the data can change, so I somehow need to be able to look up the field to make sure I am grabbing the correct data.

For example, after converting the email body from HTML to text, I end up with this:

First name:
M.
Last name:
Smith
Email:
msmith@gmail.com
Phone number:
444#######
Job title:
Sales Manager
Company name:
Google

Sometimes the email field could be last, or 2nd last. This is why I can't use a split function solely to extract the fields as the data output would be inconsistent with the fields/columns I am placing them in excel.

Any help would be appreciated!

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

v-bofeng-msft on 09 Feb 2023 at 05:31:58

Like (1)

Report
Re: Extracting Dynamic Data from Received Email

Hi @Shaebert ,

You could use this formula to get the email:

split(split(outputs('Compose'),concat('Email:',decodeUriComponent('%0A')))[1],decodeUriComponent('%0A'))[0]

Best Regards,

Bof

Was this reply helpful? Yes No