Answered

Dependent Drop Downs

(0) Share

Report

Posted on by bigbenson14

So I’ve got two drop down filters, one of the drop downs (ddNPS) looks at the Nominal Pipe Size (NPS) column in the ‘Schedule2’ table imported as a data source from excel:

Distinct(Schedule2,NPS)

This works fine.

I want my second drop down (ddSched) to show only the pipe schedules (thicknesses) specific to the size selected in the ddNPS. These thicknesses are documented in the same data source table:

Filter(Schedule2,NPS=ddNPS.SelectedText.Value)

This does not work fine.

ddSched only shows one record in the table. The dropdown should show the entire row of records applicable to that pipe size selected in ddNPS.

I’ve tried to summarise an example, see below – once I select 4” from the ddNPS I want to see 20,40 & 60 in the ddSched drop down.

I’m not sure I’m explaining this very well but I’d appreciate any help nonetheless.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@bigbenson14

Filter(Schedule2,NPS=ddNPS.Selected.Result)

Distinct function creates a single column table with the field name "Result"

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi@bigbenson14,

Do you want yo display the other data in a row as a drop down list in the ddSched based on the c?

Could you please share a bit more about the scenario, split a record into a single column?

If I understand you correctly, you want to display all the other items in one row based on ddNPS selected.

I think you should try the Split() function and Concat and Concatenate function.

Set the OnChange property of the ddNPS selected as below:

ClearCollect( test, Split( Concatenate( LookUp( Table1, NPS = Dropdown1.SelectedText.Value ).Sched, ", ", LookUp( Table1, NPS = Dropdown1.SelectedText.Value ).Test1, ", ", LookUp( Table1, NPS = Dropdown1.SelectedText.Value ).Test2 ), ", " ) )

Set the Items property of the ddSched as below:

test

Note: Table1 is my Excel table.

Hope it could help.

Regards,

Qi

Was this reply helpful? Yes No
bigbenson14 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you both for replying.

You are correct Qi, i want to select the value of NPS and see the rest of the row in the second drop down ddSched.

I've done as you said but i'm getting an error within the Concatenate function, it's saying the function expects either text or a table column of text type.

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi@bigbenson14,

Please post your formula.

I have tested on my side that the formula works great. I use the Lookup().ColumnName function to lookup for the specific item that belongs to a certain column based on the ddNPS selected.

Please check if you have missed something important.

Check the GIF for reference.

Regards,

Qi

Was this reply helpful? Yes No
bigbenson14 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the replies Qi - Appreciate your help.

Was this reply helpful? Yes No