Power Platform Community Forum Thread Details

Hi everyone,

I have created a flow to import Outlook data to Excel. However, i have trouble to get the details that i want in email body. The details as per image below. I want to get details of account_type; first_name; last_name; clinic_or_business; and so on..

I use this function

first(skip(split(first(split(body('Html_to_text'),'account_type')),'= '),1). is there any function that i can use it?

but what happen is it cannot capture the details that user input. as per picture below.

Im looking for the user details input to be capture in excel.

Thank you.

Categories:

General topics

Hi @FM1995 ,

use trigger "When a new email arrives (V3)", select folder Inbox
then action: "Html to text" and add input "Body from the trigger".

compose actions "Compose_Account_Type"
first(skip(split(first(split(outputs('Html_to_text'), 'account_type')), '= '), 1))

compose "Compose_First_Name"
first(skip(split(first(split(outputs('Html_to_text'), 'first_name')), '= '), 1))

compose "Compose_Last_Name"
first(skip(split(first(split(outputs('Html_to_text'), 'last_name')), '= '), 1))

compose "Compose_Clinic_or_Business"
first(skip(split(first(split(outputs('Html_to_text'), 'clinic_or_business')), '= '), 1))

then add row in excel using action "Add a row into a table"

and in columns use:

Account Type- outputs('Compose_Account_Type')
First Name- outputs('Compose_First_Name')
Last Name- outputs('Compose_Last_Name')
Clinic or Business- outputs('Compose_Clinic_or_Business')

Mark as solution if it helps.

Thanks,

Sandeep Mishra