Answered

Filter multiple elements in only one gallery

(0) Share

Report

Posted on by Pedr0sc

Hi,

I'm trying to filter multiple elements in only one gallery but with no sucess. These elements are 2 ComboBox and 1 TextInput in the same Gallery.

ComboBox1 filters MultipleChoiceColumn
ComboBox2 filters SingleChoiceColumn
TexpInput1 filters Name of each row of the SPList

The filter sequence in the gallery should be:
ComboBox1 -> ComboBox2 -> TexpInput1

The code that i'm trying to input into the Gallery1 (section Items)

With(
 Filter(
 SPlist;
 ID in Distinct(
 Ungroup(
 ForAll(
 ComboBox2.SelectedItems As CC;
 Filter(
 SPlist;
 CC.Value in SingleChoiceColumn.Value 
 )
 );
 "Value"
 );
 ID
 )),
 {
 _Data:
 Search(
 SPlist,
 TextInput1.Text,
 Name
 )
 },
 If(
 Len(ComboBox1.Selected.Value) = 0,
 _Data,
 Ungroup(
 ForAll(
 ComboBox1.SelectedItems As _Items,
 Filter(
 _Data,
 _Items.Value in MultipleChoiceColumn.Value
 )
 ),
 Value
 )
 )
)

Thanks in advice!

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

v-mengmli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Pedr0sc ,

Please try this.

With( { _Data: Filter( SPlist, IsEmpty(ComboBox1.SelectedItems) || ID in Distinct( Ungroup( ForAll( ComboBox1.SelectedItems As CC, Filter( _Data, CC.Value in MultipleChoiceColumn.Value ) ), Value ), ID ) ) },//Filter ComboBox1 With( { _Data2: Filter ( _Data, IsEmpty(ComboBox2.SelectedItems) || SingleChoiceColumn.Value in ComboBox2.SelectedItems.Value ) },//Filter ComboBox2 Search( _Data2, TextInput1.Text, Name )//Filter TextInput1 ) )

Best regards,

Rimmon

Was this reply helpful? Yes No
Pedr0sc 33 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-mengmli-msft , thanks for your reply!

I've tried some changes in this code. Also some syntax changes like , (comma) instead a ; (semicolon). But with no sucess

The error is in the "//Filter ComboBox1". It is the second Filter function: "function has invalid arguments". And the invalid arguments is "_Data".

Was this reply helpful? Yes No
Verified answer

v-mengmli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Pedr0sc ,

Please try to change it to SPlist.

Best regards,

Rimmon

Was this reply helpful? Yes No
Pedr0sc 33 on at

Like (0)

Report
Copy link

Link copied!

Awesome worked!!

Thank's a lot @v-mengmli-msft!

Was this reply helpful? Yes No