web

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

News and Announcements icon

Power Platform CommunityForums Power Apps PowerApps filter on co...

Power Apps

Answered

PowerApps filter on columns from Sharepoint

(0) Share

Report

Report

Posted on by Sergidt

2

Hello there,

I'm trying to apply a filter to a form in PowerApps, my list has only two columns, this is how the list looks like:

Names Status

Test1 Active

Test2 Inactive

Test3 Active

Test4 Inactive

I want to show in the Name.Datacard and in a Combobox, the names which status is Active. I'm trying to apply this formula but it's not working:

Filter(Choices([@TestList_1].Names), Value in Filter(TestLists_1, Status.Value = "Active").Names)

Both of my colums are set to be Choice, status can't add values manually, Names column allows to add values manually

Thanks in advance for your time and support!

Categories:

Building Power Apps

All responses Img

All responses (3)

Answers Img

Answers (1)

Sort by

Verified answer

Drrickryp Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@Sergidt

Check out @RezaDorrani 's video here: https://www.youtube.com/watch?v=pn50AKn3Q1Y . BTW, I don't use choice columns, just single line of text and I either hard code the controls or use a separate table as the input for dropdowns and comboboxes.
JeffC1 27 on at

Like
a
(0)

Report
Copy link

Link copied!
The items property of the ComboBox should be set to a datasource that is filtered for active. e.g.:

The data Source may be a table or a collection that has cached the table. If the items of the ComboBox points to a collection, filter the table upon the creation of the collection:

ClearCollect( colTableName, Filter( TableName, Status = "Active") )

Then set the items property of the ComboBox to colTableName.

If you're pointing the ComboBox items directly to a table then set items to:

Filter( TableName, Status = "Active" )
JeffC1 27 on at

Like
a
(0)

Report
Copy link

Link copied!

I will also suggest next time that you consider using a Boolean field type for the status (if you only have active and inactive). The field name could then be Active and the value a Boolean. This will simplify the "coding" and run more efficiently from an analysis standpoint.

Join the conversation