Hi People,
I've attached a screenshot of how I'm going to take multiple inputs for my data but before processing with the data the workflow must check for the naming convention and then proceed with the logics.
The naming convention is required for the file browse tool. But then the catch is we need to extract the file name and date mentioned and compare it with the reporting period given date as well.
Example: FileName is Sachin Sharma Expense_11-21-2024.xlsx
Then the File Name should be extracted as Sachin Sharma Expense, Date Should be extracted as 11-21-2024. then it should be matched with Input Date in Reporting Period Text Box Interface tool and proceed further.
Solved! Go to Solution.
Try out the Error Message tool to write a bit of logic for making sure the file name matches the naming convention you need!