Announcements
LookUp(FiberSalem, Shelf=DataCardValue23.Selected.Value && Card=DataCardValue24.Selected.Value && Port=DataCardValue25.Selected.Value).'PON FDP Port' This lookup works to lookup the first value in PON FDP PORT but there is two values in that field based on the datacardvalue seltions... I want to return all values and make them selectable that is found in PON FDP Port based on values entered in Datacards .. thanks in adavance
example
in the columns for datacardvalue 23 , and datacardvalue24 and datacardvalue25
1 , 1, 1 is in their twice with each one having a different Pon FDP port number.. I want to return both PON FDP numbers and make it selectable.
Hi @new3 ,
Please replace the lookup with filter . Please try:
Filter(FiberSalem, Shelf=DataCardValue23.Selected.Value && Card=DataCardValue24.Selected.Value && Port=DataCardValue25.Selected.Value).'PON FDP Port'
Best Regards,
Bof
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 326 Most Valuable Professional
11manish 168
sannavajjala87 75 Super User 2026 Season 1
