Send an email v2 with Excel Attachment

[alpatel]

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. 

I received email attach in this format. 

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

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

[abm]

Hi @alpatel 

Where is your attachment mapping?

[alpatel]

My file is in mapping from Onedrive.

[alpatel]

To Onedrive

[alpatel]

To onedrive

[abm]

Hi @alpatel 

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

[alpatel]

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

[alpatel]

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. 

[

  {

    "Name": "Provider Report.xlsx",

    "ContentBytes": "Provider Report"

  }

]

[alpatel]

Hi  @abm 

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

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

[v-litu-msft · Accepted solution]

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.