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.
- ModernWorkplace2022.06.08Updating list views JSON formatters for a SharePoint list using Power Automate
- ModernWorkplace2022.05.19SharePoint lists custom View and Edit Buttons using JSON Formatting
- ModernWorkplace2022.05.14Power Apps: Patch data from the Office 365 Users connector to a SharePoint multi-user field without using collect
- ModernWorkplace2022.04.30Glossary View formatting: JSON Template including Related Link