Setting Choices based on lookup of multi choice text box

[Ben210Ben]

Hello, I'm struggling

with changing the choices of a drop down.

basically the drop down of one table (State) holds statuses called  e.g.

New

In Progress

Testing

Documentation 

etc

this is populated from another list 

in that other list (Statuses) it holds a second column called "AvailableStatuses" this is a multi selection of the items in the (Statuses) list

When I select a status, the dropdown should only show me the next available statuses

e.g. In "New" it should only show "In Progress" and "Testing" as the next options.

is this possible?

I've Tried setting the Items to 

Filter(StatusWorkFlow,State = ThisItem.State.Value).AvailableStates

but it doesn't seem to work?

Any help would be greatly appreciated 🙂 

[RandyHayes]

@Ben210Ben 

Can you expand more on "but it doesn't seem to work"?

Are you stating that the formula has an error, or that the list does not have the correct values?

[Ben210Ben · Accepted solution]

I found my Mistake..... i put Filter instead of LookUp.... I'm dumb. thanks for the help anyone that read. 

Lookup(StatusWorkFlow,State = ThisItem.State.Value).AvailableStates