Unanswered

Dropdown columns

(0) Share

Report

Posted on by BC User

Hello!

I have two dropdown columns. How do I set the values in dropdown column two based on the first one?
For example:
If the first dropdown column contains "XXX", set the values in dropdown column two to: XXX_1, XXX_2, XXX_3, XXX_4?

Categories:

Building Power Apps

All responses (2)

Answers (0)

Sort by

rsaikrishna

3,703 on at

Like (0)

Report

Copy link

Link copied!

@Powerapps12345

I am assuming you are using SharePoint as your data source.

When we have dependency of the columns, we need to maintain the dependency mapping in a separate SharePoint list.

In the mapping list "CountriesCities", maintain the following columns:

Country	City
US	New York
US	Chicago
India	Delhi
India	Mumbai

In your data connections, add the above list as well.

First Drop Down: Distinct(CountriesCities,Country)

Second Drop Down: Filter(Countries, Country=FirstDropDown.Selected.Value).City

I hope this will be helpful. Please let us know if you have any questions here.

Regards

Krishna Rachakonda

If this reply helped you to solve the issue, please mark the post as Accepted Solution. Marking this post as Accepted Solution, will help many other users to use this post to solve same or similar issue without re-posting the issue in the group. Saves a lot of time for everyone.

BC User 50 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,
I am not using Sharepoint for the first dropdown column, I am using Business Central. Therefore I don't know the value in dropdown column 1 (it is order numbers from Business Central). Somehow I need to set the value to "X", because I don't know it in advance. For example:
If I create a new order in Business Central with the order number 1000, the first dropdown column in my power app will have the value 1000. Then I want the second dropdown values to be : 1000_1, 1000_2, 1000_3 and so on. Do you understand how I mean? 🙂 @rsaikrishna