Select most recent excel file downloaded

Help Activities
, , , , , , , ,
1

Hi everyone!
I want to select the most recent excel file from downloads and update it to Sharepoint. I know how to do that second part, but what path I have to put for selecting that file from downloads?

Thanks! :slight_smile:

2

Lets assume most recent excel file from downloads - evaluated on the Creation date

new DirectoryInfo("C:\XXXX....").GetFiles("*.xlsx").OrderBy(Function (x) x.CreationTime).Last().FullName

We also can adopt on other criterias if needed

[CheatSheet] - Filesystem APIs - News / Tutorials - UiPath Community Forum

3

It says it’s not valid.
Sorry, I know I’m writing something wrong.

4

you missed the new Keyword at least

5

What keyword?

6

grafik
grafik939×54 2.47 KB

7

Thanks! It works perfectly! :slight_smile: