Power Platform Community Forum Thread Details

Ellis Karim 11,105 Super User 2025 Season 1 on at

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
bsprakermg 20 on at

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?
Ellis Karim 11,105 Super User 2025 Season 1 on at

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
bsprakermg 20 on at

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.
Kamran1 5 on at

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.
Ellis Karim 11,105 Super User 2025 Season 1 on at

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
CU20080932-1 99 on at

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.
LeandroCampacci 51 on at

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'.
Simon_A2T 7 on at

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
LeandroCampacci 51 on at

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.