Power Platform Community Forum Thread Details

I have the following formula and need to filter it by several columns and values. Basically, the filter I need is 'Number' <> "01-T-01" AND 'Deliverable' <> "Trajectory" AND 'Area' <> "Mission" AND 'Phase' <> "Acquisition" AND 'Step' <> "Acquired" AND 'Value' <> "Complete?". Where in the formula below do I put this?

With({ records:
GroupBy(
Search(
Filter(
AddColumns(
AddColumns(
ShowColumns(
Search(
Filter(
'Deliverable Line Items',
(IsBlank(argProjectId) || ThisRecord.Project.Project = argProjectId),
Status = 'Status (Deliverable Line Items)'.Active

),
cmpDeliverableSearchInput.Text,
"skh_linenumber"
),
"skh_deliverablelineitemid",
"skh_projectid",
"skh_linenumber",
"skh_projectdeliverableid",
"skh_projectarea",
"skh_projectphase",
"skh_projectstepid",
"skh_projectaction",
"skh_datavaluewms",
"skh_datafieldtype",
"skh_datafieldlabel",
"skh_datavaluestring",
"skh_assignedto",
"skh_duedate",
"skh_dateuploaded",
"skh_updateuserid",
"skh_prereqs",
"skh_colorcanpopulate",
"skh_colorcomplete",
"skh_colorinprocess",
"skh_colornotready",
"skh_updateotherlines",
"statecode"
) As x,
// AddColumns arguments - required for search but used elsewhere too
"skh_projectid_name", x.skh_projectid.'Project Number',
"skh_projectdeliverableid_name", x.skh_projectdeliverableid.Name,
"skh_projectarea_text", Text(x.skh_projectarea),
"skh_projectphase_text", Text(x.skh_projectphase),
"skh_projectstepid_name", x.skh_projectstepid.skh_name,
"skh_projectaction_text", Text(x.skh_projectaction),
"skh_assignedto_text", Text(x.skh_assignedto),
"skh_duedate_text", Text(x.skh_duedate, "mm/dd/yyyy"),
"skh_duedate_sort", Text(x.skh_duedate, "yyyy/mm/dd"),
"skh_dateuploaded_text", Text(x.skh_dateuploaded, "mm/dd/yyyy"),
"skh_dateuploaded_sort", Text(x.skh_dateuploaded, "yyyy/mm/dd"),
"skh_updateuserid_name", x.skh_updateuserid.'First Name',
"skh_mission", LookUp(Projects, ThisRecord.skh_projectid = x.skh_projectid.skh_projectid).skh_missionid.skh_name
)
,
"groupByProject", skh_projectid.skh_name,
"groupByInfo",
If(chkDelReduce.Value,
Coalesce(skh_updateotherlines, skh_linenumber),
skh_linenumber
)
),
ThisRecord.statecode = 'Status (Deliverable Line Items)'.Active,
Find(
Lower(txtDelFltProject.Text),
Lower(ThisRecord.skh_projectid_name)
),
txtDelFltMission.Text = "." && IsBlank(ThisRecord.skh_mission) || !IsBlank(Find(
Lower(txtDelFltMission.Text),
Lower(ThisRecord.skh_mission)
)),
txtDelFltNumber.Text = "." && IsBlank(ThisRecord.skh_linenumber) || !IsBlank(Find(
Lower(txtDelFltNumber.Text),
Lower(ThisRecord.skh_linenumber)
)),
Find(
Lower(cbxDelFltDeliverable.Selected.Name),
Lower(ThisRecord.skh_projectdeliverableid_name)
),
IsBlank(cbxDelFltArea.Selected) || cbxDelFltArea.Selected.Value = ThisRecord.skh_projectarea,
IsBlank(cbxDelFltPhase.Selected) || cbxDelFltPhase.Selected.Value = ThisRecord.skh_projectphase,
IsBlank(cbxDelFltStep.Selected) || cbxDelFltStep.Selected.'Project Step' = ThisRecord.skh_projectstepid.'Project Step',
Find(
Lower(txtDelFltValue.Text),
Lower(ThisRecord.skh_datafieldlabel)
),
/*IsBlank(cbxDelFltDataField.SelectedItems) ||
First(cbxDelFltDataField.SelectedItems).Value = "(Blank)" && IsBlank(ThisRecord.skh_datavaluestring) ||
First(cbxDelFltDataField.SelectedItems).Value = ThisRecord.skh_datavaluestring*/
// ||
txtDelFltDataField.Text = "." && IsBlank(ThisRecord.skh_datavaluestring) || !IsBlank(Find(
Lower(txtDelFltDataField.Text),
Lower(ThisRecord.skh_datavaluestring)
)),
IsBlank(cbxDelFltAssignedTo.Selected) || cbxDelFltAssignedTo.Selected.Value = ThisRecord.skh_assignedto,
txtDelFltDueDate.Text = "." && IsBlank(ThisRecord.skh_duedate_text) || !IsBlank(Find(
Lower(txtDelFltDueDate.Text),
Lower(ThisRecord.skh_duedate_text)
)),
txtDelFltUpdated.Text = "." && IsBlank(ThisRecord.skh_dateuploaded_text) || !IsBlank(Find(
Lower(txtDelFltUpdated.Text),
Lower(ThisRecord.skh_dateuploaded_text)
)),
txtDelFltUpdBy.Text = "." && IsBlank(ThisRecord.skh_updateuserid_name) || !IsBlank(Find(
Lower(txtDelFltUpdBy.Text),
Lower(ThisRecord.skh_updateuserid_name)
)),
txtDelFltPrereq.Text = "." && IsBlank(ThisRecord.skh_prereqs) || !IsBlank(Find(
Lower(txtDelFltPrereq.Text),
Lower(ThisRecord.skh_prereqs)
)),
IsBlank(lclLineNumbers) || IsEmpty(lclLineNumbers) || ThisRecord.skh_linenumber in lclLineNumbers
),

// Search arguments
cmpDeliverableSearchInput.Text,
"skh_projectid_name",
"skh_linenumber",
"skh_mission",
"skh_projectdeliverableid_name",
"skh_projectarea_text",
"skh_projectphase_text",
"skh_projectstepid_name",
"skh_projectaction_text",
"skh_datafieldlabel",
"skh_datavaluestring",
"skh_assignedto_text",
"skh_duedate_text",
"skh_dateuploaded_text",
"skh_updateuserid_name",
"skh_prereqs"
),
"groupByProject",
"groupByInfo",
"group"
)},
SortByColumns(
ForAll(
records As row,
First(row.group)
),
lclPriorSortField,
lclSortOrder,
"skh_projectid_name",
SortOrder.Ascending,
"skh_linenumber",
SortOrder.Ascending
)
)