I am using a connector to SQL Server and have about 3000 records. I changed the data row limit to 2,000 records. When I do some searches, it doesn’t return the result even though the record exists. I thought the following would work with SQL server. What am I doing wrong.
SortByColumns(
Filter(
UK_Contacts,
(TextSearch.Text in EMail ||
TextSearch.Text in First_Name ||
TextSearch.Text in Last_Name ||
TextSearch.Text in Title ||
TextSearch.Text in Id ||
TextSearch.Text in UK_Segment) &&
EMail_Opted_Out = Radio_Opt_Out.Selected.Value),
"Last_Name",
SortOrder.Ascending,
"First_Name"
)

Report
All responses (
Answers (