-
-
- Create a list to pull data from:
add an empty field too with “-” dashes for data.
- Create a a form:
- Add the Datasource to the States
- Change fields from TextBox to Dropdown
- bring in the States:
Items = Distinct(CascadingFormSource,State)
Sort alphabetically Sort(something, byColumnName)
Sort(
Distinct(
CascadingFormSource,
State
),
Result
) - Update = Dropdown_States.Selected.Result
- Value = Result
- 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
- Multy select
States:
Items: Sort(Distinct(CascadingFormSource,State),Result) - City:
Items: Filter(CascadingFormSource, State in ComboBox_State.SelectedItems.Result) - or
- Items:
- Filter(CascadingFormSource, State in Concat(State_M.SelectedItems, Value, “, “), City)Label: “Text” &
- Concat(ComboBox_State.SelectedItems, Result & “,”)
-
- fgfdg
- Create a list to pull data from:
-