Inputs with new sheet names each month

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

Capture.jpeg

Developer

Accepted answers

binu_acs

@Tony_McC67 one way of doing this

Input_Sheet_Dynamically_30042025.yxzp

abacon

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

Inputs with new sheet name.yxmd

All comments

binu_acs

@Tony_McC67 one way of doing this

Input_Sheet_Dynamically_30042025.yxzp

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

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

Inputs with new sheet name.yxmd

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!

Capture.PNG

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703