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

View solution in original post

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
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Users online (79,983)