I have a canvas with a data table with "Date", "First Name", "Second Name", "Company", "Host" and "Visiting Site". I also have a "Text Input" box working as a "Search" Criteria box. The Search works great for the "Single Line Values" such as "First Name", "Second Name" & "Company", but as soon as I add "Date", "Host (name lookup)" or "Visiting Site (dropdown value)", the search wont work.
The code for the DataTables items value is: Search('Visitor Details',SearchBox.Text, "Company","First_x0020_Name","Second_x0020_Name","Car_x0020_Reg")
Why wont the search work with data, host and visiting site? Thanks in advance.