Data from outlook body to excel

[Jesus_P]

Hi everyone!

I'm new with Power Automate and need help for my first flow.

I daily receive an email called "CO14-Update" with some data. As it is a database query it always have the same structure. For example like this:

E01;83483456  ;  10;MT;A;   *;2017118   ;Barcelona23   ;1X630/35

E01;83483457  ;  10;MT;A;   *;2017118   ;Barcelona04   ;1X630/35

E01;83483460  ;  10;MT;A;   *;2017345   ;Barcelona23   ;1X230/30

E01;83483473  ;  10;MT;A;   *;2000234   ;Barcelona01   ;1X140/35

I have an excel file in OneDrive where I copy-paste manually each day and then use Text to columns. I would like to have a flow that would do this automatically for me. The best I achieved is to copy just all the information in one cell...

Many thanks for your help!!

Jesús

[Jcook]

Hello,

Could you share a picture of your flow to help better understand what is going on.

Also exactly which data are you taking from the email to put in the excel file

Thanks

--Josh

If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others

[Jesus_P]

Thanks for your answer @Jcook 

The email that I get daily looks like this:

And I would like to store it in this excel table:

I have tried this flow:

What I get is just copy all the email's body in just one cell. Tried to use the email's body as a csv, but does not work. Any guess?

Jesús