web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Get the latest 5 files...

Power Automate

Suggested Answer

Get the latest 5 files inside "List Files in folder" onedrvice action

(1) Share

Report

Report

Posted on by johnjohnPter

1,811 Super User 2024 Season 1

I have the following action to "List the Files inside a Folder":-

now how i can only get the latest (based on the modified date) 5 files?

i used this formula to get the id of the latest file:-

last(sort(outputs('List_files_in_folder_2')?['body/value'], 'LastModified'))?['Id']

but how i can get the 5 latest files? i can not find a way to do LastN()?

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

Michael E. Gernaey 53,362 Super User 2025 Season 2 on at

Like (2)

Report
Hi,

So you need to do 3 things

1) sort them by LastModified

2) reverse it

3) use the Take expression to take the first 5 based on step 2

Now you have the last 5

So in my example, I did this

And my Sort/Reverse/Take is here

take(reverse(sort(outputs('List_files_in_folder')?['body/value'],'LastModified')),5)

Was this reply helpful? Yes No
Suggested answer

Sayan 818 Super User 2025 Season 2 on at

Like (1)

Report
Hey,

Solution:

Step 1:

Initialize a variable which is an Array type.

Get the files from the folder

Step 2:

Set a Variable by using the following expression to get the 5 files.

take(reverse(sort(outputs('List_files_in_folder')?['body/value'],'LastModified')),5)

Workflow:

----------------------------------------------------------------------------------------------------------------------------------------------------

Thanks,

Sayan Patra | RPA Developer

If my suggestion helps you, please gives it a Thumbs up and Marks as a Solution. Which motivates to solve more problems.

Was this reply helpful? Yes No

Join the conversation