Populate a Dropdown Based on the Value of Another Dropdown

(0) Share

Report

Posted on by vsolanon

146

Hi experts!

I would like to populate the value selected in one dropdown into a second dropdown, however, it is not working as expected.

I have an EditForm which is connected to an SP List. The SP list has two Choice columns "Segment and ValidatedSegment" and both have the same information on it. I would like that when the user selects one option from the Segment dropdown, the same value selected populate in the second dropdown. Kindly note the second dropdown will be hidden.

Segment choice column with options: Option1, Option2, Option3, Option4...

ValidatedSegment choice column with options: Option1, Option2, Option3, Option4...

I have tried with the below formula without any success, I am wondering if this might be related due to the Items property,

On the Default property of the DataCardDropdown2: DataCardValue25.Selected

Thank you in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

MarvinBangert 1,924 Most Valuable Professional on at

Like (1)

Report
Hey @vsolanon
first: would it be possible to create the column "ValidatedSegment" in SharePoint as a calculated column? Then you are able to show the same value as in segment (depends on what you want to do with this column value).

otherwise: you need a dropdown to achieve this. A dropdown list just shows the values of a table, a combination field (default action if you add a SharePoint Field within a form) shows the datasets the user can select.
Select one of the items in the ValidatedSegment_DataCard and then add a dropdown field within the DataCard (make sure you unlocked the settings):
Change the Dropdown7.Items formula to
Filter(Choices(List.ValidatedSegment); Value = DataCardValue2.Selected.Value)
DataCardValue2.Selected.Value is your Segment DataCard combination field (DataCardValue25.Selected as from your description).
This should work fine, if you select a Segment the dropdown should show the same value:
Then you can delete the combination field, after that you will see some errors on your ValidateSegment DataCard. Just update the functions with the dropdown:
Example: ValidatedSegment_DataCard.Update from
DataCardValue10.Selected
to
Dropdown7.Selected
If you Submit your form, the value should be visible in your SharePoint list:

Hope this will help you! 🙂

Regards,
Marvin

Was this reply helpful? Yes No
vsolanon 146 on at

Like (0)

Report

Hi @MarvinBangert , thank you very much! It work like a charm!

I had to create it as a dropdown list since the user will be able then to go and update this field (ValidatedSegment) 🙂

Was this reply helpful? Yes No