cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AndreGar
Regular Visitor

Help to create flow read body mail

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 🙂

1 ACCEPTED SOLUTION

Accepted Solutions

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

View solution in original post

3 REPLIES 3
v-bacao-msft
Community Support
Community Support

 

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,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

 

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,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (5,426)