I have two galleries reading two sharepoint lists. "Students" and "HostFamilies"
StudentGallery and HostGallery. They are side by side on a powerapps screen.
I have a dropdown on each StudentGallery Item called 'HostTitleDD" which selects the "Title" of the host from the HostFamilies list
In some cases a family will host 2 students and othertimes only 1 Student, This is decided by a seperate number field called "PlacementNumber"
As I select a host using "HostTitleDD" in each item in the StudentGallery, I want the corresponding item in the "HostGallery" to change colour when selected once and the change colour again when selected twice.
I would also like the HostTitleDD filtered so that when 2 items in the StudentGallery have the same HostTitle, that HostTitle does not appear for selection in the dropdown.
Hope that makes sense. If someone could point me in the right direction I would appreciate it.

Report
All responses (
Answers (