I need help with a Gallery and a Table. Both are pulling different data from the same SP list using a series of three cascading dropdown fields each.
Dropdown1 = Region; Dropdown2 = City; Dropdown3 = Street; The Dropdowns are pulling data from a from a SP list called LocationLst.
Dropdown1 Item is - Sort(Distinct(LocationLst,State),Result). This returns all State name once, as desired.
Dropdown2 Item is - Filter(LocationLst, State=Dropdown1.Selected.Result). This returns all examples of each city on the list, and not in order. I'd like this filter to return all Cities once, in Ascending (A-Z) order.
Dropdown3 Item is - Filter(LocationLst, City=Dropdown2.Selected.Park). This returns all Street names on list, and not in order. I'd like this filter to return all Street names once, in Ascending (A-Z) order.
Gallery1 is pulling data from a separate SP list called EverywhereLst. The Gallery1 Item is set at - EverywhereLst, and returns all 1700 line items in the three columns set up in the Gallery, rather than just the data specific to the Street selected in Dropdown3.
Any suggestions for how to set up the three cascading dropdowns to pull only unique ascending State, City, Street data in each field, in ascending order, and have the Gallery pull corresponding data from a separate list based on the Street name selected in Dropdown3?
A lot, I know. Thanks!
