I am facing a peculiar problem related to my dropdown. I have a cascading list of dropdowns namely:
Region, SubRegion, State, County
The user needs to select region first followed by the values in subsequent dropdowns. All of this data flows down from a SQL table.
Region shows values as Canada, Southern US, Northern US.
The query that I use to populate the Region dropdown is :
My problem is that when I choose the value Canada and proceed and come back to this screen, it does not show me Canada again - It shows only Southern US, Northern US.
If i choose, Southern US and proceed and come back to this screen, it then shows me the value in dropdown as only Northern US
and if i choose, Northern US and proceed and come back to this screen, it shows me only this value available in dropdown.
Nothing is changing at the database end. If i refresh the application, I start seeing all the values again.
I am not sure what is causing this problem.
When I checked the properties, it shows the parent as the Subregion dropdown and it is not showing me RegionDropdown as an option.
Can anyone please help?
It`s a strange behaviour.
You can try collection on it and test.
When you say that you come back to the screen and the previously selected value is not shown, I have a few questions:
Check it out!
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand