Hi Guys,
I am currently working on filtering gallery with text field and dropdown list filter. The issue that I have currently one of dropdown list filter need additional condition once the value selected.
The filter that I am having issue is the dropdown list called drpProjectStatus which contains 3 values, Blank, Approved, In Progress. Please refer highlighted code in red.
If drpProjectStatus selected is blank it return result correctly,
if drpProjectStatus selected equal to Approved also return result correctly.
The issue that I am having currently if the drpProjectStatus equal to In Progress. I only want to only return the record if CM1_Approval = drpProjectStatus.SelectedText.Value or TM1_Approval = drpProjectStatus.SelectedText.Value, How can I do this? Thank you
Search(
Filter(
'EvaluationReport',
And(
Or(
Dropdown_Category.SelectedText.Value = "All",
'Prodcategory'.Value = Dropdown_Category.SelectedText.Value
)
),
And(
Or(
IsBlank(drpProjectStatus.SelectedText.Value),
//This Value only trigger if the drpProjectStatus select Approved (which is working)
'Mkt_Status'.Value = drpProjectStatus.SelectedText.Value,
'CMT_Status'.Value = drpProjectStatus.SelectedText.Value,
'TM_Status'.Value = drpProjectStatus.SelectedText.Value
//I need to add new condition if drpProjectStatus selected = In progress (this still not display value)
CM1_Approval = drpProjectStatus.SelectedText.Value,
TM1_Approval = drpProjectStatus.SelectedText.Value,
)
),
And(
'GM_Status'.Value <>"Rejected", 'CMT_Status'.Value <>"Rejected"
),
And(
ControlStage <> "Approved"
)
),
txtNameFilter.Text,
Title
)
4
Share
Report
All responses (
Answers (
