I have some files i want to be conducting a pre-check for, if files are available in folder or not, and if both file name and the sheet names contained in these files.
I want to have a workflow i could run and perhaps throw an error message if these file names or sheet names are different.
Main Ask>> 1.Have workflow run and check if these files are available or not. If file missing, throw an error message.
2. Then check file name and sheet names are ok. If filename or sheet names not as below, throw an error message.
-These reports are saved on a daily basis by a different team but at times the file names and sheet names may be slightly altered and i don't want to be performing this checks manually.
-The first file is "Facility Excess Report.xlsx" and the sheet name inside is "Report 1". So if file names and sheet names appear different throw error message e.g Filename/Sheet name incorrect, otherwise "Filename/Sheet name OK"
-The same applies for the other report "No of days Past Due.xlsx" and it's sheet name "Past Due Report".
See attached file names i am referring to (these are the standard file and sheet names of these files and the sheet names.
