How can I find in a google drive the last changed file of a series of files for example (” 1MW settlement 10/10/2024 , 2MW settlement 12/10/2024 , 3MW settlement 18/10/2024 , etc) … with the ‘Search for Files/Folders’ module I have a list of files but from that I want to filter out the last saved file . How to do this best with as few operations as possible .
Thanks in advance for telling me which modules I should use and how to set them up.
Hi Leo,
In your case the last saved file would be the last modified file. This is given through the property “modifiedTime” of the file (1 bundle = 1 file for the GDrive search file module).
You need to put all the files in an array using ARRAY AGGREGATOR so you can sort the array, and take the first element of the array, which will be the last edited file.
The scenario :
The formula to sort your array and take the first element (last modified) :
But infact I think GDrive search is by default sorting, so 1st bundle should be the last edited file, but not 100% sure…
Best regards 
Thanks Francois !!! this is super … i have always problems to find the correct formula .Do you know where i can find a sort of course for that kind of stuff (formulas)?
You’re welcome, I was beginner 2 month ago and trust me you learn supper quickly
Maybe do the Make Academy courses, they are really nice !