So after doing some other work, reading the posts I missed, drinking some more coffee, and pondering what I was even thinking in my first response 😁, here is something hopefully better and more helpful.
To filter the Master Property List, some of my old code applies:
Filter(
'Master Property List'
'PS Description' = Office365Users.UserProfile(InfoAbout.Text).Department
)
If this list will not change that often and has less than 500-2000 items, I would probably collect this filtered list. Using my old code somewhat:
ClearCollect(
colMasterPropertyList,
Filter(
'Master Property List'
'PS Description' = Office365Users.UserProfile(InfoAbout.Text).Department
)
)
If the list is bigger, you could create a gallery using the same filter in the Items property.
Now the trickier part. I am assuming that there will be multiple items in the filtered Master Property List. That means we need to filter a list with another list. There are a few options here. If your list of Collection Efforts is within 500-2000 items, you could do this for the Items property in CollectorUIGallery_1:
// If using a collection
Filter(
'Collection Efforts',
'Inn Code' in colMasterPropertyList.'Inn Code' // or GalleryName.AllItems.'Inn Code'
)
// If using a gallery named GalleryName
Filter(
'Collection Efforts',
'Inn Code' in GalleryName.AllItems.'Inn Code'
)
The "in" part isn't delegable, so you will see the blue squiggly under it. If the list is small enough this doesn't matter.
For bigger lists, what I have resorted to are nested galleries. The high-level view of this is I create a flexible height gallery that will contain the first list that I want to filter the second list by, then add a gallery inside that first gallery, filtering that second gallery by something in the first. In this case, you could use the first filter code on the Master Property List in the Items property for the first gallery. I would then put in a label for the Inn Code and add the second gallery, which would be filtered like so:
Filter(
'Collection Efforts',
'Inn Code' = ThisItem.'Inn Code'
)
I would then make it so the user can click on an item in the second gallery to navigate to a screen or have a form or something on that same screen that allows the user to work with the selected data.
A simpler take on this theme would be to show a gallery of the filtered Master Property List, have the user pick one of those, and then use that choice to filter a gallery of the Collection efforts. The Item properties would be the same for each gallery; they would just be separate galleries rather than nested ones and the second one would reference what was chosen in the first as opposed to ThisItem.'Inn Code'.
Apologies for the much more complex answer. If I am understanding this correctly, this entails a many-to-many filter, which can be a bit of a complex thing. Personally, I like the nested gallery solution as it bypasses many of the issues with many-to-many filters and can provide a nice UI/UX for the user as they can look at a categorized list of all the things and choose what they want.
I hope that is more helpful/useful than my previous (overly-hasty) response. And I look forward to what @mdevaney (the Forum King 👑 in my book) responds with as well. I enjoy seeing how others handle these types of things!
