Thank you for visiting my site!

Home / Uncategorized / Create Cascading Drop-down 2

Create Cascading Drop-down 2

      1. Create a list to pull data from:

        add an empty field too with “-” dashes for data.


      2. Create a a form:


      3. Add the Datasource to the States
      4. Change fields from TextBox to Dropdown
      5. bring in the States:
        Items = Distinct(CascadingFormSource,State)
        Sort alphabetically Sort(something, byColumnName)
        Sort(
        Distinct(
        CascadingFormSource,
        State
        ),
        Result
        )
      6. Update = Dropdown_States.Selected.Result
      7. Value = Result

      8. Add data to second dropdown based on first dropdown selection
        Filter Cities where States equals selected State
        Filter(CascadingFormSource, State=Dropdown_States.Selected.Result)
        Distinct(
        Filter(CascadingFormSource,State = Dropdown_States.Selected.Result),City)
        Value = City


      9. Multy select
        States:
        Items: Sort(Distinct(CascadingFormSource,State),Result)
      10. City:
        Items:  Filter(CascadingFormSource, State in ComboBox_State.SelectedItems.Result)
      11. or
      12. Items:
      13. Filter(CascadingFormSource, State in Concat(State_M.SelectedItems, Value, “, “), City)Label: “Text” &
      14. Concat(ComboBox_State.SelectedItems, Result & “,”)

      15. fgfdg

ADD YOUR COMMENT