Power Platform Community Forum Thread Details

I am building an agent that takes an excel file, gets a table and loops through the table to get each row of data, this row of data is split and used to populate word templates. So if I have 200 rows, it produces 200 statements. This works perfectly when I manually trigger it and change the excel file when needed. The problem comes in when I need to change the excel file, I am trying to automate the whole process and since the excel file changes each month, I am unsure how to do so. I tried connecting it to an agent and statically setting the excel blocks with the file path given by the user but it doesn't work unless the actual file is set in that block before hand. Any thought or ideas?