web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : 25dloC/Wf3wXC4cZE7BgYt
Power Automate - Building Flows
Unanswered

Copy table from email and paste into Excel Online

Like (0) ShareShare
ReportReport
Posted on 21 Jun 2019 07:41:52 by 2

I have a autoamted report scheduled from Salesforce and it will send to my inbox in table format.

 

how can i automate the process to copy the table and paste it into Excel Online? 

I have the same question (0)
  • v-lin-msft Profile Picture
    728 on 24 Jun 2019 at 08:09:58
    Re: Copy table from email and paste into Excel Online

    Hi @cece,

     

    I'm afraid Flow's existing connectors and operations do not meet your needs.

     

    Extracting elements from an E-mail's HTML table is not currently supported.

     

    Here's a similar post that extracts parameters from the Email body that you can refer to:

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

     

    Best Regards,

    Community Support Team _ Lin Tu

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

  • cece Profile Picture
    2 on 24 Jun 2019 at 03:09:02
    Re: Copy table from email and paste into Excel Online

    Hi Harr,

     

    this is the screenshot of my email content. it's in table format.

     

    Annotation 2019-06-24 110520.png

     

  • Harry_G Profile Picture
    367 on 21 Jun 2019 at 12:06:38
    Re: Copy table from email and paste into Excel Online

    Hi @cece ,

    Can you plaese confirm in which form did you receive data in body of Email? for see data receive in flow use Html to text converter

    1.JPG2.JPG

    After seen the data format than decided that how you can paste data in Excel.

     

    Thanks,

    Harry_G

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

MS.Ragavendar – Community Spotlight

We are honored to recognize Ragavendar Swaminatha Subramanian as our September…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 954 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 650 Moderator

#3
trice602 Profile Picture

trice602 327 Super User 2025 Season 2

Last 30 days Overall leaderboard
Loading complete