Building a flow - Microsoft Flow - Excel to email. Date in excel is OK but in email it is a number.

(0) Share

Report

Posted on by rnloka

using Microsoft Flow for sending out emails from an Excel Table.

The Excel table has a few columns of data formatted as "DDD, DD MMM YYYY".

When the email is sent out by Microsoft Flow, the email body shows this date as a number in the format "xxxxx".

i have no clue how to configure / format it correctly in Flow.

Any help will be much appreciated.

Excel Table show as below followed by the date format in the email body: -

date in excel.PNG

date in email.PNG

Any help will be much appreciated.

I am a novice as far as the Microsoft Flow is concerned.

best regards

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

v-yuazh-msft on at

Like (1)

Report

Hi @rnloka,

Could you please share a screenshot of the configuration of your flow?

Does you save the excel file in the sharepoint?

The date time in excel table in sharepoint would always be formated to the string as your screenshot in microsoft flow currently.

I afraid that there is no way to achieve your needs in Microsoft Flow currently if you save the excel table in sharepoint.

Could you please take a try to save the Excel in your Onedrive for business folder instead of save it in the sharepoint,there is a post below have the same issue as you, and the user could save the Excel in your Onedrive for business folder instead of save it in the sharepoint to achieve the requirement:

https://powerusers.microsoft.com/t5/General-Flow-Discussion/Create-Item-from-List-Rows-present-in-table-String-was-not/m-p/131074#M13955

Best regards,

Alice

Was this reply helpful? Yes No
GabrielStJohn on at

Like (0)

Report

Hey, @rnloka!

It appears as though @v-yuazh-msft would like some more information in order to further assist you properly with your issue. Please share any additional information that was requested in order to decrease the amount of time that it will take for you to be assisted!

Thank you for being an active member of the Flow Community!

-Gabriel
Flow Community Manager

Was this reply helpful? Yes No
rnloka 25 on at

Like (0)

Report

Gabriel,
Thanks for the below and the help explained has made my understanding better.
I have been able to circumvent the problem.
Please treat it as solved.
Much appreciated your kind assistance.

Was this reply helpful? Yes No