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 / Filter gallery based o...
Power Apps
Answered

Filter gallery based on item selected from second gallery

(0) ShareShare
ReportReport
Posted on by 119

Dear Community,

 

I have two galleries on the same canvas, both linked to the same SharePoint list (called "Idea Management"). First gallery "Gallery1" shows all items with basic information (SharePoint list columns) and has filter function. After clicking on the arrow on the right side of each item row, I would like to have second gallery "Gallery3" showing detailed information (additional SharePoint list fields  - multiple line of text columns) related to the item based on field "ID".

 

I know I have to change the formula in Gallery1/Arrow/On Select and in Gallery3/Visible and Gallery3/Items.

Am I right? But could you please advise formulas?

 

Gallery1/Arrow/On Select=Select(Parent) and set Gallery3 to visible ?

 

Gallery3/Visible=true if arrow above selected ?

 

Gallery3/Items=Filter('Idea Management',ID=Gallery1.Selected.ID) - this is showing error Incompatible types for comparison: Number, Control.

 

Thank you very much in advance.

Screen shot of the canvas with two galleries:

Eeyore2005_0-1667806030407.png

 

Categories:
I have the same question (0)
  • Akser Profile Picture
    1,546 Moderator on at

    Hi @Eeyore2005,

     

    Gallery1/Arrow/On Select

     

     

    Set(varSelectedItem, ThisItem)

     

     

    Gallery3/Visible

     

     

    varSelectedItem <> Blank()

     

     

    Gallery3/Items

     

     

    Table(varSelectedItem)

     

     

     

  • Verified answer
    v-liwei-msft Profile Picture
    Microsoft Employee on at

    Hi @Eeyore2005 

     

    You can directly enter the formula in the Items property of gallery3: Gallery1.Selected

     

    Best Regards,

    Levi

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!

Leaderboard > Power Apps

#1
Haque Profile Picture

Haque 94

#2
WarrenBelz Profile Picture

WarrenBelz 82 Most Valuable Professional

#3
Kalathiya Profile Picture

Kalathiya 38 Super User 2026 Season 1

Last 30 days Overall leaderboard