Answered

Filter function column name

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello community,

A problem need someone's help, in powerapps i have created a dropdown list to show different column names based on a collection.
I type the value manually (The collection have part of same column names)

["All items","Selection one","Selection Two".......]

When i want to use the selected value from dropdown to a filter, it cannot be identify the boolean value.

Filter(collectionname,dropdown.Selected.Value = true)

In the collection,"Selection one" is a boolean column.
If i use the column name in the collection, it works.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

cwebb365 3,294 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

First glance you are filtering a collection and not filtering on a value from the collection. It should be filter(art collection, column = dropdown.selected.value )

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
doesn't work, right now what im using is manually input selection in the dropdown menu ex: lobby,corridors...

Since i have 18 selections,i need to type this 18 times
If( dropdownmenu.selected.value="Lobby",Filter(collectionname,Lobby = true), dropdownmenu.selected.value="Corridors",Filter(collectionname,Corridors = true), . . . . .

Was this reply helpful? Yes No
cwebb365 3,294 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

So each item in your drop down is a column in the collection?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

yes

Was this reply helpful? Yes No
Verified answer

v-siky-msft Microsoft Employee on at

Like
a
(3)

Report
Copy link

Link copied!
Hi @Anonymous ,

What you want is not supported, since the column name/ table name can only be hardcoded in PowerApps.

A cleaner better code, please try with Filter and Switch function as follows:

Filter(collectionname, Switch(dropdownmenu.selected.value, "Lobby", Lobby = true,"Corridors", Corridors = true )

See the Microsoft voices about your thought from here

Hope this helps.

Sik

Was this reply helpful? Yes No