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

Filter a lookup field

Hello,
I have a form that contains a field where a user can select from a lookup a role. However, once the list is fully populated with Roles there will be close to 1200 items. Is there a way to filter the lookup control?  

golfnutt82_0-1634150997247.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
StalinPonnusamy
Community Champion
Community Champion

Hi @golfnutt82 

 

Sample

IssueTracker - SPList

SingleEvent - LookupColumnName

EventItenary - Another SP List which SingleEvent is having lookup

Session type - Choice field to filter

Filter(
    Choices([@IssueTracker].SingleEvent),
    Value in Filter(
        EventIItinerary,
        'Session type'.Value = "Talk"
    ).Title
)

 

View solution in original post

5 REPLIES 5
StalinPonnusamy
Community Champion
Community Champion

Hi @golfnutt82 

 

Yes, we can filter the Lookup list like below

Filter(
       Choices(SPList.LookupColoumn),
       Value in Filter(SPListLookup,Condition).ColumnName
)

 

StalinPonnusamy
Community Champion
Community Champion

Hi @golfnutt82 

 

Sample

IssueTracker - SPList

SingleEvent - LookupColumnName

EventItenary - Another SP List which SingleEvent is having lookup

Session type - Choice field to filter

Filter(
    Choices([@IssueTracker].SingleEvent),
    Value in Filter(
        EventIItinerary,
        'Session type'.Value = "Talk"
    ).Title
)

 

View solution in original post

Hi Stalin,
Thanks for your input regarding my question.
When attempting to use your solution I am receiving an error.
I am somewhat new to Power Apps so I am sure I am missing something.

golfnutt82_0-1634212041125.png

I really appreciate your help!

StalinPonnusamy
Community Champion
Community Champion

Hi @golfnutt82 

 

Filter(
    Choices([@'Access Requests'].'LU_Role Name'),
    Value in Filter(
        LURoleSPList,
        Filter Condition
    ).Title
)

 

2 things you need to change on this

LURoleSPList - Name of the SP list where Roles are stored

Filter Condition - What you want to filter from the Role SP list

 

In my example, filtering session type = Talk

 

If still having a problem, Please share your SharePoint Datasource structure, so that we can get a solution

 

Hi Stalin,
I will make the changes and let you know.
Here are my data sources below:

golfnutt82_1-1634217462962.png

The lookup list "Roles" looks like this below:

golfnutt82_2-1634217794663.png

 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (2,634)