cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

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
Highlighted
Power Apps
Power Apps

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
Highlighted
Power Apps
Power Apps

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
Check this Out

Announcing

Class of 2020- Season 2

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (8,364)