cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rnloka
Frequent Visitor

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

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

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-yuazh-msft
Community Support
Community Support

 

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-ta...

 

 

Best regards,

Alice

View solution in original post

3 REPLIES 3
v-yuazh-msft
Community Support
Community Support

 

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-ta...

 

 

Best regards,

Alice

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

- Gabriel
Community Manager
Power Automate | Power Virtual Agents
Super User Program Manager



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.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

Carousel_PP_768x460_Wave2 (1).png

2022 Release Wave 2 Plan

Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (3,070)