Hello,
I have 3 SharePoint lists:
- first list is the main list "Projects" contains a lookup column named "Division" populated by list: "Ref Division"
- second list "Ref Division" that includes the division in the Title column (Text) and the department value in a lookup column "Department
- third list "Ref Department" that contains department value in Title column.
List "Projects"
Project code Description Division (lookup)
007 Skyfall MI6
List "Ref Division"
Title Department (lookup)
MI6 Operations
List "Ref Department"
Title
Operations
What I am trying to achieve is to filter the division in the Projects form based on the selected department (which is currently not part of the Projects list).
I did add a new connection to 'Ref Division' list and did add a drop down (Dropdown1) in the form that shows the departments using this formula in Items:
Choices([@'Ref Division'].Department)
By default the division dropdown is the lookup from the main sharepoint list and Items forumla is:
Choices([@'Projects'].'Division')
How can I populate the division dropdown from the Title column of "Ref Division" instead and then filter division choices based on the selected department in Dropdown1?
Can the filtering be accomplished with my data structure? If not what do I need to change?
Thank you
Sylvain
