Power Platform Community Forum Thread Details

Gallery Filter Not Working

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?

Categories:

General Questions

Filter( 'Regional Bank Execution Team Intake - DEV', Or( IsBlank(txtSearchID.Text), ID = Value(txtSearchID.Text) ), Or( IsBlank(cboBusAlignment.Selected.Value), BusAlignment.Value = cboBusAlignment.Selected.Value ), Or( IsBlank(cboExecTeamMember.Selected.Value), ExeTeamMember.DisplayName = cboExecTeamMember.Selected.Value ), StartsWith( 'Request Title', Trim(txtSearchBox.Text) ) )

Quick Links

Leaderboard