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?
Solved! Go to 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
)
Hi @golfnutt82
Yes, we can filter the Lookup list like below
Filter(
Choices(SPList.LookupColoumn),
Value in Filter(SPListLookup,Condition).ColumnName
)
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
)
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!
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:
The lookup list "Roles" looks like this below:
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
User | Count |
---|---|
251 | |
122 | |
84 | |
83 | |
67 |