Unanswered

multi filters gallery

(0) Share

Report

Posted on by luisabsg

298

Hello, I need help. I have a list on SharePoint and I created a gallery with some data. I would like to filter this data using a checkbox and text input. When I press the checkbox, the gallery has to show me only the records that the "Aprovação da BPR" column is different from blank, that is, show only the records with data. I also need my text input(Pesquisar 5-Item) filter to work both times when the checkbox is checked or unchecked, filtering my "LOTE" column. Can someone help me please?

Categories:

Building Power Apps

All responses (6)

Answers (0)

Sort by

StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @luisabsg

Please try this

With(ItemsDemo:Filter(SPList, !Checkbox.Value || !IsBlank('Apro da BPR'))}, If( !IsBlank(TextBoxFilter.Text), Filter( ItemsDemo, StartsWith( ColumnName, TextBoxFilter.Text ) ) //Filter ) //if ) //With

Note: Please replace your Source, Control, and Column Name

Thanks,
Stalin - Learn To Illuminate
luisabsg 298 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey, tks for asswering.
"The With function has some invalid arguments"
"The StarWith function has some invalid arguments"
"The Filter function has some invalid arguments"
StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
With({ItemsDemo:Filter(SPList, !Checkbox.Value || !IsBlank('Apro da BPR'))}, If( !IsBlank(TextBoxFilter.Text), Filter( ItemsDemo, StartsWith( ColumnName, TextBoxFilter.Text ) ) //Filter ) //if ) //With

Sorry, I missed when typing With({
luisabsg 298 on at

Like
a
(0)

Report
Copy link

Link copied!

It's ok, but the checkbox is not working. All records appear instead of only those with a date
StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @luisabsg

This means no filter if the check box is not selected. And filter not blank (with data) when checked
With({ItemsDemo:Filter(SPList, !Checkbox.Value || !IsBlank('Apro da BPR'))},

Please share your code and the column name. I will verify it.
luisabsg 298 on at

Like
a
(0)

Report
Copy link

Link copied!

The checkbox is checked but all the records appear, instead of only the records with a date in the "BPR Approval"

With({ItemsDemo:Filter('Liberação - Follow-up'; !Checkbox1_6.Value || !IsBlank('Aprovação da BPR - Formulação'))};
If(
!IsBlank(TextInput5_9.Text);
Filter(
ItemsDemo;
StartsWith(
'Lote Formulação/Filling';
TextInput5_9.Text
)
);'Liberação - Follow-up' //Filter
) //if
) //With