[ad_1]
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):
Filter(Cars,
...[ad_2]
Source link