We can read an Excel table, select the columns to display in the table, then use the Create Table action along with some table formatting to send an e

Solved: how to send excel table into mail using flow , without using attachment ?

Ellis Karim 11,358 Super User 2025 Season 2 on 06 Sep 2023 at 20:30:56

Like (1)

Report

Re: how to send excel table into mail using flow , without using attachment ?

Hi @bsprakermg ,

You can use the formatDateTime function to format the dates:

Here is the sample runtime output:

Ellis
____________________________________
If I have answered your question, please mark the post as ☑️ Solved.
If you like my response, please give it a Thumbs Up.
My Blog Site

Was this reply helpful? Yes No
bsprakermg 20 on 06 Sep 2023 at 19:52:21

Like (0)

Report

Re: how to send excel table into mail using flow , without using attachment ?

Thank you! Now - is there any way to only show yyyy-mm-dd, rather than with the time?

Was this reply helpful? Yes No
Ellis Karim 11,358 Super User 2025 Season 2 on 05 Sep 2023 at 21:24:41

Like (0)

Report

Re: how to send excel table into mail using flow , without using attachment ?

Hi @bsprakermg ,

Try setting the DateTime Format to ISO 8601:

Ellis
____________________________________
If I have answered your question, please mark the post as ☑️ Solved.
If you like my response, please give it a Thumbs Up.
My Blog Site

Was this reply helpful? Yes No
bsprakermg 20 on 05 Sep 2023 at 20:30:14

Like (0)

Report

Re: how to send excel table into mail using flow , without using attachment ?

This worked for me to figure out my own problem - now I cannot figure out how to format the date as a date instead of a number. Any help is appreciated.

Was this reply helpful? Yes No
Kamran1 5 on 15 Aug 2023 at 15:02:02

Like (0)

Report

Re: how to send excel table into mail using flow , without using attachment ?

Hello @ekarim2020

Many thanks for this, works perfectly. However, I have a few rows highlighted in my excel table. How can I send it the same way as highlighted over email?

Many thanks in advance.

Was this reply helpful? Yes No
Ellis Karim 11,358 Super User 2025 Season 2 on 07 Aug 2023 at 17:28:21

Like (0)

Report

Re: how to send excel table into mail using flow , without using attachment ?

Please see: How to export data in Power Automate to an Excel File (tachytelic.net)

"In this post I will show you how to export data from Power Automate, to an Excel file. This would seem to be a straightforward requirement, but until recently has required the use of apply to each loops which are slow and can potentially use many API actions."

Ellis
____________________________________
If I have answered your question, please mark the post as ☑️ Solved.
If you like my response, please give it a Thumbs Up.
My Blog Site

Was this reply helpful? Yes No
CU20080932-1 99 on 01 Aug 2023 at 07:40:26

Like (0)

Report

Re: how to send excel table into mail using flow , without using attachment ?

@ekarim2020 For same question, how to sent data as attachments.

Was this reply helpful? Yes No
LeandroCampacci 51 on 20 Oct 2022 at 12:14:39

Like (0)

Report

Re: how to send excel table into mail using flow , without using attachment ?

Create a script on Excel Online to do this.

Select 'Automate' and 'Record Action'.

Was this reply helpful? Yes No
Simon_A2T 7 on 19 Oct 2022 at 22:49:29

Like (2)

Report

Re: how to send excel table into mail using flow , without using attachment ?

This is an excellent answer to the question; laid out very clearly too. May I add a further question (I couldn't find this answer online)?
How would one enhance this in order to filter the table rows that are sent in the email; for example, if I wanted to send only the rows relating to the East Region?
Thanks, Simon

Was this reply helpful? Yes No
LeandroCampacci 51 on 11 Oct 2022 at 11:53:17

Like (0)

Report

Re: how to send excel table into mail using flow , without using attachment ?

A alternative to do this is make your date format on Excel as ISO 8601.

Then on list rows click 'show advanced options' and select ISO 8601 again. Isn't a perfect mode, but works.

I wanna try date format to bring date as mm/dd/yy only.

Was this reply helpful? Yes No