Interesting. I used the project code and uploaded it to a new project. It appears that the keyboard used in the US as opposed to ....UK provides a different syntax output. The code below worked as per the project .... which appears slightly different that the code provided in the forum response.

"[Last Name] <> '" + vLastName + "' AND [First Name] <> '" + vFirstName + "'"

I was able to get "Remove Data Option" to work but found "Remove Index Row" results confusing as it removed the row number and ignored the form data input. However I can see other use cases where this can be useful.

Many thanks for your prompt response and assistance!!

Hi MARMCC001,

Thankyou for reaching out to us. The correct syntax for row filter command to filter datatable - "[Last Name] <> '" + vLastName + "' AND [First Name] <> '" + vFirstName + "'". In case the syntax is not clear, below there video, there is a project file which you can download and open it to view the exact syntax and understand the code as well. Please try it out and other alternative for row filter command would be to use - Remove Datarow command.

In the Remove data row command you need to provide - Input datatable name, Remove data option - Data/Index. 1)Remove Index option - Index - Please provide index number - It's the row number of datatable starting from 0. 2)Remove Data option - Data - Please provide necessary input data - Column names of excel sheet and the data variable entered during the form. For the second option , we have another field overwrite option, where the values can be connected logically using AND/OR which will remove based on the constraints matching.

Please try it out and let me know if you face any further issues.