Filter latest max date

Jarviz

Hi team,

i have use case where i need to read excel files of current month. currently in my shared drive the excel files are being added every week Saturday or Sunday like report_2024-07-21, report_2024-07-14, report_2024-07-06, report_2024-06-30 etc.
My condition should be that it must read all the reports for current month. And the workflow should only trigger if the reports placed recently from yesterday or day before yesterday.

griffinwelsh

To my knowledge it is not possible to set up triggers for your workflow to run automatically, But you can schedule it to run on a certain interval on the server environment. If you went with this route you would just need to use a filter towards the start of your workflow to check for new files. You can use a directory tool to look at all files in your shared drive folder. From there you can use a filter with the below condition to bring in only files created this month:

ToDate([CreationTime]) >= datetimeadd(datetimenow(),-1*tonumber(datetimeformat(datetimenow(),"%d"))+1,"Days")