cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
justtegan
Level: Powered On

Filter Dropdown Values

Okay, time to concede defeat before I throw my computer across the room. 

 

I have a dropdown (Dropd_projects) sorted by the column project_name on the table projects as follows:

 

SortByColumns(projects.project_name, "project_name", Ascending)

 

The projects table has another column, project_status. I want to filter the items in dropd_projects to include the project_name only for projects that have "Active" as the value in the project_status column.

 

This seems like it be so simple, which is why it's making me so crazy that I cannot figure it out. . . 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Filter Dropdown Values

@justtegan 

Try this code.

SortByColumns(
    Filter(
        projects,
        Status.Value = "Active"
    ).project_name,
    "project_name",
    Ascending
)

 

My assumption is Status will be a Choices type column in SharePoint.  If its not a Choices column change Status.Value to Status.

 

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

View solution in original post

2 REPLIES 2
Super User
Super User

Re: Filter Dropdown Values

@justtegan 

Try this code.

SortByColumns(
    Filter(
        projects,
        Status.Value = "Active"
    ).project_name,
    "project_name",
    Ascending
)

 

My assumption is Status will be a Choices type column in SharePoint.  If its not a Choices column change Status.Value to Status.

 

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

View solution in original post

justtegan
Level: Powered On

Re: Filter Dropdown Values

Thank you so much!

Helpful resources

Announcements
thirdimage

Power Apps Super User Class of 2020

Check it out!

thirdimage

New Badges

Check it out!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors
Users online (6,185)