Power Community

Power Community

Adding a Filter for Lookup Columns made Easier with Advanced Lookup

http://www.inogic.com/blog/wp-content/uploads/2023/01/Adding-a-filter-for-lookup-columns-made-easier-with-advanced-lookup-1.png

We are already aware of the Advanced Lookup feature that is available on any lookup column that’s on a quick create form, edit form, or dialog box. Using this, we can easily sort rows and switch between tables or views in a lookup column.

As an addition to the same, you can now use the Advanced Lookup feature in the Edit filter window as well to filter out data in the lookup column.

Let’s see how it works!

In the Power Platform Admin Center, go to Settings > Features and look for settings under the Advanced find options section.

Adding a filter for lookup columns made easier with advanced lookup

By default, the “Show advanced lookup in lookup fields within Edit filters” setting will be Off and you can turn it On as shown above.

While the setting is Off, filter the lookup columns in the Edit filters look as below:

Adding a filter for lookup columns made easier with advanced lookup

But once you turn on the settings, it will show the Advanced lookup option as seen below:

Adding a filter for lookup columns made easier with advanced lookup

Clicking on “Advanced lookup”, will open a popup window where you can find the required record using either the Search option or using the views shown on the screen:

Adding a filter for lookup columns made easier with advanced lookup

Conclusion

Editing filters for the lookup columns has now become much easier for users using the Advanced Lookup feature.

User Adoption Monitor

This post was originally published on this site

- Advertisement -spot_img

LEAVE A REPLY

Please enter your comment!
Please enter your name here

- Advertisement - Advertisement

Latest News

WhatsApp + Dynamics 365 CRM: Your Secret to Christmas Marketing Success

The holiday season is a busy time for businesses, and Christmas🎄 is no exception. With so much competition for...

More Articles Like This

- Advertisement -spot_img