Cascade dropdown for LookUp type of column

[Anonymous]

Hi all,

I hope someone can help me with cascading dropdown query. I have a Lookup type column called "Milestone A" in sharepoin list called "Key Cross-Project Dependencies". It's bringing column "Title" from list called "Consolidated Milestones".

What I want is to restrict list of items, showing in dropdown, based on "Project" selected in ComboBox. I manage to retrieve this filtered list into a dropdown using this formula in item property

Filter('Consolidated Milestones', 'Project Title' = ComboBox3.Selected.'Project Title').

Problem is that when I submit the form, column "Milestone A" is not getting updated. I guess it has something to do with fact that I haven't used list "Key Cross-Project Dependencies" as a source in item propery of that dropdown.

Is there anyone who can help me out here? I would be gratefull for any advice / guidance.

Many thanks.

[Luke_Timmins]

hi @Anonymous 

working from memory here. 

I think you can do something like: 

Filter('Key Cross-Project Dependencies'.'Milestone A', 'Project Title' = ComboBox3.Selected.'Project Title')

Let us know how you get on. 

Thanks, 

Luke

[Anonymous]

hi Luke,

many thanks for you help. I tried your formula, but it still seems to need some modification. Formula itself is ok, but when I use it for items propery, the dropdown feature is not working at all. I think it might be because there is no choice command in formula?

Thank you

Lukas

[Pavlous · Accepted solution]

Similiar issue is described here
Also solutions is there.

[Anonymous]

I'll buy you a beer for this one.