You’re offline. This is a read only version of the page.
Announcements
20
Hi All,
This is probably pretty simple, but...
I have an excel table that has a list of dates, I would like to grab the most recent date that list and put it into the body of email. I think I am close going by the photo, but cant seem to get it figured out.
Thanks!
Hi , @WheelerS84
According to your description, you want to get the most recent Date in your Excel.
Here are the steps you can refer to :
(1)This is my test data:
(2)This is my flow:
int(first(split(replace(dateDifference(item()?['Date'],utcNow()),'-','') ,'.') ) )
first(sort(body('Select'),'DateDifference'))?['Date']
And the result is as follows in "Compose" action:
You can also use the FormatDateTime() function to get the format date you want in your side .
If I misunderstand what you mean, you can describe your needs and your expected outcomes in detail so that we can better help you.
Best Regards,
Yueyun Zhang
Share
Report
All responses (
Answers (
