web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Filter function on mul...

Power Apps

Answered

Filter function on multiple SP list

(0) Share

Report

Report

Posted on by common_user

211

Hello community,

I am a beginner on Powerapps. I am trying to apply two filters on two different lists in a dropdown object.

For example,

List1:

City	States
Paris	France
Rome	Italy

List2:

City	States
New York	Usa
Madrid	Spain

Combobox -> Items -> ["Paris" , "Rome", "New York", "Madrid]

Combobox2 -> Items -> Filter(Test1;City=Combobox.SelectedText.Value).States

I would like to use both SP lists because I have 3500 rows and I need to divide lists in 1500 and 2000 rows.

Can you help me?

I try with:

Combobox2 -> Items -> Filter(Test1;City=Combobox.SelectedText.Value).States ;; Filter(Test2;City=Combobox.SelectedText.Value).States

but it doesn't work

Categories:

Building Power Apps

All responses Img

All responses (5)

Answers Img

Answers (1)

Sort by

BrianS 2,407 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

I think you want Filter(Test1;City=Combobox.Selected.City).States
common_user 211 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you @BrianS, yes but I don't know if is it possible filter in the same time on two different lists in SP. Do you know something about this?
BrianS 2,407 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Each Combo can only use a single list. You can Filter each Combo box but it would not work to have each dependent on the other - one can be dependent on the second, but you would create an infinite loop if they were cross-dependent
common_user 211 on at

Like
a
(0)

Report
Copy link

Link copied!

I think that I must to create two combo box that are connect to two different list.

Thank you @BrianS
Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @common_user ,

You could try:

Combobox -> OnSelect

ClearCollect(TheCollection;Filter(Test1;City=Combobox.SelectedText.Value).States);; Collect(TheCollection;Filter(Test2;City=Combobox.SelectedText.Value).States)

Combobox2 -> Items ->

TheCollection

Best Regards,

Bof

Join the conversation