cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Jesus_P
Frequent Visitor

Data from outlook body to excel

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

 

 

2 REPLIES 2
Jcook
Super User III
Super User III

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

Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips,
tricks, and guides
FlowAltDelete





Jesus_P
Frequent Visitor

Thanks for your answer @Jcook 

 

The email that I get daily looks like this:

email.jpg

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

Table.jpg

 

I have tried this flow:

flow.jpg

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

 

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Solution Authors
Users online (2,285)