Hey Guys if anyone can help me with my filter formula,
I am trying to filter my IR Requets gallery where if its current status is Approved and no record with the same IR Request Id exist in the PO Table those certain records should be displayed when the user toggle the switch.
In my gallery the column is called IR Request Id and its of type auto number,
and in my table PO table its called IR Request Id and of type lookup, this is what i have got so far if anyone can assist me on this i would really appreciate it and thank you.
Filter(
'IR Requets',
(IsBlank(IRidInp.Text) || StartsWith('IR Request Id', IRidInp.Text)) &&
(IsBlank(projectDeptTitleInp.Text) || StartsWith('Project/ Department Title ', projectDeptTitleInp.Text)) &&
(IsBlank(entitiesInp.Selected) || Entity.Entity = entitiesInp.Selected.Value) &&
(IsBlank(GBSInp.Selected) || 'GBS Project No.'.'Project GBS NO.' = GBSInp.Selected.Value) &&
(IsBlank(IRStatusInp.Selected) || 'Current Status' = IRStatusInp.Selected.Value)
&&
(
ToggleApproved.Value = false ||
(
'Current Status' = "Approved" &&
IsEmpty(
)
)
)
)
