Answered

Filter a lookup field

(0) Share

Report

Posted on by golfnutt82

1,362

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?

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @golfnutt82

Yes, we can filter the Lookup list like below
Filter( Choices(SPList.LookupColoumn), Value in Filter(SPListLookup,Condition).ColumnName )
Verified answer

StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
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 1,362 on at

Like
a
(0)

Report
Copy link

Link copied!

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 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
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 1,362 on at

Like
a
(0)

Report
Copy link

Link copied!

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: