Advanced find is well-known, but have you heard of advanced lookup?

Advanced Lookup

We can quickly search for, explore, and pick entries to populate a lookup field using all of the available filters. This offers an exciting lookup experience since we can see all of the columns in a view to find the proper record. To display records, the columns can also be sorted.

What do you think about this?

At the Power Platform Admin Center, enable Advanced Lookup.

Navigate to the Admin Center of the Power Platform.

Select the environment

Choose Settings > Product > Behavior

The default lookup behavior is Off

Explore

With advanced lookup, we can see the results as you type. View results without having to retype your query by switching to another view or an entirely new table.

• To locate the row you’re looking for, type search text into the search box. The search text is kept when you switch views.
• Change views: Select a suitable view.
• Sort: To sort in ascending or descending order, use the arrow at the top of any column.
• Only my records: Only the rows that you own will be displayed.
• Create a new record: Opens the quick create form, which allows you to add a new table row. The advanced lookup grid will refresh and show the newly added entry when you save the new row.

Search by typing ahead

With advanced lookup, we can see the results as you type. View results without having to retype your query by switching to another view or an entirely new table.

Features

• Without sacrificing context, explore data.
• Filter the information.
• Multiple records can be looked up with fewer clicks. For instance, Party List

Party List Advanced Lookup

Using fewer clicks to look for several records without losing context.