web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Show visible rows in d...

Power Apps

Answered

Show visible rows in data table based on drop down selection

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

Hi, asking for help on the following functionality. Would like users to select department from dropdown, and then only see the visible rows for which there is an "x" in the column. (pic and code below)

Am able to make the dropdown work when I hard code one of the Department names directly into the formula in for DataTable4 (Items) - Filter(DeptList,Not(IsBlank(Lighting)))

So I am trying to change the hard-coded "Lighting" to the selected text from the Dropdown - here is my current attempt but it is not working> Filter(DeptList,Not(IsBlank(Dropdown1.Selected)))

Also, not sure if I need to have any code in the drop down for OnSelect or OnChange? Thank you!!

Dropdown = Dropdown1

Data table = DataTable4=DeptList

powerapp example.jpg

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Anonymous

You cannot reference column names like that in PowerApps. To achieve what you are trying to do, use the following filter formula:

Filter(DeptList, Switch(Dropdown1.Selected.Value, "Lighting", !IsBlank(Lighting), "Tools", !IsBlank(Tools), "Garden", !IsBlank(Garden) ) )

I hope this is helpful for you.
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Thanks Randy. Apologies for delayed response but had some difficulties getting with my access. Solution worked with one minor difference - for selected.value - I needed to change "value" to the actual data in the dropdown for it to work

Filter(DeptList,
Switch(Dropdown1.Selected.Dept_x0020_Name,
Lighting", !IsBlank(Lighting),
"Tools", !IsBlank(Tools),
"Garden", !IsBlank(Garden)
)
)

Join the conversation