cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
colbyc
Helper IV
Helper IV

Dropdown choices filter returning blank with no error

I have a dropdown that is intended to filter choices based on the value of another column, it is currently returning blank.

Filter(Choices('Area Access Requests'.'Area'), Value in Filter('Areas and Owners', DataCardValue3.Selected.Value='Facility'.Value).Title)

 

'Area Access Requests'.'Area' is the dropdown is a LookUp column, pulling from the 'Title' filed in the 'Areas and Owners' list. It should only return values from Title field where the field "Facility' is equal to another dropdown, DataCardValue3.

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
StalinPonnusamy
Super User
Super User

Hi @colbyc 

 

I assume the Facility is Choice Field. Based on the structure guess.

With(
    {_Item: Choices('Area Access Requests'.Area)},
    Filter(
        _Item,
        Value in Filter(
            'Areas and Owners',
            AreaOwner.Selected.Value = 'Facility'.Value
        ).Title
    )
)

 

StalinPonnusamy_0-1632865806063.png

 

My SP Setup

StalinPonnusamy_1-1632865935741.png

 

StalinPonnusamy_2-1632865951582.png

 

If this does not work, then please share your SP list with sample data to help to narrow down the issue.

 

View solution in original post

2 REPLIES 2
StalinPonnusamy
Super User
Super User

Hi @colbyc 

 

I assume the Facility is Choice Field. Based on the structure guess.

With(
    {_Item: Choices('Area Access Requests'.Area)},
    Filter(
        _Item,
        Value in Filter(
            'Areas and Owners',
            AreaOwner.Selected.Value = 'Facility'.Value
        ).Title
    )
)

 

StalinPonnusamy_0-1632865806063.png

 

My SP Setup

StalinPonnusamy_1-1632865935741.png

 

StalinPonnusamy_2-1632865951582.png

 

If this does not work, then please share your SP list with sample data to help to narrow down the issue.

 

Thank you! Works flawlessly.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Users online (1,232)