Inputs with new sheet names each month

[Tony_McC67]

Hi,

My input file has multiple sheets, one called "Reconciliation" and other sheets which represent the months of the year. (see image as an example). 

Currently, I need to update the sheet name in the Input tool each month to the latest month (i.e. in the image attached, I would select April 2025, as it's the most recent month) before running the flow. I am wondering if there is a way to automatically select the sheet related to the most recent month, without manually updating the input tool.

Thanks,

Tony

[binuacs · Accepted solution]

@Tony_McC67 one way of doing this

[Tony_McC67]

Thanks Polaris!

I think that is almost what I want but I'm looking for it to select the most recent month, not necessarily the current month. 

Thanks,

Tony

[Tony_McC67]

Hi,

One other detail that may be relevant. 

The file name itself will also change each month. It is in the format 04. April_24_Standard format.xlsx, 05. May_24_standard format.xlsx, 06. June_24_standard format.xlsx etc.

In the location of the file, there will only ever be one file, as the latest file will replace the previous month's version.

Thanks,

Tony

[abacon · Accepted solution]

I believe this gets you what you want. Convert the values to date and get the max date. This along with what @binuacs posted will get you what you want.

[Tony_McC67]

Thanks everyone!

I've managed to solve it through using a combination of the responses as a basis of this. 

See image attached if interested.

Thanks all!