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

2,104 Season of Giving Solutions 2025

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:

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

Suggested answer

Michael E. Gernaey 53,970 Super User 2026 Season 2 on at

Like
a
(2)

Report
Copy link

Link copied!
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)
Suggested answer

Sayan 818 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
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.

Join the conversation