Hi @k_cain ,
The below is free-typed, so watch brackets and commas etc, but you should get an idea of the syntax if there are any errors.
With(
{
wSearch:'FHA Number or Property Name Search_Input',
wList:
AddColumns(
'Construction Analyst Workload Management',
"FHANo",
FHANumber_x003a_FHA_x0020_Number.Value,
"FHAProp",
FHANumber_x003a_Property_x0020_N.Value,
wID,
Text(ID)
)
},
SortByColumns(
Filter(
wList,
IsBlank(wSearch) ||
(
wSearch =wID ||
wSearch=FHANo ||
wSearch=FHAProp ||
StartsWith(RequestType,wSearch ||
StartsWith(RequestNumber,wSearch)
)
),
"ID",
If(
SortDescending1,
Ascending,
Descending
)
)
)
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
