A business owner is wanting the following and I am looking for ideas on how to accomplsh it.
Requirements:
Create a "CUSIP" folder with the "LOT" folder and then "Department". Within the department folder there will be a set of 3 files that need to be uploaded. Similar to this...
CUSIP
--- LOT 1
------ Finance
---------- file 01
---------- file 02
---------- file 03
------ Risk
---------- file 01
---------- file 02
If a file in the department folder is not uploaded, daily send an email to the business owner of any missing files. The challenge is that there are hundereds of CUSIP folders that the Flow would need to run through. Comparing the checklist files (would this be an excel file?) identify and write the missing files to another location/variable? and then send an email on it.
Any suggestion would super help!