I have a task to copy the newly added files everyday from SAP Server and store it in ADLS. There are 2 types files on the server (Recurring and Upfront) appended with date. I need to store the files in separate folder and everyday add the latest file from the SAP Server to the ADLS.
File name format: R_07292021.orc Recurring_08312021.orc U_07292021.orc Upfront_08312021.orc
Below are the steps I have taken so far
Get Metadata Activity to get the list of files from the server

Use filter activity to separate the files based on the names, so filtering with the initial letter

I tried using the Foreach activity and If Condition, but it doesn't seem to be working.
I am not sure how to proceed from here. Any help is appreciated. Thank you!!
or upvote
button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is