A new requirement isnt working for me.
The customer wants to filter by the SharePoint ID number.
The below FX logic works to filter by the ID number but the other filter doesnt work.
If(
IsBlank(txtSearchID),
Filter(
'Regional Bank Execution Team Intake - DEV',
BusAlignment.Value = cboBusAlignment.Selected.Value || IsBlank(cboBusAlignment.Selected.Value),
ExeTeamMember.DisplayName = cboExecTeamMember.Selected.Value || IsBlank(cboExecTeamMember.Selected.Value),
StartsWith(
'Request Title',
txtSearchBox.Text
)
),
Filter(
'Regional Bank Execution Team Intake - DEV',
ID = Value(txtSearchID.Text) || IsBlank(txtSearchID.Text)
)
)
The below works fine but I dont have the ID filter.
Filter(
'Regional Bank Execution Team Intake - DEV',
BusAlignment.Value = cboBusAlignment.Selected.Value || IsBlank(cboBusAlignment.Selected.Value),
ExeTeamMember.DisplayName = cboExecTeamMember.Selected.Value || IsBlank(cboExecTeamMember.Selected.Value),
StartsWith(
'Request Title',
txtSearchBox.Text
)
)
Any Suggestions?
