I have a gallery displaying records that are tied to a specific parent ID. I want users to be able to also tie the record to other related records that are NOT tied to that parent ID using a combo box, but I don't want that combo box to show any of the items that already show in my gallery.
Here's the gallery Items property:
Filter(Efforts, ParentNarrativeID= NarrativeDropDown.Selected.ID)
The gallery then displays the result's 'Initiative Title'
Here's my current combo box items property:
Sort(Filter(Efforts, 'Effort Type'.Value="Canvas"), 'Initiative Title', Ascending)
What can I add to the combo box to filter out any Initiative Titles that already show up in the gallery?
