Hi
I would like to retrieve the latest and earliest date from a specific column in an excel table, as shown in the image below.
The date format is YYYY/MM/DD.
Would this be possible with Power Automate Desktop.
Thank you

Hi
I would like to retrieve the latest and earliest date from a specific column in an excel table, as shown in the image below.
The date format is YYYY/MM/DD.
Would this be possible with Power Automate Desktop.
Thank you
Hi @Michael999
Use Run .net action
configure references as shown in the link below
https://youtu.be/gyscFdPdCCQ?si=vBZzKYXMukK2zcm
Add the linq and arguments as shown in the below image
Use the following Linq
out_DT = DT.AsEnumerable.OrderByDescending(Function(r) Datetime.ParseExact(r("Date").trim,{"YYYY/MM/DD"}, System.Globalization.CultureInfo.InvariantCulture,system.Globalization.DateTimeStyles.None)).CopyToDataTable
Now you will get a data table in which the date is ordered and pick the first row then you can get the latest date.....
Hope this helps,
Usha.