{"id":6141,"date":"2024-10-15T09:49:26","date_gmt":"2024-10-15T09:49:26","guid":{"rendered":"https:\/\/www.aegissofttech.com\/insights\/?p=6141"},"modified":"2026-09-15T09:36:01","modified_gmt":"2026-09-15T09:36:01","slug":"filter-lookup-field-dynamics-365","status":"publish","type":"post","link":"https:\/\/www.aegissofttech.com\/insights\/filter-lookup-field-dynamics-365\/","title":{"rendered":"How to Filter Lookup Fields in Dynamics 365 CRM"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">You can filter lookup fields in Dynamics 365 CRM using two main methods: Related Records Filtering and <strong>JavaScript<\/strong>. Related Records Filtering is the simpler no-code option when your tables already have defined relationships. JavaScript gives you greater control when you need multiple conditions, dynamic filtering, or cascading lookup fields.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">For example, when a sales rep selects United States as the country, the City lookup should display only cities from the United States\u2014not records from every country in the CRM.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Filtering lookup fields makes forms easier to use, reduces incorrect selections, and helps maintain cleaner CRM data. In this guide, we\u2019ll explain both methods step by step and show you how to troubleshoot common lookup filtering issues.<\/p>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\"><strong>Key Takeaways<\/strong><\/p>\n\n\n\n<div style=\"border:1px solid #000; padding:15px; margin:20px 0;\">\nThis is all you need to know about the filter lookup field in Dynamics 365:\n<ul style=\"margin-top:10px; line-height:1.6;\">\n<li>Lookup fields in Dynamics 365 CRM connect related entities like Accounts, Contacts, and Opportunities for better data relationships<\/li>\n<li>Unfiltered lookups can cause clutter, confusion, and errors when users select unrelated records<\/li>\n<li>You can filter lookup fields using Related Records Filtering (no-code) or JavaScript filtering (code-based), depending on complexity<\/li>\n<li>Testing and event configuration are key, especially enabling OnLoad and OnChange handlers in form properties<\/li>\n<li>Common issues include missing relationships, incorrect schema names, and empty results, which can be fixed through careful setup and validation<\/li>\n<\/ul>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\">What are Lookup Fields in Dynamics 365 CRM?<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Lookup fields in Microsoft Dynamics 365 CRM are form controls that link one record to another by referencing a related entity. They create relationships between data tables, like connecting a Contact to an Account or linking an Opportunity to a specific Product.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">When users click a lookup field, they see a searchable list of records from the target entity. Selecting an entry establishes a connection that maintains referential integrity across your CRM database.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Methods to Filter Lookup Fields in Dynamics 365 CRM<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">There are two main ways to filter lookup fields in Dynamics 365 CRM: no-code filtering using Related Records and code-based filtering using JavaScript. The right method depends on your table relationships, filtering requirements, and the level of control you need over the records displayed.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">1. No-Code Filtering Using Related Records<\/h3>\n\n\n\n<figure class=\"wp-block-image size-large\"><img fetchpriority=\"high\" decoding=\"async\" width=\"1024\" height=\"683\" src=\"https:\/\/www.aegissofttech.com\/insights\/wp-content\/uploads\/2024\/10\/No-Code-Filtering-Using-Related-Records-1024x683.webp\" alt=\"No-code filter lookup field in Dynamics 365\" class=\"wp-image-21159\" title=\"No-code filter lookup field in Dynamics 365\" srcset=\"https:\/\/www.aegissofttech.com\/insights\/wp-content\/uploads\/2024\/10\/No-Code-Filtering-Using-Related-Records-1024x683.webp 1024w, https:\/\/www.aegissofttech.com\/insights\/wp-content\/uploads\/2024\/10\/No-Code-Filtering-Using-Related-Records-300x200.webp 300w, https:\/\/www.aegissofttech.com\/insights\/wp-content\/uploads\/2024\/10\/No-Code-Filtering-Using-Related-Records-768x512.webp 768w, https:\/\/www.aegissofttech.com\/insights\/wp-content\/uploads\/2024\/10\/No-Code-Filtering-Using-Related-Records.webp 1536w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\">Step #1: Verify the Entity Relationship Exists<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Before configuring filters, you need to confirm that the underlying relationship connects your entities properly.<\/li>\n\n\n\n<li>Open your solution in <strong>Power Apps<\/strong> (make.powerapps.com) and navigate to <strong>Tables<\/strong>. The entity containing the lookup you want to filter should appear in your list. Click on <strong>Relationships <\/strong>to view all connections.<\/li>\n\n\n\n<li>A relationship must exist between your entities for native filtering to work. For example, the <strong>Contact entity <\/strong>should have <span style=\"box-sizing: border-box; margin: 0px; padding: 0px;\">a<strong>&nbsp;Many-to-One<\/strong><\/span><strong> relationship <\/strong>with <strong>Account <\/strong>through <strong>parentcustomerid<\/strong>.<\/li>\n\n\n\n<li>If the relationship does not exist, create one by clicking <strong>New Relationship<\/strong>. Define the parent and child entities, then save and publish your changes. Missing relationships will cause filters to fail silently, so this verification step prevents troubleshooting later.<\/li>\n<\/ul>\n\n\n\n<section class=\"call-to-action-section\">\n<div class=\"call-to-action-container\">\n<div class=\"call-to-action-body\">\n<div class=\"cta-title\"><\/div>\n<p><\/p>\n<div style=\"text-align:center; color:white;\">\n<strong>Also Read:<\/strong> <a href=\"https:\/\/www.aegissofttech.com\/insights\/integrating-ms-crm-with-sharepoint\/\" target=\"_blank\">How to Integrate MS CRM with Outlook and SharePoint?<\/a><\/div>\n<p><\/p>\n<\/div>\n<\/div>\n<\/section>\n\n\n\n<h4 class=\"wp-block-heading\">Step #2: Enable Related Records Filtering<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>The form editor contains built-in filtering options that appear once relationships are established. Navigate to the form where filtering should apply. Click on the lookup field you want to filter, such as <strong>Primary Contact<\/strong> on an <strong>Account form<\/strong>. The field properties panel opens on the right sidebar.<\/li>\n\n\n\n<li>Locate the<strong> Related Records Filtering section <\/strong>within properties. Toggle on <strong>Only show records where<\/strong> to activate filtering.<\/li>\n\n\n\n<li>A dropdown menu appears showing available relationships. Select the appropriate relationship from this list. The dropdown only shows valid connections based on the entities involved in your form, which prevents configuration errors.<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">Step #3: Configure the Filter Relationship<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Open the OnBeforeValidate trigger for the <strong>Shipment Date<\/strong> field in your Sales Line table extension.<\/li>\n\n\n\n<li>Define a Boolean condition, such as ShouldSuppressValidation, to specify when the validation message should be hidden.<\/li>\n\n\n\n<li>Add the SetHideValidationDialog(true) method within the condition so the dialog is suppressed only when the condition is met.<\/li>\n\n\n\n<li>Review the condition to ensure validation messages remain visible during regular sales document entry and are hidden only for the intended workflows.<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">Step #4: Test and Publish<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Save<\/strong> the form configuration and publish all customizations.&nbsp;<\/li>\n\n\n\n<li><strong>Open an existing record<\/strong> to test the filtered lookup behavior.<\/li>\n\n\n\n<li><strong>Select a value in the parent field<\/strong>, then open the child lookup. Only related records should appear in the filtered list. Test with records that have no matching results to check empty state handling.<\/li>\n\n\n\n<li><strong>Clear the parent field<\/strong> and confirm the child lookup responds appropriately.&nbsp;<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">If no records appear when you expect results, the relationship field may lack data on one or both entities.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">2. Code-Based Filtering Using JavaScript<\/h3>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"683\" src=\"https:\/\/www.aegissofttech.com\/insights\/wp-content\/uploads\/2024\/10\/code-based-filtering-using-javascript-1024x683.webp\" alt=\"JavaScript filter lookup in Dynamics 365\" class=\"wp-image-21162\" title=\"JavaScript filter lookup in Dynamics 365\" srcset=\"https:\/\/www.aegissofttech.com\/insights\/wp-content\/uploads\/2024\/10\/code-based-filtering-using-javascript-1024x683.webp 1024w, https:\/\/www.aegissofttech.com\/insights\/wp-content\/uploads\/2024\/10\/code-based-filtering-using-javascript-300x200.webp 300w, https:\/\/www.aegissofttech.com\/insights\/wp-content\/uploads\/2024\/10\/code-based-filtering-using-javascript-768x512.webp 768w, https:\/\/www.aegissofttech.com\/insights\/wp-content\/uploads\/2024\/10\/code-based-filtering-using-javascript.webp 1536w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\">Step #1: Create the JavaScript Web Resource<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Your filtering logic lives in a JavaScript file that gets stored as a web resource in <a href=\"https:\/\/www.aegissofttech.com\/dynamics-365\">Dynamics 365<\/a>. Open your <a href=\"https:\/\/www.aegissofttech.com\/microsoft\/power-apps-consulting\">solution in Power Apps<\/a> and navigate to Web Resources. Click New Resource and select JavaScript as the type. A descriptive name like <strong>filterLookups.js<\/strong> helps with future maintenance.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Write your function using the <strong>addPreSearch <\/strong>event pattern. Here is a template for filtering a City lookup based on Country selection:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>function filterCityByCountry(executionContext) {\n    var formContext = executionContext.getFormContext();\n    var countryLookup = formContext.getAttribute(\"new_country\").getValue();\n    if (countryLookup !== null) {\n        var countryId = countryLookup&#091;0].id.replace(\/&#091;{}]\/g, \"\");\n        var cityControl = formContext.getControl(\"new_city\");\n        cityControl.addPreSearch(function() {\n            var fetchXml = \"&lt;filter type='and'&gt;\" +\n                          \"&lt;condition attribute='new_countryid' operator='eq' value='\" + countryId + \"' \/&gt;\" +\n                          \"&lt;\/filter&gt;\";\n            cityControl.addCustomFilter(fetchXml, \"new_city\");\n        });\n    }\n}<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Replace schema names with your actual field names. The <strong>addPreSearch <\/strong>function executes before the lookup query runs, injecting your filter criteria into the request.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Save and publish the web resource to make it available for forms.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Step #2: Register the Script on the Form<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Forms need explicit references to web resources before they can execute the functions inside them.<\/li>\n\n\n\n<li>Navigate to the target form and click <strong>Form Properties<\/strong> in the command bar. The properties dialog opens with several tabs visible.<\/li>\n\n\n\n<li>Switch to the <strong>Form Libraries tab<\/strong>. Click <strong>Add Library<\/strong> and select your JavaScript web resource from the list. Loading order matters when scripts reference functions from other libraries, so position your filter script after any dependencies.<\/li>\n\n\n\n<li>Multiple scripts on the same form require careful ordering to prevent reference errors.<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">Step #3: Add the OnLoad Event Handler<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>The form must call your function when it loads to initialize filtering behavior. Stay in <strong>Form Properties <\/strong>and switch to the <strong>Event Handlers tab<\/strong>. The <strong>Event dropdown<\/strong> should display <strong>OnLoad<\/strong> as an option.<\/li>\n\n\n\n<li>Click <strong>Add<\/strong> to create a new event handler. Choose your web resource library from the <strong>Library dropdown<\/strong>. Enter your function name in the Function field, such as <strong>filterCityByCountry<\/strong>.<\/li>\n\n\n\n<li>The <strong>Pass execution context as first parameter checkbox<\/strong> must be enabled\u2014event handlers without execution context will fail because the function cannot access form data.<\/li>\n\n\n\n<li>Set the execution order if multiple OnLoad handlers exist on the same form.<\/li>\n<\/ul>\n\n\n\n<section class=\"call-to-action-section\">\n<div class=\"call-to-action-container\">\n<div class=\"call-to-action-body\">\n<div class=\"cta-title\"><\/div>\n<p><\/p>\n<div style=\"text-align:center; color:white;\">\n<strong>Also Read:<\/strong> <a href=\"https:\/\/www.aegissofttech.com\/insights\/top-5-plugins-integrations-for-crm\/\" target=\"_blank\">Top Game-Changing Plugins &#038; Integrations for CRM Platform<\/a><\/div>\n<p><\/p>\n<\/div>\n<\/div>\n<\/section>\n\n\n\n<h4 class=\"wp-block-heading\">Step #4: Configure the Parent Field OnChange Event<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Filters must update dynamically when users change the parent field value. Click on the parent lookup field (Country in this example) directly on the form canvas. The properties panel opens on the right sidebar.<\/li>\n\n\n\n<li>Navigate to the <strong>Events tab<\/strong> within field properties.<\/li>\n\n\n\n<li>The OnChange event should appear in the dropdown. Click <strong>Add<\/strong> and choose your JavaScript library from the list. Enter the same function name used in the OnLoad event. Enable <strong>Pass execution context as first parameter<\/strong> here as well. This configuration ensures the City lookup refreshes its filter whenever the Country selection changes.<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">Step #5: Handle Edge Cases<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Real-world usage includes scenarios where users clear fields or select values with no matching results.<\/li>\n\n\n\n<li>Add logic to clear the filtered field when the parent becomes empty. The code <strong>formContext.getAttribute(&#8220;new_city&#8221;).setValue(null)<\/strong> resets the child field appropriately.<\/li>\n\n\n\n<li>Place this code at the function start when <strong>countryLookup<\/strong> equals null.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Edge case handling prevents orphaned data where a City remains selected after removing its Country. Consider adding user notifications when filters return no results, so users understand why the lookup appears empty. Test behavior when switching between parent values rapidly to catch race conditions.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Common Filter Lookup Field Issues in Dynamics 365 CRM<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">A filtered lookup field in Dynamics 365 CRM can be configured exactly right and still not work \u2014 relationship settings, a wrong schema name, form configuration, a JavaScript conflict, any one of them can be the actual cause. Here are the common problems and how to fix them.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><td class=\"has-text-align-center\" data-align=\"center\"><strong>Issue<\/strong><\/td><td class=\"has-text-align-center\" data-align=\"center\"><strong>Why It Happens<\/strong><\/td><td class=\"has-text-align-center\" data-align=\"center\"><strong>Troubleshooting Tip<\/strong><\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\"><em>Filter not applying correctly<\/em><\/td><td class=\"has-text-align-center\" data-align=\"center\">The relationship between the parent and child entities is missing or incorrectly defined.<\/td><td class=\"has-text-align-center\" data-align=\"center\">Check entity relationships in Power Apps. Ensure the lookup field references a valid Many-to-One or One-to-Many relationship before enabling filtering.<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\"><em>Lookup shows all records instead of filtered ones<\/em><\/td><td class=\"has-text-align-center\" data-align=\"center\">Related records filtering is turned off or not linked to the correct parent field.<\/td><td class=\"has-text-align-center\" data-align=\"center\">In form properties, open the lookup field settings and confirm that \u201cOnly show records where\u201d is toggled on and mapped to the correct field.<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\"><em>Filter works inconsistently<\/em><\/td><td class=\"has-text-align-center\" data-align=\"center\">Cached form data or unrefreshed scripts can cause filters to behave unpredictably.<\/td><td class=\"has-text-align-center\" data-align=\"center\">Clear browser cache, republish the form, and reload it in an incognito window to test fresh behavior.<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\"><em>JavaScript filter not triggering<\/em><\/td><td class=\"has-text-align-center\" data-align=\"center\">The script is not properly linked in Form Properties, or the event handler is missing.<\/td><td class=\"has-text-align-center\" data-align=\"center\">Add the web resource under Form Libraries, then register the function for both OnLoad and OnChange events with \u201cPass execution context\u201d enabled.<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\"><em>Filtered lookup returns empty results<\/em><\/td><td class=\"has-text-align-center\" data-align=\"center\">Parent lookup has no value, or the filter query returns no matches.<\/td><td class=\"has-text-align-center\" data-align=\"center\">Add logic to handle null or empty parent values in the JavaScript function. Optionally, display an alert to inform users when no related records exist.<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\"><em>Incorrect records appear in lookup<\/em><\/td><td class=\"has-text-align-center\" data-align=\"center\">Field schema names used in code don\u2019t match the actual CRM field names.<\/td><td class=\"has-text-align-center\" data-align=\"center\">Double-check schema names in the table designer and update the JavaScript function accordingly before publishing changes.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Optimize Dynamics 365 Lookup Fields With Aegis Softtech<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Filter lookup fields turn messy dropdown lists into precision tools. Your sales team stops scrolling through 5,000 contacts to find the three that matter. <a href=\"https:\/\/www.aegissofttech.com\/dynamics-365\/support-services\" target=\"_blank\" rel=\"noreferrer noopener\">Dynamics 365 support<\/a> agents see the right products instantly. Data entry becomes faster, cleaner, and way less frustrating.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The setup varies. Basic filters take ten minutes with point-and-click configuration. Complex cascading hierarchies or role-based rules need JavaScript expertise and real testing across different user types by <a href=\"https:\/\/www.aegissofttech.com\/hire\/dynamics-365-crm-developers\">Dynamics CRM developers<\/a>.\u00a0<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">At Aegis Softtech, our <a href=\"https:\/\/www.aegissofttech.com\/dynamics-365\/crm\" target=\"_blank\" rel=\"noreferrer noopener\">Dynamics CRM Services<\/a> team has built these systems for businesses across industries. Conditionally filter lookup fields that adapt to user roles, multi-entity chains that work under pressure, Dynamics 365 form scripting examples that handle edge cases gracefully\u2014we handle the tricky parts so your forms just work.<\/p>\n\n\n    \t<section class=\"call-to-action-section\">\n    \t\t<div class=\"call-to-action-container\">\n    \t\t\t<div class=\"call-to-action-body\">\n    \t\t\t\t<div class=\"cta-title\">Your team deserves forms that feel intuitive.<\/div>\n    \t\t\t\t<p><\/p>\n<div style='text-align:center; color:white;'>\nBook a free consultation with our Dynamics 365 team, and we'll show you exactly how to fix them.<\/div>\n<p><\/p>\n    \t\t\t<\/div>\n    \t\t\t    \t\t\t\t<div class=\"call-to-action-btn\">\n    \t\t\t\t\t<a href=\"https:\/\/www.aegissofttech.com\/contact-us.html\">Book a FREE Consultation Today<\/a>\n    \t\t\t\t<\/div>\n    \t\t\t    \t\t<\/div>\n    \t<\/section>\n    \n\n\n\n<h2 class=\"wp-block-heading\">Frequently Asked Questions<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">1. How do I filter a lookup field in Dynamics 365 CRM?<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">You can filter a lookup field in Dynamics 365 CRM using Related Records Filtering or JavaScript. Related Records Filtering works well when tables already have the required relationship. JavaScript is better when you need conditional logic, multiple criteria, or more complex cascading lookup behavior.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">2. Can I filter a Dynamics 365 lookup field without JavaScript?<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Yes. Dynamics 365 has no-code lookup filtering using associated records. If the correct relationship is established between the tables, you can set up the lookup to only show records that are related to the chosen parent record.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">3. How do I create dependent lookup fields in Dynamics 365?<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Create a relationship between the relevant tables, with the child lookup configured off the parent field \u2014 that&#8217;s the base case. Anything more complex needs JavaScript, using addPreSearch and addCustomFilter to control which records actually appear.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">4. Why is my filtered lookup showing all records in Dynamics 365?<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">The possible reason could be related records filtering disabled, the wrong relationship selected, or a JavaScript filter that isn&#8217;t triggering \u2014 any of these can cause it. Check the relationship configuration, schema names, form libraries, and the OnLoad or OnChange event handlers before assuming it&#8217;s something else.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">5. Can I filter a Dynamics 365 lookup based on multiple conditions?<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Yes. JavaScript filtering can apply multiple conditions before Dynamics 365 displays lookup records. This is useful when records need to be filtered by criteria such as country, account, status, business unit, or other form values.<\/p>\n","protected":false},"excerpt":{"rendered":" ","protected":false},"author":11,"featured_media":19537,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[21,19],"tags":[1637],"class_list":["post-6141","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dynamics-crm","category-dynamics-365","tag-filter-lookup-field-in-dynamics-365"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.aegissofttech.com\/insights\/wp-json\/wp\/v2\/posts\/6141","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.aegissofttech.com\/insights\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.aegissofttech.com\/insights\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.aegissofttech.com\/insights\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/www.aegissofttech.com\/insights\/wp-json\/wp\/v2\/comments?post=6141"}],"version-history":[{"count":18,"href":"https:\/\/www.aegissofttech.com\/insights\/wp-json\/wp\/v2\/posts\/6141\/revisions"}],"predecessor-version":[{"id":21190,"href":"https:\/\/www.aegissofttech.com\/insights\/wp-json\/wp\/v2\/posts\/6141\/revisions\/21190"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.aegissofttech.com\/insights\/wp-json\/wp\/v2\/media\/19537"}],"wp:attachment":[{"href":"https:\/\/www.aegissofttech.com\/insights\/wp-json\/wp\/v2\/media?parent=6141"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.aegissofttech.com\/insights\/wp-json\/wp\/v2\/categories?post=6141"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.aegissofttech.com\/insights\/wp-json\/wp\/v2\/tags?post=6141"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}