Help to create flow read body mail

[AndreGar]

Hi,

I woud like create a flow to read on the body mail. 

Example body mail : 

Hello,
To 23/10/2019 morning :
- Delete ofTest1Client planning1

- Add of Test2Client planning2

To 24/10/2019 morning :

- Add of Test3Client planning3

To 24/10/2019 afternoon :

- Add of Test3Client planning3

Best regards

I read this example https://powerusers.microsoft.com/t5/Building-Flows/Read-email-content-from-body-of-the-email-extract... but is not very appropriate on my configuration. 

In my example I have 4 rows. i would like Add Event or Delte event in my outlook calendar. Example : 

- I Delete to the 23/10/2019 morning (8am to 12am) the event Test1Client planning1 and I add Test2Client planning2

- I add to the 24/10/2019 morning Test3Client planning3

- I add to the 24/10/2019 afternoon (2pm to 6pm) Test3Client planning3

I think create 2 flow step  : 

- one for the morning

- one  for the afternoon

But I do not see how to achieve it. Please help me 🙂

[v-bacao-msft]

Hi @AndreGar ,

If the Email body is in this format, there seems to be no suitable way to extract the data and there is no suitable split point.

The format of the email body mentioned in these threads below may be worthy of reference:

https://powerusers.microsoft.com/t5/Building-Flows/Extracting-text-from-email/td-p/334919

https://powerusers.microsoft.com/t5/Building-Flows/Extract-text-from-body-of-an-email-and-create-new...

Best Regards,

[AndreGar · Accepted solution]

Hi @v-bacao-msft ,

Thanks for your response. 

You think it's possible to extract row by row in excel file ?

For example, I split :

To 23/10/2019 morning :

- Add CLIENT3 description

in 3 columns ? 

To | 23/10/2019 | morning :

-    | ADD            | CLIENT3 description

And in the second time I reorganize the table to :

Date From | Date To | Action | Description

It's possible ? 

Thanks

[v-bacao-msft]

Hi @AndreGar ,

You need to create a Table in Excel, and then create a few fields to event info.

Action: add/delete

EventTitle

Start Time

End Time

Then use the features contained in the Excel Online connector to achieve your needs.

Best Regards,