Excel condition parameter compared to text string returning false

[beaglecodee]

Hello, I am having trouble with the following.

I have an Excel table that pulls data from a query. In this query, I have information about all the students in the district. One of the columns in this table, Student_Name, contains the students first and last names. I want to be able to create a table and send this table out through email if any of the students I select have missing assignments. The student will not populate in the query if they do not have any missing assignments.

When I go to compare the parameter containing the students “LName, FName”  to a text string, the condition returns false - therefore my HTML table is never created. For this example, I am positive “Smith, John” is one of the students.

I am stumped on why this is and would appreciate any help. Thank you - I would be happy to provide more logic if needed.

https://i.imgur.com/VSlRrgt.jpg

[Hardesh15]

@beaglecodee  Pls use String() in expression tab then type your Student name.

Example- String('Smith,john')

Thanks

Hardesh