Answered

Exclude item in combo box if it appears as an item in a gallery

(0) Share

Report

Posted on by JennC26

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?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

JD382 114 on at

Like (2)

Report

This will filter out items that don't have a ParentNarrativeID that is selected in NarrativeDropDown (which is the only filter for your gallery).

Sort(Filter(Efforts, 'Effort Type'.Value="Canvas" && !(ParentNarrativeID=NarrativeDropDown.Selected.ID)), 'Initiative Title', Ascending)

Hope this helps!

Was this reply helpful? Yes No
JennC26 64 on at

Like (0)

Report

Thanks, @JD382. Right after submitting my question, the lightbulb went off and I was coming to the same realization and came up with the same formula above. Great minds 🙂

Thanks again for the response and validation!

Was this reply helpful? Yes No