Hi Team,
In my app, I have a gallery that has some filters and also a search text box. Currently, I have 2 columns that are being searched and I need to add the 3rd column which is a numeric column named "ProjNumber". When adding the 3rd column to the search section of the code I am getting an error. Can someone please assist me on the same.
Sort(
Search(
Filter(
DataTable_Inventory_New,
IsBlank(dcformstatus_f.Selected) || IsEmpty(dcformstatus_f.Selected) || FormStatus.Value = dcformstatus_f.Selected.Value,
IsBlank(dcnm.Selected) || IsEmpty(dcnm.Selected) || name.Value = dcnm.Selected.Value,
IsBlank(dcClientName_1.Selected) || IsEmpty(dcClientName_1.Selected) || ClientName.Value = dcClientName_1.Selected.Value
),
TextInput_search_project_2.Text,
"Title",
"Projectname"
),
ID,
SortOrder.Descending
)
