Order by Descending

[khaled_emad]

Hello.
I am trying to send the latest file in folder as attachment, but its not working.

Directory.GetFiles(FolderPath,”*”).OrderByDescending(Function(d) New FileInfo(d).CreationTime).Take(1))

thanks

[Yoichi]

Hi,

Do you need the latest filename as string? if so, the following will work.

Directory.GetFiles(FolderPath,"*").OrderByDescending(Function(d) New FileInfo(d).CreationTime).FirstOrDefault

Regards,

[Gokul001 (Gokul Balaji)]

HI @khaled_emad

How about this expression?

Directory.GetFiles(Environment.GetFolderPath(Environment.SpecialFolder.UserProfile)+"\Downloads").[Select](Function(x) New FileInfo(x)).Where(Function(f) f.Extension.Equals(".xls")).OrderByDescending(Function(x) x.LastWriteTime).Take(1).ToArray()(0).ToString

Regards
Gokul

[Anil_G (Anil Gorthi)]

@khaled_emad

Please check this

Directory.GetFiles(FolderPath).OrderByDescending(Function(d) New FileInfo(d).CreationTime)(0)

Cheers

[khaled_emad]

Its saying

overload resolution failed because of no accessible ‘orderbydescending’ accepts this number of arguments

I am just trying to get the latest excel workbook created in folder to send it as an attachment in an email

[Yoichi]

Hi,

Can you share screenshot of your activity with error message?

Regards,

[khaled_emad]

same as this

Error: Overload Resolution Failed because no Accessible OrderByDescending accepts this number of arguments

Hello! I need help. I am getting the error (See title). My goal is to check the latest download “.xlsx” file in Downloads Folder (vFile variable). How do I fix the OrderByDescending? I got this code below in forum as well. [image]

[Anil_G (Anil Gorthi)]

Hi @khaled_emad

Before the directory.getfiles…please add system.io.directory.getfiles

Cheers

[khaled_emad]

@Anil_G

system.io.directory.getfiles

Yeah using that but same probem
I believe its in orderbydescending

[Yoichi]

Hi,

To isolate cause, can you try the following xaml file?

Sequence1.xaml (5.1 KB)

If it works, can you check if there is difference b/w this and yours?
If they are same, it might be something wrong with your xaml file.

Regards,

[khaled_emad]

thank you.