cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Daryl
Level: Power Up

Filtering Gallery

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.

1 ACCEPTED SOLUTION

Accepted Solutions
PowerApps Staff CarlosFigueira
PowerApps Staff

Re: Filtering Gallery

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.

View solution in original post

1 REPLY 1
PowerApps Staff CarlosFigueira
PowerApps Staff

Re: Filtering Gallery

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.

View solution in original post

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (6,294)