Query to select only last 24 hours files from share point folder

[nagoor]

Hi Guys,

I have a set of excel data schedule to move to SharePoint folder on every 15min, I need to know is there any possibilities to get only last 96 files in that folder to refresh the data, instead of considering all the data in the folder. 

[MFelix · Accepted solution]

Hi @nagoor,

Don't know how you have the structure of the folder but when you do the upload of the folder you can do a keep last X rows and define the 96 files or make a filter of the columns by create /modified date in order to have the expected result.

Regards,

MFelix