Hi CB Weiner,
Thank you for posting query in Microsoft Q&A Platform.
There are couple of ways to do this.
Consider using
Get Meta Data Activity
to get all folder names using child Items field in configuration. Now, take all these folder names into SQL temp table and use SQL engine power (using lookup or script activity) to write query that will give you back latest folder name. Once you get that pass that folder in to Copy activity with parameterized dataset to get file from the folder dynamically.
OR
After getting folder names in an array using GetMetaData activity, loop them and find latest one and then use that folder name dynamically in copy activity to copy file. You can check below video for reference to know the process. Get Latest File from Folder and Process it in Azure Data Factory
Hope this helps. Please let me know how it goes or if any further queries.
Please consider hitting Accept Answer
button. Accepted answers help community as well. Thank you.