Power Platform Community Forum Thread Details

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
)

Categories:

Using Apps Using Formulas