I have a table of selections which is going to be two dropdown lists in PowerApps.
First drop down, the user would select what country it is.
The the second drop-down would be what States/Province it is.
The data/source table looks like this:
First drop-down, I have the items formula = Distinct('Source Table',Country)
Second drop-down, I have the item formula = Distinct(Filter('Source Table', Country = Edit_Input_Country.Selected.Value), States)
even though the formula isn't showing any error, I am not seeing any options (i.e., when I select Canada, options of "AB", "SK" or "QC" isn't showing up).
Any help would be great, thank you.
Go to Solution.
Solved my own question.
Second drop-down formula in Items:
Distinct(Filter('Source Table', Country in Input_Country.SelectedText.Value),'States')
View solution in original post
Join us for the next call on August 17, 2022 at 8am PDT.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.