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

Question add to Excel

Hello I am trying to create the following flow: I have an Excel sheet on OneDrive. At the same time I get a daily Excel table by mail. Now I want to insert the data from the daily Excel lists from Outlook into the Excel list on OneDrive, so that I have a master table with all data. Until now I have to copy and paste the data manually every day and I want to automate this task. Unfortunately I don't know how this works and need some help. Who can support me in creating this flow. Greetings, Simon

4 REPLIES 4
ChristianAbata
Community Champion
Community Champion

hi @BrunnerSi  you can follow this tutorial

https://powerusers.microsoft.com/t5/Building-Flows/Table-in-Email-Body-to-SQL/td-p/174738

 



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA

Hi, Thank you for the answer.

 

Is this also necessary if both tables have the same column names etc?

@BrunnerSi  yes, to easy recognice it.



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA

Hi,

 

I have entered the code as mentioned. Unfortunately this does not work and I'm not sure if I got it right.

Therefore I have added the table. Can you tell me what I have to program in detail to make this work?

I am looking forward to your answers.

 

Simon

 

Grafik Tabelle.png

 

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Top Solution Authors
Users online (2,947)