Answered

Filter a gallery to show list items from another gallery based on ID

(0) Share

Report

Posted on by honganhuynh1

302

I have two List
1. Work Orders
2. Work Order Audit

Matching column I am trying to use is Ticket #

Let's say on Screen 1 I choose Ticket # 3 (column)
I would like it to take me to Screen 2 showing me all the List items on the Work Order Audit List that have the corresponding
Ticket # (column)

Basically filter the 2nd screen if Screen1.TicketId.ID = Screen2.Ticketid.ID

Can't get it to work! Any help would be appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

BCBuizer 22,563 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @honganhuynh1 ,

The below formula for the Items property of the gallery on screen 2 should do the trick.

Filter( 'Work Order Audit', TicketId.ID in Gallery1.AllItems.TicketId.ID )

You may have to play around a bit with the identifiers like Gallery1 (the name of the gallery on screen1) or TicketId.ID (the columns in both lists that you are trying to match).

Please note that the in operator is not delegable, so if you have over 2000 items in the 'Work Order Audit' list, this will be an issue.

Was this reply helpful? Yes No
honganhuynh1 302 on at

Like (0)

Report
Copy link

Link copied!

Hey there BcBuizer! I played with it a bit and just couldn't get it to work.
The name of the Gallery where the selected item is called BrowserGallery1
The columns in both list that I am trying to match are called Ticket #

So in my head for Item for the DetailScreen1 ( After you select an item on BrowserGallery1 it would navigate you here to see the details of the selected item) I should write
Filter('Work Order Audit Trail',
Ticket_# in BrowseGallery1.AllItems.Ticket_#)

Is that correct?

Was this reply helpful? Yes No
honganhuynh1 302 on at

Like (2)

Report
Copy link

Link copied!

Hey there BCBuizer, I figured it out with some guidance from you! Thank you!

Filter('Work Order Audit Trail', 'Ticket Number WA' = Gallery1.Selected.'Ticket Number WO') on Items
(I changed the column names behind to make it easier to look at) Thank you!!!!!!

Was this reply helpful? Yes No