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

Like (0) Share

Report

Posted on 28 Dec 2023 04:04:41 by hninyuaung

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?

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

All responses (1)

Answers (0)

Yasir_rd 91 on 02 Jan 2024 at 03:43:07

Like (0)

Report

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

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.