Unable to Read File Using Dynamic Input

shaheer

So I have the following part of a flow:

I want to retrieve the most recently added file in a specific folder, as shown by the first three tools. The files will always have the same name except for being ordered at the start and including the date of upload (so 1. [filename][date], 2. [filename][date] etc). 

This is what my dynamic input looks like:

The file name comes after the very last '\'. I was told in several tutorials and videos to include a template file? I was not sure what this was, so I just used the current most recent file in the folder. Before, I was facing no issues when running this flow. A few days later I got the read only error. 

Any ideas on what to do? Thanks. 

CarliE

@shaheer what file type are you bringing in?

if its an excel file, make sure to provide the sheet name in the full path -- example

C:\Users\Carli\Test.xlsx --> C:\Users\Carli\Test.xlsx|||`Sheet1$`

The template provides what the schema should be so if the schema changes, it could break (different field names / more fields than the template file) -- if thats the case, a macro would be a better solution

If this helped to solve your issue, make sure to mark it as a solution