AnsweredAssumed Answered

Displaying filtered list on form

Question asked by courtney.shelton Champion on Mar 1, 2018
Latest reply on Mar 6, 2018 by jpmhuls

I have three lists: Projects, Iterations, and Requirements. Iterations has a lookup column called "projects" that looks up to the Projects list on the field "Title". On the form for Projects, I want to display all items in Iterations where "projects" == CurrentItemTitle. I would also like for it to display items in the "Requirements" list where status == backlog and project == CurrentItemTitle.

 

Effectively, this should/would display all iterations and backlogged requests pertaining to a specific project. I used the lookup funciton in a calculated value as so: lookup("iterations", "project", {ItemProperty:Title}, "Title") which only returns one of the items in the iterations list. I tried a lookup part, but that is wanting a user to select from an appropriately filtered listing of iterations. 

Outcomes