web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Get Modified date orde...
Power Automate
Unanswered

Get Modified date order by descending in List files in folder of one drive for business using Power Automate

(0) ShareShare
ReportReport
Posted on by hninyuaung 42

Hi,

I want to get a modified date order by descending. I used List Files in Folder of one drive for business using power automate. In one dirve folder , I have more than 100,000 items . I tried a flow to get modified date that is equal a given special date . How can I do it?

hninyuaung_0-1703735939502.png

it started run the latest modified date. I want to run oldest modified date and want to delete that is equal condition.
If I use search query (Find File in Folder by Path) with Modified , How to do it? 

Thanks



Categories:
Using flows
I have the same question (0)
  • Yasir_rd Profile Picture
    Yasir_rd 91 on at

    Hi @hninyuaung there are two important points here

    1- By default, your one drive date will be in UTC time zone, please do some test runs to find out the modified date you see in one drive vs what gets shown in Power Automate.

    2- You must format the date using an expression like this and then do the condition check.

    formatDateTime(item()?['LastModified'],'yyyy-MM-dd')
     
    3- Then you can do the delete file action when the condition is true.
     
    If you want to get only those files modified before a certain date without a condition check, just using the list file action, I think that is not possible at the moment. Thanks.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 312 Super User 2026 Season 2

#2
11manish Profile Picture

11manish 154 Super User 2026 Season 2

#3
trice602 Profile Picture

trice602 143 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Known issue with browser automation in Power Automate for Desktop on Google Chrome 146 and 147
Share your ideas and struggles with building Power Automate flows!
Survey: Power Automate mobile app
How to Ask for Help with Your Power Automate Workflow
Start and wait for an approval action
Restore a deleted flow
List of actions cheat sheet for Power Automate Desktop
Welcome to the Power Automate forum!

Product updates

Microsoft Power Platform Community release plans