Filter dropdown with a column name equal to the value selected in another dropdown

(0) Share

Report

Posted on by lohaninarayan

Hi All,

I am having a weird issue filtering dropdown based on value from another dropdown.

Basically I have 2 SharePoint lists with data on 1st list's first column being column headers of 2nd list.

first list

Second list

I was unable to clip the whole list but basically, value from first list's first column is being column headers in second list.

Now I have 2 drop downs in my app, first dropdown listing the first columns value 2478, 2480 etc, and second should list the first column's value from 2nd list, filtering the column name equal to selected in first dropdown does not have value "Blocked".

I know it is confusing, so I am creating a scenario here.

if 2800 is selected in first dropdown, second dropdown should list 1101001 as an option because column 2800 does not have value, and should not list 1101002 as an option because column 2800 has Blocked value.

I feel like I am missing a very simple thing here.

Please do comment if you have any suggestion or any workaround.

Regards

Narayan

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like (0)

Report

Hi @lohaninarayan ,
I don't think we can reference column names dynamically.
You will have to use Switch/If statement -
Try adding below formula in Items property of Dropdown2 -
Switch(Dropdown1.Selected.Value, "2502", Filter(List2, 2502Column.Value <> "Blocked").Title, "2800", Filter(List2, 2800Column.Value <> "Blocked").Title)

Was this reply helpful? Yes No
lohaninarayan on at

Like (0)

Report

Hi Nandini,

Thanks for taking time to find the solution. I don't think I can implement your solution as I have more than 50 columns like 2502 or 2800. I will still give it a try when I get a time, at the same time I will welcome if you have any other suggestion.

Regards
Narayan

Was this reply helpful? Yes No