Use the input box to receive the data and store it in a variable.(Lets say “input_name”)
Please try to use Excel Application Scope Activity and specify the Excel file directory which needs to be searched.
Later use read range activity to read the entire Sheet and stroe it in Data table(lets say DT_IN)
Now use " For Each Row "Activity under Data Table and iterate through each of the row.
Now use Get row item activity and specify the Column name (name of the column)or Column Index ( for col 1 -> specify column index as 0 ).
Check if that column contains the name that u have stored in Input_Name variable.
I have attached a xaml file for your reference, try this.
Hope it help.
Prashant SinghMain.xaml (14.2 KB)