web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps How to add a Cascading...

Power Apps

Answered

How to add a Cascading Dropdowns in Power App that link to a SharePoint List

(0) Share

Report

Report

Posted on by eddie_2014

I have 2 SharePoint List

List A has 11 Column -> From "Column I" to "Column XI" , Column V and Column VI is a [Choice Type] Column and there is a independent relationship between the 2 columns.

I want to build an PowerApp with an edit form to add record to List A.

I try to make a secondary list (List B) with the information of "Column V" and "Column VI"

I make to know how can I add a Cascading Dropdowns in an the edit form

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @eddie_2014,

Do you mean that the Stage and Tower Name column are both Choice type instead of LookUp type?

Since you have created the corresponding relationship between Stage and Tower Name, a Choice type for them in List A makes no sense, LookUp is better.

Anyway, I just assume that both of them are Choice type and you configure the choices manually in the column settings.

1). Set both of the dropdown controls as Choices(ListA.Stage) and Choices(ListA.TowerName)

2). Set the DefaultSelectedItems property of the TowerName dropdown control as below:

Filter(Choices(ListA.SiteName),Value in Filter(ListB,Stage=dropdown_Stage.Selected.Value).TowerName)

Was this reply helpful? Yes No

Join the conversation