Adding a Filter for Lookup Columns made Easier with Advanced Lookup
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](https://i0.wp.com/www.inogic.com/blog/wp-content/uploads/2023/01/Adding-a-filter-for-lookup-columns-made-easier-with-advanced-lookup-1.png?resize=550%2C329)
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:
But once you turn on the settings, it will show the Advanced lookup option as seen below:
Clicking on “Advanced lookup”, will open a popup window where you can find the required record using either the Search option…
Source link
More About This Author
![](https://i0.wp.com/365community.online/wp-content/uploads/nsl_avatars/ffc40eb76be49f8a40004d26b7db36be.jpg?fit=48%2C48&ssl=1)
-
Inogic is one of the leading Microsoft Dynamics 365 ISV since 10+ years. Its flagship product Maplytics™ is a market leading certified (CfMD) geo-analytical mapping app. Maplytics empowers Dynamics CRM users across industries with the power of geographical data visualization, route optimization and along the route search with turn-by-turn directions, appointment planner, locational search by radius and shapes with drill-down filters and color-coded pushpins, heat maps, shape layers & territory management.
Inogic is renowned for its high quality and low-cost offshore development services and productivity apps like InoLink: QuickBooks + Dynamics CRM, User Adoption Monitor, Attach2Dynamics, Alerts4Dynamics Click2Export, Click2Clone, Kanban Board, SharePoint Security Sync, Lead Automation & Distribution, Map My Relationships, Auto Tax Calculator, Subscription and Recurring Billing and Marketing4Dynamics.
Array
Dyn365CE26 July 2024Enhanced ‘Selected Row’ Trigger Now Available in Power Automate
Dyn365CE25 July 2024Maplytics Optimizes Routes and Boosts Productivity for T-GREX
Dyn365CE24 July 2024Streamline Multilingual Customer Support using Language Detection Prebuilt Model in Power Automate
Dyn365CE23 July 2024WhatsApp instant messaging vs SMS texting: Deciding Your CRM Messaging Approach!