
I have a Dataverse table called "UNIT" where in it there is an "ID" field.
I have a second Dataverse table called "BUSINESS TEAM" where inside there is a "BT" field. I created a relationship between these two tables to be able to assign a BT to each ID.
On my Power Apps screen, I have a gallery that is connected to a table called "JOURNAL", and the "JOURNAL" table has a relationship to the "UNIT" table.
On my Power Apps screen, I would like a filter with checkboxes. I would like that when I check a BT element, in another place on the screen, it only shows me the checkboxes of the IDs corresponding to this BT element
Can you help me please ? Thanks in advance !
In the Items property of your Gallery, you will want to a filter something like this:
Filter(Journal, Not(CHECKBOX.Value) Or UNIT.BT.ID = YOURID)
If nothing is selected in your checkbox, it will return all of the records. If your checkbox is checked, it will return records with the BT ID you've specified.