Hi @teach20 ,
Based on your description I assume you are using Dataverse.
Given you have already created a Relationship (I assume One-to-Many) between the Projects table and the Status table, you can leverage that relationship to Filter the Status Gallery based on the selected Project.
As a basic example, let's assume you have a Combo Box control and in the Items property of that Combo Box, you have the Projects table. Let's also assume that the in the Field properties for that Combo Box, you have it to set to display each unique Project.
With this mind, in the Items property of the Status Gallery, use:
Filter(
'Status Report',
'Your Project Lookup Field'.'Your Project ID' = ComboBox1.Selected.'Your Project ID'
)
Or suppose for example you have another Gallery which is linked to your Projects table, you could use:
Filter(
'Status Report',
'Your Project Lookup Field'.'Your Project ID' = GalleryParent.Selected.'Your Project ID'
)
Hopefully the above will provide you with some direction. Below are a couple of recent responses I have made for similar questions:
How do I filter a data table in Power Apps to show... - Power Platform Community (microsoft.com)
Solved: Re: Dataverse Lookup Tables and Canvas Apps Forms ... - Power Platform Community (microsoft.com)
------------------------------------------------------------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.
If you like my response, please give it a Thumbs Up.
Imran-Ami Khan
