Answered

Cascading Dropdown From DIfferent SharePoint List

(0) Share

Report

Posted on by AkshayManke

Hi,

We have developed an PowerApp based on a SharePoint list. The list is having fields like Name, ID, Score, with some Test Fields. I want to add three new fields which would contain Region, Country and Contact. There can be multiple countries in one region and multiple contacts in each country as per below.

Region	Country	Contact
Africa	South Africa	User A
Africa	Nigeria	User B
Asia	Korea	User C
Asia	Korea	User D

……… and so on.

For the Region, Country and Contact I need the cascading dropdown for example, If user Select Africa then, in the Country only South Africa and Nigeria should appear. If Nigeria is selected then User B to be appeared.

What i was thinking that, i will create a different list in SharePoint and then will configure with the main list.

So i have two questions.

How can i create Cascading Dropdown from another list (as 'Country Mapping List')?

How can i add the values in to the Main list which was derived from the 'Country Mapping List'?

Can anyone please help with detailed steps?

Regards,

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

PowerAddict 7,316 Most Valuable Professional on at

Like (1)

Report
Here is a small example that I set up (you will need to make some adjustments based on your lists).

I have a SP list called Student Scores. For now, it only has 2 columns - Title and StudentUser (I will tell you the data type of this column later). I added 2 records to this table - Student 1 and Student 2 in the Title fields

I have another SP list called Country Mapping List. It has 4 columns - Title, Region, Country, User. The data in this table is the same as you have outlined in your question.

The StudentUser column in Student Scores list can be a lookup to the Country Mapping List's User column. Or you can simply set this to Text if the User records in your example are text values. I am assuming

In the canvas app, I added a gallery of Student Scores, just so I could see the values getting added/updated. This isn't necessary. You can always go back to the SP list to verify.

I then added 3 combo boxes with the following properties:

Region combo box Items property - Distinct('Country Mapping List',Region)

Country combo box Items property - Distinct(Filter('Country Mapping List', Region = ComboBox1.Selected.Result), Country)

User combo box Items property - Filter('Country Mapping List', Country = ComboBox2.Selected.Result).User

The combo boxes behave the way you would expect to. And once you have the User selected, you can simply Patch to update the Student Scores list with the selected User.

Here is a small demo (I could have done it slightly better by resetting the combo boxes so the old values get cleared but hopefully this gives you an idea):

Let me know if this helps.

---
If you like this reply, please give kudos (Thumbs Up). And if this solves your problem, please mark this reply as a solution by selecting Accept as Solution. This makes it easier for others to find answers to similar questions.

Thanks!

Hardit Bhatia

Microsoft Business Applications MVP

Blog | Twitter | LinkedIn | Facebook | YouTube | Email

Was this reply helpful? Yes No
AkshayManke 2 on at

Like (1)

Report

Hi @PowerAddict @Hardit,

I am trying the solution suggested by you and will get back on the results shortly.

Regards,
Akshay

Was this reply helpful? Yes No