Filter not working properly

(0) Share

Report

Posted on by Poweruser32490

I have a gallery filter combobox in powerapps which filters based on the status column Pending and Completed. Gallery filters by Pending and Completed status successfully. I have another filter option called "Both" which should show both Pending and Completed Requests.

May i know how to achieve this?

Note: When the screen is loaded, by default it should filter by "Both"

Gallery Items Property

With(
    {
        _activerequests: Filter(
            Datasource,
            Len(ComboBox2.Selected.Value) = 0 || 'Status' = ComboBox2.Selected.Value
        )
    },
    SortByColumns(
        Filter(
            _activerequests,
            Len(TextInput1.Text) = 0 || TextInput1.Text in Requestor.Value || TextInput1.Text in Year.Value || TextInput1.Text in Manager.Value || TextInput1.Text in Title || TextInput1.Text in 'Created By'.DisplayName
        ),
        varsortcolumn,
        varsortdirection
    )
)

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Kalathiya 709 on at

Like (0)

Report
Copy link

Link copied!
Hello @Poweruser32490,

I have just updated your formula that will work with all options:

Please try below your updated formula:

With( { _activerequests: Filter( Datasource, Len(ComboBox2.Selected.Value) = 0 || ComboBox2.Selected.Value = "Both" || 'Status' = ComboBox2.Selected.Value ) }, SortByColumns( Filter( _activerequests, Len(TextInput1.Text) = 0 || TextInput1.Text in Requestor.Value || TextInput1.Text in Year.Value || TextInput1.Text in Manager.Value || TextInput1.Text in Title || TextInput1.Text in 'Created By'.DisplayName ), varsortcolumn, varsortdirection ) )

📩 Need more help? Mention @Kalathiya anytime!
✔️ Don’t forget to Accept as Solution if this guidance worked for you.
💛 Your Like motivates me to keep helping.

Was this reply helpful? Yes No
Kalathiya 709 on at

Like (0)

Report
Copy link

Link copied!

@Poweruser32490

I wanted to follow up and see if this resolved the issue for you. I’m happy to help further if needed.

📩 Need more help? Mention @Kalathiya anytime!
✔️ Don’t forget to Accept as Solution if this guidance worked for you.
💛 Your Like motivates me to keep helping.

Was this reply helpful? Yes No