You’re offline. This is a read only version of the page.
25
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: -
Any help will be much appreciated.
I am a novice as far as the Microsoft Flow is concerned.
best regards
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.
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
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:
Best regards,
Alice
#1
WarrenBelz
146,601
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,942
Most Valuable Professional
Share
Report
All responses (
Answers (
