Skip to main content

Notifications

Power Apps - Building Power Apps
Unanswered

Text input filter for multiple selections

Posted on 4 Dec 2024 16:30:55 by
Hello,
I have a form in Sharepoint where one of the fields is a multiple selection form. So, I created the gallery filter as a text input so that I can enter any word and it should filter the corresponding field in the gallery.
However, when I create the filter below, it works for the other filters, but for this one with multiple selection, it doesn't work.
Can you help me?

Filter(
    'Banco de Dados Notificação CIEVS';
    (IsBlank(dpano.Selected.Value) || Year('Data da Notificação') = dpano.Selected.Value);
    (IsBlank(cbxsituacaoevento.Selected.Value) || 'Situação do evento'.Value = cbxsituacaoevento.Selected.Value);
    (IsBlank(txtdoencaagravo.Text) || 
        CountRows(
            Filter(
                Agravo_sob_suspeita.Value; // Isso acessa a tabela de valores de mĂşltiplas seleções
                Lower(Text(Value)) in Lower(txtdoencaagravo.Text) // Compara com o texto digitado
            )
        ) > 0 // Se existir ao menos uma correspondĂŞncia
    );
    (IsBlank(txtdescricao.Text) || 
        Lower(txtdescricao.Text) in Lower('Descrição sumária')
    )
)
Categories:
  • NP-04121619-0 Profile Picture
    NP-04121619-0 on 04 Dec 2024 at 19:40:48
    Text input filter for multiple selections
    @SaiRT14, Unfortunately it didn't work. It still doesn't filter.
  • SaiRT14 Profile Picture
    SaiRT14 1,216 on 04 Dec 2024 at 19:05:01
    Text input filter for multiple selections
    In Power Apps, filtering a multi-select field can be tricky because it's a table within a field. Here's how you can fix the logic:
     
    pls try the following:
    Filter(
        'Banco de Dados Notificação CIEVS',
        (IsBlank(dpano.Selected.Value) || Year('Data da Notificação') = dpano.Selected.Value),
        (IsBlank(cbxsituacaoevento.Selected.Value) || 'Situação do evento'.Value = cbxsituacaoevento.Selected.Value),
        (IsBlank(txtdoencaagravo.Text) || 
            !IsEmpty(
                Filter(
                    Agravo_sob_suspeita,
                    Lower(Text(Value)) in Lower(txtdoencaagravo.Text)
                )
            )
        ),
        (IsBlank(txtdescricao.Text) || 
            Lower(txtdescricao.Text) in Lower('Descrição sumária')
        )
    )
     
  • ronaldwalcott Profile Picture
    ronaldwalcott 940 on 04 Dec 2024 at 18:47:48
    Text input filter for multiple selections
    Multiple selection fields return a table containing all of the selected values e.g.
    ComboBox1.SelectedItems
    You would have to filter on all the values in the table

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,372

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,900

Leaderboard