Filter a lookup field

[golfnutt82]

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?  

[StalinPonnusamy]

Hi @golfnutt82 

Yes, we can filter the Lookup list like below

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

[StalinPonnusamy · Accepted solution]

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
)

[golfnutt82]

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.

I really appreciate your help!

[StalinPonnusamy]

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

[golfnutt82]

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

The lookup list "Roles" looks like this below: