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 Apps
Answered

Filtering Gallery

(0) ShareShare
ReportReport
Posted on by 3

Hi there,

 

I have two datasets part of an App I am trying to make to show call records. The first gallery shows the accounts from a DB table called accounts. Clicking the account takes to a form showing the info on that specific account like PLan name etc. From there I have a button to another screen that shows call records for that customer which looks at a table called "callrecords". While that does infact show the call records, they are not filtered to that account and I am a little lost since I am new to this.

 

How can I restrict a gallery to show only filtered records based on the accountname I just came from on the previous screen?

 

I assume I have to specify some sort of filter in the "Data --> Items" section of the gallery on the Advanced Tab? Just don't know what.

Categories:
  • Verified answer
    CarlosFigueira Profile Picture
    Microsoft Employee on at

    Controls can reference properties of other controls in different screens. In your gallery in the third screen that shows the call records, you can use a formula in the gallery on that screen that filters it based on the selection of the first gallery. Something along the lines of

    Filter(callrecords, accountname = accountsGallery.Selected.accountName)

    And yes, you would have this in the Items property of the gallery, which you can get either in the Advanced pane, or in the formula bar on top of the canvas.

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 342 Super User 2026 Season 2

#2
M Bilal Khan Profile Picture

M Bilal Khan 258

#3
Mohsin Ali Profile Picture

Mohsin Ali 231

Last 30 days Overall leaderboard