When we use a SharePoint lookup field in Power Apps forms, the default filter for the combo box control that is created automatically when adding a lookup field to a form will filter items only based on the primary lookup value. Sometimes it can be useful to search on more list fields, especially when we create only the custom form using Power Apps and the lookup field has projected fields configured for the list and those values are displayed on the main list.
But we can do some tricks to filter by more fields by using the StartsWith function instead of the default search.
Check this post to see how to do it.
Add the lookup source as another data source for your app/form
To achieve this, we need to add the lookup source list as another data source to the app.
The first step is to update the combo box items formula, using a new filter. Replace the default Choices formula with a Filter formula like the below (using your own fields/source list):
More About This Author
SharePoint and Office 365 Consultant/Developer always trying to get the best from Microsoft stack (Microsoft 365/Azure/Power Platform and related stuff).
Living in Ireland since 2018, I had previously worked in Brazil as a consultant/developer for Office 365, SharePoint and related technologies for almost 10 years.
- Modern Workplace9 September 2023Using SharePoint list formatting and Power Automate to create linked items (via LookUp field) in a related list
- Modern Workplace1 September 2023Using the HTTP with Azure AD connector in Power Automate to create Planner Plans and add them as Teams tabs
- Modern Workplace26 August 2023Create an Issue Tracker App using Power Apps Copilot (Preview)