OneDrive for Business - Delete files in folder if they are more than 50

[Anonymous]

Hello,

I am currently using the following Powershell script:

dir "PATH" | ? {!$_.psiscontainer} | sort LastWriteTime -desc | select -skip(50) | del

The script makes sure that I keep the newest 50 files in one folder. As soon as there are more than 50 files, the oldest ones should be deleted.

How can I implement this in Microsoft Flow? Can I also use Powershell commands in Flow?

Thanks 

Green14

[v-zhos-msft]

Hi @Anonymous ,

It seems that you would like to keep the newest 50 files in one folder. And delete the older ones.

I am afraid that there is no way to achieve your needs in Microsoft Flow currently.

There is no function to sort the files by created time in the flow.

Here is a similar idea with your case, you can vote the idea here:

https://powerusers.microsoft.com/t5/Flow-Ideas/sort-onedrive-list-of-files-with-optional-delete/idi-p/52555

Best Regards,

Community Support Team _ Zhongys

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.