cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper I
Helper I

Send an email v2 with Excel Attachment

Why am i not able to send email in Excel format. My excel is in onedrive and using "File Content" in Attachment Name and Attachment Content. 

alpatel_1-1604504086844.png

I received email attach in this format. 

alpatel_2-1604504332926.png

I don't have option to open in xls file. 

How can i convert or attach as Excel file in "Attachment Name -1"? 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

Hi @alpatel,

 

You could use formatDateTime() function to convert it to 'g' format, for example:

formatDateTime('2020-11-16T13:00:00Z','g')

Then it will return the format you want.

 

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.

View solution in original post

9 REPLIES 9
Super User III
Super User III

Hi @alpatel 

 

Where is your attachment mapping?

 

image.png



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog

Power Automate Video Tutorials

My file is in mapping from Onedrive.

Helper I
Helper I

To Onedrive

alpatel_0-1604509024218.png

 

To onedrive

alpatel_1-1604509087631.png

 

Hi @alpatel 

 

Looks like your Attachments Name is wrong. You need to map the filename here.

 

image.png



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog

Power Automate Video Tutorials

Abm, how do i map from onedrive to flow? The file is name Provider Report.xlsx. Do i just typing the name?

Hi @abm actually, i entered file name as "Provider Report.xlsx" to attachment name and attachment content "Provider Report". I got email with xls file attached. when i opened it. I get this error. 

alpatel_0-1604522485361.png

[
  {
    "Name""Provider Report.xlsx",
    "ContentBytes""Provider Report"
  }
]

Hi  @abm 

I fixed the xls issue. However, Start Time is a date/time column. 

alpatel_0-1604531012774.png

How do I convert to Start Time format to this "10/2/2020 6:00 PM" in Excel? 

Community Support
Community Support

Hi @alpatel,

 

You could use formatDateTime() function to convert it to 'g' format, for example:

formatDateTime('2020-11-16T13:00:00Z','g')

Then it will return the format you want.

 

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.

View solution in original post

Helpful resources

Announcements
PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Top Solution Authors
Users online (12,105)