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,950 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:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

Suggested answer

Michael E. Gernaey 53,963 Moderator on at

Like (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)

Was this reply helpful? Yes No
Suggested answer

Sayan 818 Moderator on at

Like (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.

Was this reply helpful? Yes No

Join the conversation