Text input filter for multiple selections

(0) Share

Report

Posted on by NP-04121619-0

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:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

ronaldwalcott 3,847 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No
SaiRT14 1,990 Super User 2025 Season 2 on at

Like (0)

Report

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')
)
)

Was this reply helpful? Yes No
NP-04121619-0 8 on at

Like (0)

Report

@SaiRT14, Unfortunately it didn't work. It still doesn't filter.

Was this reply helpful? Yes No
Suggested answer

Garima_PowerPlatform 170 on at

Like (1)

Report

Hi

Please Try this

Filter(
'Banco de Dados Notificação CIEVS',

// Year Filter
IsBlank(dpano.Selected.Value) || Year('Data da Notificação') = dpano.Selected.Value,

// Single-Choice Filter
IsBlank(cbxsituacaoevento.Selected.Value) || 'Situação do evento'.Value = cbxsituacaoevento.Selected.Value,

// Multi-Choice Filter
IsBlank(txtdoencaagravo.Text) ||
ForAll(
Agravo_sob_suspeita.Value,
Lower(Text(Value)) in Lower(txtdoencaagravo.Text)
),

// Description Filter
IsBlank(txtdescricao.Text) || Lower(txtdescricao.Text) in Lower('Descrição sumária')
)

Was this reply helpful? Yes No