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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Copy excel data into mail
Power Automate
Unanswered

Copy excel data into mail

(0) ShareShare
ReportReport
Posted on by 4,214 Super User 2026 Season 2

Hi all, 

I have one scenario, 

i have one excel data i want to read whole excel and send into mail as a table format with all data, anyone let me know how can i solve those issue.

 

 

Thanks,

Riyaz

  • MichaelAnnis Profile Picture
    5,727 Moderator on at

    Hey @Ahammad_Riyaz ,

     

    First things first:  If those are real, please delete the table, so no one takes the information.

     

    Could you save the table to Excel and attach it to the email?  This would be easiest.

     

    Launch Outlook

    Send email in Outlook (and you reference the filename in the ‘Attachments’ parameter.)

     

    good luck!

  • Riyaz_riz11 Profile Picture
    4,214 Super User 2026 Season 2 on at

    As a attachment i can send but the thing how can i send in mail as a table format

  • MichaelAnnis Profile Picture
    5,727 Moderator on at

    Try this:

     

    Read from Excel to %ExcelData%

    Then in the body of the Send Email using Outlook action:  %ExcelData%

  • Riyaz_riz11 Profile Picture
    4,214 Super User 2026 Season 2 on at

    I was getting value but still i was required as table format, currently i will get as a text in a single line.

  • MichaelAnnis Profile Picture
    5,727 Moderator on at

    Check this out:


    https://www.extendoffice.com/documents/excel/3593-excel-convert-cells-to-html-table.html

     

    you should be able to save the Excel table as an html file.  Then you can imbed the html directly into the body of the paragraph. 

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
11manish Profile Picture

11manish 233 Super User 2026 Season 2

#2
David_MA Profile Picture

David_MA 227 Super User 2026 Season 2

#3
Mohsin Ali Profile Picture

Mohsin Ali 178

Last 30 days Overall leaderboard