web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Filtered Content of Li...
Power Apps
Answered

Filtered Content of Listbox dependent of selected values of other Listbox

(0) ShareShare
ReportReport
Posted on by 1

Hello there,

 

I work on a little task that used up way more of my time than I'm able to admit.

Here is my problem:

I work on an app with two screens. The user starts on the first screen and selects multiple values in a listbox (say listbox1). These values come from a sharepointlist (say list1) from the column "title".

Then the user goes to the second screen with another listbox. I want the content of listbox2 to befiltered with the selected values from listbox1. The content should come from the same sharepoint list (list1) but only displays values where the "title" column includes one of the selected values from listbox1.

 

i already populated listbox1. I concat all the selected values to a hidden textbox on screen 2. But now I cannot filter the content of listbox2. I tried some things with collections, I tried the filter function but to be honest, it's more like fishing in the dark.

 

Any help or nodge in the right direction is greatly appreciated. Feel free to ask anything, since english is not my first language I know that my explanations can somethimes be hard to understand.

 

Thank you very much.

Categories:
I have the same question (0)
  • Verified answer
    v-monli-msft Profile Picture
    Microsoft Employee on at

    Hi @henningtschalko,

     

    Since it seems that you want to have mutiple selected values from ListBox1 to filter ListBox2. You should collect the selected items from ListBox1 to a collection, suppose the collection name is C, and the column name is the collection is Test.

     

    Filter(
    DB,
    First(LastN(C,1)).Test in Title ||

    First(LastN(C,2)).Test in Title ||

    First(LastN(C,3)).Test in Title ||

    First(LastN(C,4)).Test in Title
    )

     

    Regards,

    Mona

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Vish WR Profile Picture

Vish WR 633

#2
11manish Profile Picture

11manish 588

#3
Valantis Profile Picture

Valantis 457

Last 30 days Overall leaderboard