You’re offline. This is a read only version of the page.
69
Hi Folks,
I have an issue with a circular reference. I am filtering gallery2 based on the selection of gallery1 but I also need to be able to update the filter on gallery2 based on a dropdown selection.
Gallery2 Items property = Filter(ActCol, EngID = Gal_Eng.Selected.ID)
What I really want is Filter(ArtCol, EngID = Gal_Eng.Selected.ID || LookUp(Engagement, ID = Dropdown.Selected.Title).ID)
Any tips on how to get this to work?
hi, you can't use LookUp in a filter as it only returns 1 record, a filter returns multiple.
On gallery 1 selection i would add to the OnSelect
ClearCollect(Col_Engagement, Filter(Engagement, ID = Dropdown.Selected.Title).ID))
then on gallery 2 items put
IF(!IsEmpty(Col_Engagement),Col_Engagement, Filter(ActCol, EngID = Gal_Eng.Selected.ID))
Share
Report
All responses (
Answers (
