Answered

filter second drop down based on the first drop down

(0) Share

Report

Posted on by batmanMon

199

Hi! I have two drop down fields: 1.days/Weeks and 2.Duration(days). I was wondering, if is it possible to filter the second one based one the selection from the first drop down. So, if I chose Days, then I could select between 1-28. If I chose Weeks, then I can only chose between 1-4.

Days/Weeks:

Choices([@'Visitor'].Days_x002f_Weeks)

Duration on Site

Choices([@'Visitor'].Duration_x0020_on_x0020_Site)

help.pptx

All responses (2)

Answers (1)

batmanMon 199 on at

Like (0)

Report

@Re: filter second drop down based on the first drop down

@WarrenBelz Thank you very much! It works perfectly!
Verified answer

WarrenBelz 146,668 Most Valuable Professional on at

Like (2)

Report
Re: filter second drop down based on the first drop down

Hi @batmanMon ,

For the second dropdown, the Items would be

If( YourFirstDropdownName.Selected.Value="Weeks", Sequence(4), Sequence(28) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.