{"id":33645,"date":"2023-01-09T16:08:19","date_gmt":"2023-01-09T10:38:19","guid":{"rendered":"https:\/\/www.inogic.com\/blog\/?p=33645"},"modified":"2023-01-13T14:16:42","modified_gmt":"2023-01-13T08:46:42","slug":"adding-a-filter-for-lookup-columns-made-easier-with-advanced-lookup","status":"publish","type":"post","link":"https:\/\/www.inogic.com\/blog\/2023\/01\/adding-a-filter-for-lookup-columns-made-easier-with-advanced-lookup\/","title":{"rendered":"Adding a Filter for Lookup Columns made Easier with Advanced Lookup"},"content":{"rendered":"

We are already aware of the Advanced Lookup<\/a>\u00a0feature that\u00a0is 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.<\/p>\n

As an addition to the same, you can now use the Advanced Lookup<\/strong><\/a>\u00a0feature in the Edit filter<\/strong> window as well to filter out data in the lookup column.<\/p>\n

Let\u2019s see how it works!<\/p>\n

In the\u00a0Power Platform Admin Center,\u00a0<\/strong>go to\u00a0Settings > Features\u00a0<\/strong>and look for settings under\u00a0the Advanced find options<\/strong> section.<\/p>\n

 <\/p>\n

\n

\"Adding<\/p>\n

By default, the \u201cShow advanced lookup in lookup fields within Edit filters<\/strong>\u201d setting will be Off<\/strong> and you can turn it On<\/strong> as shown above.<\/p>\n

While the setting is Off<\/strong>, filter the lookup columns<\/strong> in the Edit filters<\/strong> look as below:<\/p>\n

\"Adding<\/a><\/p>\n

But once you turn on the settings, it will show the Advanced lookup<\/strong> option as seen below:<\/p>\n

\"Adding<\/a><\/p>\n

Clicking on \u201cAdvanced lookup<\/strong>\u201d, will open a popup window where you can find the required record using either the Search<\/strong> option or using the views shown on the screen:<\/p>\n

\n

\"Adding<\/p>\n

Conclusion<\/strong><\/h2>\n

Editing filters for the lookup columns has now become much easier for users using the Advanced Lookup feature.<\/p>\n

\"User<\/a><\/p>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

We are already aware of the Advanced Lookup\u00a0feature that\u00a0is 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\u00a0feature\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":13,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[16,19,2361],"tags":[2350,1351],"class_list":["post-33645","post","type-post","status-publish","format-standard","hentry","category-dynamics-365","category-dynamics-crm","category-technical","tag-advanced-lookup","tag-power-platform"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/33645","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/comments?post=33645"}],"version-history":[{"count":0,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/33645\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media?parent=33645"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/categories?post=33645"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/tags?post=33645"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}