Convert SharePoint Choices fields to Cascading drop downs

(0) Share

Report

Posted on by OK29

388

Hi,

I have a SharePoint list A with choice fields. I am creating Custom form using Power apps for SharePoint list and trying to convert choice fields to cascading drop downs in power apps but I am not sure how to do it.

Choice fields are as follows.

Field A with following choices

AHM

BANG

CHE

CAL

DEL

FAR

GANG

HYD

JAI

and So on..

Field B With following Choices

North

South

In Powerapps

if I select HYD in field A then Field B should show only "South"

If I select DEL in Field A then Field B should filter to "North"

I have created another list B to show relationship between city and region. So how to convert choice fields to conditional cascading dropdowns? Any help would be greatly appreciated.

List B is as shown in Below

City	Region
AHM	North

BANG	South

CHE	South

CAL	North
COI	South
DEL	North

FAR	North

GANG	North

HYD	South
KOL	South

Thank you.

Categories:

Building Power Apps

All responses (1)

Answers (1)

Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @aaedla :

Do you want to get something like this?

I assume City and Region are two text columns.

1\I assume there are two combo boxes (ComboBox1 / ComboBox2)

ComboBox1

Items

Choices(ListA.FieldA)

OnChange

Reset(ComboBox2)

ComboBox2

Items

Choices(ListA.FieldB)

DefaultSelectedItems

LookUp( Choices(ListA.FieldB), Value = LookUp( ListB, ComboBox1.Selected.Value = City ).Region )

Best Regards,

Bof