MY FILTER WITH MULTIPLE DROPDOWN DONT WORK

[Gorilla_8]

I got this code on my gallery and didnt work:

Why?

If(IsBlank(dpdSituacaoAll); FichaDeDemanda;Filter(FichaDeDemanda; Situacao.Value =dpdSituacaoAll.Selected.Value||AreaDemandante.Value= dpdAreaDemandanteAll.Selected.Value||'BI?'.Value=dpdBIAll.Selected.Value||Obrigatoriedade.Value=dpdObrigatoriedadeAll.Selected.Value;txtDescrição.Text=Descricao))

[Gorilla_8]

I got this result, but I want to show all items with one of the dropdown menus blank...

SortByColumns(
      Filter(
        DataSource;
        Situacao.Value = dpdSituacaoAll.Selected.Value || AreaDemandante.Value = dpdAreaDemandanteAll.Selected.Value || 'BI?'.Value = dpdBIAll.Selected.Value || Obrigatoriedade.Value = dpdObrigatoriedadeAll.Selected.Value;
        txtDescrição.Text in Descricao
    );
    "ID";
    Descending
)

[v-qiaqi-msft · Accepted solution]

Hi@Gorilla_8,

Based on the issue that you mentioned, do you want to filter the Gallery based on the dropdown selected and you want the Gallery to display all items when there is a dropdown selected nothing?

Could you please share a bit more about the scenario?

I have a test on my side, please modify your formula as below:

SSortByColumns(
    If(
        IsBlank(dpdSituacaoAll.Selected.Value) || IsBlank(dpdAreaDemandanteAll.Selected.Value) || IsBlank(dpdBIAll.Selected.Value) || IsBlank(dpdObrigatoriedadeAll.Selected.Value),
        Tem,
        Filter(
            Tem,
            Situacao.Value = dpdSituacaoAll.Selected.Value|| AreaDemandante.Value = dpdAreaDemandanteAll.Selected.Value|| 'BI?'.Value = dpdBIAll.Selected.Value || Obrigatoriedade.Value = dpdObrigatoriedadeAll.Selected.Value,
            txtDescrição.Text in Descricao
        )
    ),
    "Title",
    Descending
)

Note: 'Tem' is my data source, please replace it with yours.

Hope it could help.

Best Regards,

Qi