Cascading Drop Down List - Formatting Difference

Hi 

can you try using the parselookup in your expression? I can show you a screenshot later when I get online. 

OK to add to my explanation:

top highlight is expression: 

middle highlight is expression: 

bottom highlight is expression: 

this is a really excellent reply, Cassy Freeman‌ -- well done!

Thanks for the parselookup examples.

Yet, how can they be referenced when using a list lookup control used for cascading drop down controls?

if you give your calculated control a name can you use that control to filter on?

It doesn't seem like it because the control "values" underneath are actually ID number #, Title, not just the title text.

So if control 1 = Set up new user, the underlying value is 15;#Setup New User

Control 2= New Starter, the underlying value is 5;#Setup New User

15#, is different to 5#, I believe that's where the issue is.

can you show me the underlying lists please?

values and settings.

Auto task settings:

Auto Task value

Ticket Type

Ticket Type Settings

OK so i have created two lists the same as yours.  I have added the controls on my form and the second dropdown is filtered by the first.

TicketType List:

AutoTask List:

Lookup settings:

Ticket Type Control:

AutoTask Control:

Form in preview:

What is different about mine and yours?

Guess, it must be my environment again...grrr.

I'll start doing some testing:

I'll build a dummy library on a different web app and see what's what.

Thanks

A

Cassy,

Thanks for all your help, biggest issue was between the seat and keyboard (me). Turns out I had my inital lookup column on the wrong list anyway, even thougth I was convinced I was right.

Drop down lists now work as expected. Now onto the next question...

Ah yayyyyy! At least it is resolved and some parts of this thread will be helpful to others anyway so not a complete loss.