Answered

Dependent Dropdown problems

(0) Share

Report

Posted on by BenBennett321

114

I have a problem with dependent dropdowns. I have a form (FormA) that will write to Sharepoint List A, but I have two dropdowns Dropdown1 and Dropdown 2, Dropdown 2 being dependent on Dropdown1

The items properties of these dropdowns look at another data source (an Excel data source called Income_type)

when dropdown one is selected which looks at column 'Income_Type' (in data source Income_type) dropdown 2 should display 'Income Codes and Names' (From data source Income_type).

Items property of Dropdown 1: Sort(Distinct(Income_type,'Income type'),Value)

Update property of Dropdown 1: Dropdown1.Selected.Value

Items property of Dropdown 2: Filter('Income_type', 'Income type' = Dropdown1.Selected.Value)

Update property of Dropdown 2: Dropdown2.SelectedText.Value

this is the error code in Dropdown 2:

Do let me know if you need any more information.

Many thanks in advance

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Rajkumar_M 3,741 Super User 2025 Season 2 on at

Like (0)

Report
Hi @BenBennett321

Refer this link : Create Cascading (Dependent) Dropdowns In Power Apps (matthewdevaney.com)

Items property of Dropdown 2:

Filter('Income_type', 'Income type' = Dropdown1.Selected.Result)

Thanks!

If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,084 Most Valuable Professional on at

Like (1)

Report
Hi @BenBennett321 ,

Your issue is here with the Items of the second dropdown

Filter( 'Income_type', 'Income type' = Dropdown1.Selected.Value )

is that the output will not be .Value, but rather the field name it is displaying. So the Update would be (use your field name)

Dropdown2.Selected.FieldName

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
BenBennett321 114 on at

Like (0)

Report

Thanks for this Warren, this needed to be fixed, but still didn't fix the issue, until I removed my Excel data source, removed any spaces in column headings and re-linked it to my app. then voila! it worked.

I realise Excel isn't a great data source, but in this first stage of implementation we're going to need it until staff get more used to Sharepoint lists.

Thanks again for your direction.

Was this reply helpful? Yes No