You’re offline. This is a read only version of the page.
8
Hi All,
I am new to power apps I am designing a app there are four columns Business Line,Country,Region,State.
Business Line and Country is dependent on each other when any business line is selected it should show the country related to specific business line.Meanwhile Region and State is dependent on each other when any Region is selected it should show the State related to specific Region.(cascading dropdowns)
Example :(4 columns-Business Line,Country,Region,State)
BusinessLine Country Region State
Metals Finland Asia Bihar
Metals Austria Europe Paris
Metals Germany Europe Paris
Data Center Finland Europe Bihar
Data Center UK Asia Paris
Data Center Germany Asia Bihar
If I select any BusinessLine it is showing the Country associated with that BusinessLine. Now if I select any region it is not showing the state associated with that Region.Please help All suggestions are welcome.Thank you in advance!!
Regards,
Anony_mous
Hi @Anon_ymous21,
Let's assume your 4-column collection is called colBusinessLines, and your cascading dropdown controls are named drpBusinessLine, drpCountry, drpRegion, and drpState. Try setting the following properties - this is a starting point, you may need some trial-and-error.
drpBusinessLine Items property:
Share
Report
All responses (
Answers (
SortByColumns(
Distinct(colBusinessLines, BusinessLine),
"Value"
)
drpCountry Items property:
SortByColumns(
Distinct(
Filter(colBusinessLines, BusinessLine = drpBusinessLine.Selected.Value),
Country
),
"Value"
)
drpRegion Items property:
SortByColumns(
Distinct(
Filter(colBusinessLines, Country = drpCountry.Selected.Value),
Region
),
"Value"
)
drpState Items property:
SortByColumns(
Distinct(
Filter(colBusinessLines, Region = drpRegion.Selected.Value),
State
),
"Value"
)
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Follow me online.
