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

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

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
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (9,680)