Hi
I have written below formula to search in gallery and its working as expected
Switch(
var_filter,
"My Nomination",
SortByColumns(
Filter(
AddColumns(
'REACH Nominations',
"PersonsName",
NomineeAlias.DisplayName
),
NomineeAlias.Claims = var_CurrentUserEmail,
StartsWith(
NomineeAlias.DisplayName,
txtsearch.Text
)
),
"PersonsName"
),
"Nominated",
SortByColumns(
Filter(
AddColumns(
'Nominations',
"PersonsName",
RWAlias.DisplayName
),
'Created By'.Claims = var_CurrentUserEmail,
StartsWith(
RWAlias.DisplayName,
txtsearch.Text
)
),
"PersonsName"
),
"All",
SortByColumns(
Filter(
AddColumns(
'Nominations',
"PersonsName",
RWAlias.DisplayName
),
StartsWith(
RWAlias.DisplayName,
txtsearch.Text
)
),
"PersonsName"
)
)
Now i also want to add below additional dropdown filter in this formula
ApproverStatus.Value = drp_Filter_Approval.Selected.Value
where to add so it can search and filter both in gallery
