Answered

Dependent Dropdown Issues

(0) Share

Report

Posted on by Quinonza

Good Morning,

I am semi-new to power apps and I am trying to design an app with 2 drop downs that are dependent on each other, I made a demo list of how my sharepoint is laid out.

I was able to get the first dropdown to show the Column Names (ABCDE,ZYXVW, and PQRST) by doing an Onstart collection, and stripping the headers into their own global variable. Now the second dropdown is the issue, as I have it now if I code in one of the columns for the second dropdown it will show correctly (Unassigned Working Unassigned Unassigned Etc.) going down the column.

My issue is that when I try to use the initial dropdown selection of (ABCDE,ZYXVW, and PQRST) it will only show the first column coded into the second dropdown IF statement. If I select ZYXVW when I have coded ABCDE first in the Items Property it wont show anything in the second dropdown for ZYXVW or PQRST.

I would also like to request help to concatenate the first column (Title) into which ever column is selected in the second dropdown, I was able to achieve it with using a single column.

Using

I thought something like this would work nested into

Any help would be greatly appreciated

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@Quinonza - I do not understand what you're trying to do.

If I am reading this correctly, you have taken the column names of a SharePoint list and added them as items in a Dropdown control. Based on the selected column name in that Dropdown control, you want to return the values associated to the selected column in another Dropdown control?
Quinonza 14 on at

Like
a
(0)

Report
Copy link

Link copied!

yes exactly, sorry if my explanation was a little vague or incorrect terminology. Now including that I would also like to concatenate those results with the first column so I would end up with the second drop down control showing:
1 Unassigned
2 Working
3 Sleeping
4 Unassigned
for the respective selections from the first dropdown of column selection. Thanks for any help provided 🙂
Verified answer

Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@Quinonza - I would ignore using Collections and instead apply something like below into the Items property of your Dropdown control. Note the the AddColumns function is not delegable:

With( { _ABCDE_column: ShowColumns( AddColumns( 'Your List', "Value", Concatenate( Title, " ", ABCDE ) ), "Value" ), _ZYXVW_column: ShowColumns( AddColumns( 'Your List', "Value", Concatenate( Title, " ", ZYXVW ) ), "Value" ), _PQRST_column: ShowColumns( AddColumns( 'Your List', "Value", Concatenate( Title, " ", PQRST ) ), "Value" ) }, Switch( Dropdown1.Selected.Value, "ABCDE", _ABCDE_column, "ZYXVW", _ZYXVW_column, "PQRST", _PQRST_column ) )
Quinonza 14 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks a bunch that worked perfectly, have a great rest of your week. 🙂