Dynamics javascript get entity id

com You can set its value by: formContext. Jul 9, 2015 · Is there any way I can execute some JavaScript code after the Dynamics CRM entity form is saved. Provide product feedback. Chicago AX/D365 FO - Forum. Page. entityTypeName; ---. Microsoft Dynamics CRM forum Gold Pocket Loan Customer Care Number ⓿ Last replied Posted on by CU27051953-0 Gold Pokket CustOmeR care Toll-free Number)+91) 9201324866 8889734604 Jun 18, 2007 · Introducing CRM MVP Mitch Milam, one of our long time partners, and a very interesting writer too. So far ive gotten the entityname and the entity id by writing Oct 7, 2019 · Find its logical name. While each sample focuses on a different aspect of Microsoft Dataverse Web API, they all follow similar process and structure described in this topic. The entity to set is "new_vehicle" and the entity to query on is "customer". getAttribute (“new_status”). 5,436 1 14 14. getAttribute(arg). opener. I got all the data I require but I cant get the Finance forum Bypassing quick create forms in D365 F&O. Here's an example of how it might look: function descriptionOnChange() { // Get the value of the description attribute. Feb 4, 2024 · Dynamics 365 – Retrieve Records using JavaScript. To get the data for the other field, I need to access the parent entity record and get data from it and other entities related to it. Now I want to fetch all Parameter Name and Parameter Value from CRM Entity based on the Contact ID. Steps to follow : 1. integ_Amount = totalPay; //set more properties. Lead_Annotation. getFormType(); Return Value. errorCallback: Function: No Dynamics 365 Governance, Risk, and Compliance (GRC) Dynamics 365 Groupe -Algeria - Forum; Dynamics 365 in Middle East Region - Forum; Dynamics 365 Marketing - Marketing Automation - Forum; Dynamics 365 Marketing Experience Group - Forum; Dynamics 365 Northeast - New York (NAV/BC UG) Chapter - Forum; Dynamics 365 Philippines Community - Forum Sep 22, 2023 · When working with forms, and you call the formContext. Page API: Xrm. Greg Owens. ui. But since I always have to do things the hard way, I have the reverse task: I have the object type code, and need to get the entity name. Product_Annotation Nov 27, 2014 · 1. You need to set EntityFilters in request like: Or. The following samples use the patterns described here: Mumbai India - Dynamics 365 & Power Platform Community - Forum. In this blog we will learn how to retrieve attributes of an entity in Dynamics 365 using JavaScript. 2. Feb 11, 2020 · In the account page below, we see in the URL the AppId of our App – 0da29984-d407-ea11-a81e-000d3a35b116: Now, let’s go into debug in the browser and run the code below (of course, you can run this anywhere you need to): var globalContext = Xrm. id, Collection-valued navigation properties represent collections of entities which may represent either a one-to-many (1:N) or many-to-many (N:N) relationship between the entities. getId() returns "" which is probably logical, since Object has not been inserted in the db yet, this is the reason which makes inserting a runtime generated guid for the entety seems doable ! P. getAttribute("regardingobjectid"). getValue(); Dec 31, 2022 · To run this sample, download the solution package from here. is null or not an object. Display. Step 1 - Navigate to the system solution. Dec 11, 2017 · Getting Associated view grid is different from subgrid in entity forms. getFormContext(); retreiveOppCompRecords(formContext. I need to get alll 5000 guid in a Javacript . Other Info: This is for Microsoft Dynamics Online 2013/2015(works with both) Using SKD v6. ISV_GetAccountData(); For brevity I've excluded cleaning up the function when the form unloads, making sure the function is defined before calling, etc. getCurrentAppProperties(). The entity contains 3 fields Parameter Name, Parameter Value, and Contact ID. options: String: No: OData system query options to control what is returned. On the form to add related child records, I want to use javascript on the onChange event of a lookup field to populate another field on the form. setValue(window. Apr 11, 2017 · You want to get the entity of the Reference first. Returns a reference to the form or an item on the form depending on where the method was called. Dynamics 365 blogs User groups Videos Ideas Resources Getting started Community news Leaderboard Sep 20, 2021 · Note: because it’s possible to place the same attribute of the form multiple times it would be required to use the proper index at the end of the control name – in my case I had attribute placed twice (first as regular lookup control – primarycontactid and the second time as a form component control – primarycontactid1). For example, "account". Jan 2, 2015 · Get Current Record Id of an entity using javascript in ms crm 2011 , ms crm 2013 and ms crm 2015 Microsoft Dynamics 365 Blog May 24, 2022 · With JavaScript you can use the Dynamics API to gather information and/or update records. retrieveRecord(entityLogicalName, id, options). This is a useful method that allows you to get a single record by its ID and entity name, and optionally specify which attributes and relationships you want to I'm trying to get the information of the customer of a campaign response in Dynamics CRM 2016 (on-premise). See the Lead_Annotation one-to-many relationship for the lead entity. S. getAttribute("accountid") or Xrm. For example, the page object has an attribute called title that can be used to output the title of the current page. Liquid objects contain attributes to output dynamic content to the page. getEntityReference(); The output of the getEntityReference() function in Dynamics 365/Dataverse. Returns a string representing the logical name of the table for the record. Use Debugger and you will get the data. Default only entity information will be retrieved, that’s why you have empty attribute list. After you have this value in order to get details from the business unit of the user you need to do a retrieve request, something like this: // get the userId. 0. zip managed solution file. From the left navigation, click Entity Forms. On your site map, Select the Settings Area, and click Customizations. For example, the following sample code shows how to retrieve the account name column on the account form, and then set a value in the websiteurl column based on the account name value: Dec 8, 2023 · id: String: Yes: GUID of the table record you want to retrieve. Because I'm on an entity form I want to use JavaScript for the REST queries. Sep 22, 2023 · Function. JavaScript only runs on the interface; this means that the validation or manipulation only happen when a user is interacting with the model-driven app. Page namespace, we should pass executionContext to a function and get formContext using getFormContext() function. The goal is to get the Account Name and the Account Id. Sep 15, 2020 · Just imagine that you need to define the context in which “Quick Create Form” was opened and depending on the context – to do some additional operations. parameters["regardingobjectidtype"] = "salesorder"; // Table name. THANKS FOR READING. But to access Associated view grid, you have to do DOM manipulation starting from IFRAME, then Grid like below. Don't change or append any more system query options to the value. Attributes, LogicalName = "opportunity". To get the name, you use an EntityReference without doing another lookup to the Oct 6, 2020 · Here's how you get the GUID of current view from Ribbon Button in Dynamics 365 JavaScript code on the button on the Account entity. Nov 29, 2022 · In this article. Name of the record selected in the lookup control. Column types supported. I'd like to bypass the quick create form for RFQ and enter directly into the full form when the new button is selected. answered Jul 30, 2015 at 9:18. In that contact Entity ther is an 5000 records. dynamics-365. For example, when retrieving Opportunities, you have a parent account id. There are multiple records for a same Contact ID in my CRM Entity. Dec 2, 2022 · var formContext = executionObj. Chennai D365 F&O - Forum. See the msdyn_solutioncomponentdatasource_Annotations one-to-many relationship for the msdyn_solutioncomponentdatasource entity. Web API Samples using client-side JavaScript. function getLookupDetails (executionContext) {. getAttribute("customerid"). Sep 22, 2021 · Write set value statement to set value of status record on phone call. Dec 15, 2022 · 1. Click + New. Mar 9, 2022 · From the userSettings you can get the userId property, it returns the GUID of the current user. Center India Power Platform Group - Forum. The logic remains the same. May 2, 2022 · lookup [0]. An example call might look like this: // Assume we are working with the account entity. Make sure it contains data. Dec 3, 2019 · In this post, we will look at how to retrieve Entity Metadata in Dynamics 365 with JavaScript. Rest. There is also a CodePlex project called Jan 18, 2019 · In running the code above, we get the Id, Value, logical name etc: In previous releases of the Web Api, we would need to pass (“Prefer”, “odata. getValue (); // Getting the GUID of the lookup record. Nov 3, 2020 · In our model-driven app, I have a 1:N relationship between 2 entities. The lookup values you are looking for are in arrays that are part of the To/Cc/Bcc fields. OrganizationServiceContext dataContext = new OrganizationServiceContext(service); Guid siteId = temp. Also Xrm. Return Value. getAttribute("Lookup Field Name"). The formContext is part of executionContext, and replaces Xrm. attributename); } Otherwise, you can query using the web api on form load, filter it based on parent lookup value mapped and fill the fields. Id. setValue([{ id: recordid, name: recordname, entityType: entityname}]); If you just want to display some other attribute from that lookup record in current entity form, you can use Quick view form of that lookup entity in current entity. getEntityName(); You get for example "opportunity" and when you add this as the var for entityName to the getPrimaryKey this will fail because the SchemaName of the entity is Opportunity and not opportunity. By default, EntityFilters. You can create a separate library/method for registering in QC form only or check only if it is Quick create form and execute it. Utility. Community. Last replied Posted on by CU09060608-0 Rupee112 Loan Customer Care Number// ⓿ ⓿ Call 9201320481 Call Now. Once you activate a business process flow definition by changing the state of the corresponding Workflow entity record or by using the business process flow designer, a custom entity with the following name is automatically created to store the activated business process flow instances: "<activesolutionprefix>_<uniquename>", where the uniquename is derived from Microsoft Dynamics CRM forum Rupee112 Loan Customer Care Number// ⓿ ⓿ Call 9201320481 Call Now. check image. If both not working Make a retrieve call using ODATA and get the data (parent record) 4. Another way to retrieve the current record id. Jul 17, 2023 · I am working on an Associated View of an Entity that is on the Account Form. Type: Array. javascript. Jul 3, 2019 · Hi All, here is the scenario I am working on , there is a custom activity type of entity in Dynamics 365 CE. A quick summary: From a Phone Call Activity I have a related Entity Contact, I then relate a Contact to an Account. Nov 18, 2018 · I'm assuming your real code is more complicated, but there is no need to use the context in your example code: integ_creditpayment creditpayment = new integ_creditpayment(); creditpayment. How to do this? Apr 17, 2019 · In Dynamics 365, the formContext provides a reference to a form or form item through JavaScript. Dec 31, 2022 · This article provides common understanding about Web API samples using client-side JavaScript. To get the string version of a date using the Power Apps user's locale preferences, use the format and localeFormat methods. No. Feb 15, 2022 · Instead, access to entity form elements are exposed through the Client API object model. If you want to retrieve a different Sep 22, 2023 · In this article. So, from Phone Call I want to get some data from the related Contact's Account and do this by: var lookup = Xrm. entityId; let entityTypeName = (<any>context. edited Dec 5, 2022 at 14:15. var userId = Xrm. getAttribute("new_attributename"). getControl method is a shortcut method to access Xrm. save method, make sure that you also call the preventDefault to ensure that any default save operation is not triggered when a user saves the form. For instructions on how to import the sample solution, see Web API Samples (Client-side Sep 20, 2021 · JavaScript Code: Getting Owner Lookup of the Case. Gets the form type for the record. parent. Last replied Posted on by Inkey Solutions 1,628. New Zealand Dynamics 365 Finance & Operations User Group - Forum. Jun 4, 2015 · When I try to re-save(as the entity record already exists) an entity record I want to retrieve the GUID in JS to do some comparing etc For some reason window. let entityId = (<any>context. Oct 6, 2020 · Xrm. if you would like to see how i build apps, or find something useful reading my blog, i would really appreciate you subscribing to my youtube channel. Expand table. replace(/[{}]/g, "")). userSettings. If you need to do something to the entity just before it's being saved (or maybe after the save but before postback to the client) you might want to intercept the operation Jun 28, 2012 · So to get any additional information about the contact, you're going to have to ask the Contact entity for that information via a query using the EntityReference. Retrieving the information of the campaign response is not the problem. And the reason your code won't work is that Id is only available after the record has saved and Aug 12, 2014 · 1. The Dynamics 365 Customer Engagement (on-premises) development team reserves the right to change how pages are composed, including the ID values for elements, so using the Client API object model protects your code from changes in how pages are implemented. Syntax. The code: Running this, we get: For more information, check out here. The form context object model looks like: Let’s go through an example of using the formContext. Jun 16, 2015 · The aim of my task was to use javascript to get set a lookup field, based on the selected data of another lookup entity. V1. Apr 22, 2016 · Include this as a script in your form entity and you can reference the functions to make REST calls. Clicking on it will open a list of related entities B. How to Get the Entity Reference of the Current Row With JavaScript. Import the managed solution into your Dataverse organization and run the sample. getId() "Error: . Andrew Butenko. Nov 29, 2022 · Form values. All. answered Jun 16, 2016 at 19:36. 3. Cambridge, United Kingdom Dynamics 365 User Group - Forum. The available OnSave event fires before the form is saved actually. It should be regardingobjectidtype and not regardingobjectidentitytype. First job is to get the ID value of the contact lookup field var customerItem = Xrm. BEFORE YOU LEAVE Dec 26, 2017 · Below is the latest Syntax available to retrieve a record in Dynamics 365 Online V9. See full list on learn. getAttribute("id") both return null, so I can not setValue using them. getFormContext (); // Getting the value of Case Owner id. Other methods will format dates using the operating system locale rather than the user's Power Apps locale preferences. getActiveStage(); The stage object is always null, so of course I can't try to get its ID. ISV_GetAccountData(); This can also work from a pop-up window: var accountData = top. Extract the contents of the sample and locate the WebAPIQueryData_1_0_0_0_managed. entityType = “eng_uom”; The variable ‘lookup’ is an array variable which hold the name, GUID and Entity type. Dec 16, 2012 · Assign the record guid manually, use AJAX to save your record, pop your new window using th enew guid and then reload your original form (so that the form is no longer in an "unsaved" state). e. This is working fine and I had never a problem with using this approach. Dynamics 365 Governance, Risk, and Compliance (GRC) Dynamics 365 Groupe -Algeria - Forum; Dynamics 365 in Middle East Region - Forum; Dynamics 365 Marketing - Marketing Automation - Forum; Dynamics 365 Marketing Experience Group - Forum; Dynamics 365 Northeast - New York (NAV/BC UG) Chapter - Forum; Dynamics 365 Philippines Community - Forum Jan 11, 2018 · In Dynamics 365 9. I know, how to retrieve field value, when i have lookup field(N:1) on the entity using xrmservicetoolkit, but not for 1:N relationship. 0 there was quite a big change regarding how to access form attributes and controls - instead of Xrm. getValue(); XrmServiceToolkit. Read more. In case you use CRM 2013 - you can use Metadata Queries to filter entities by objecttypecode. Currently I have only been able to get 0 even if I know that the state code of the opportunity is 1. getGlobalContext(); globalContext. Retrieve(lookup[0]. answered Aug 20, 2012 at 15:30. getAttribute(fieldName); Mar 1, 2023 · In this article. On an e-mail form this will always be "email". Added by: Lead Management Solution. getSecurityRolePrivilegesInfo() Returns a promise which resolves with an object whose keys are the security role privilege GUIDs and values are objects containing the businessUnitId, depth, and privilegeName of the security role privilege. ExecutionContextObj. entity. include-annotations=OData. Description: The returned object has following three parameters: entityType: String. WebApi. Mar 10, 2020 · Here is below code I tried in one of my Instance. using the formContext JavaScript API and Xrm. Step 2 - Navigate to the associated Entity. I'm encountering weird behavior while trying to pin a case entity record. Description: GUID values of each of the security role privilege. An array of lookup objects. Id = service. On a Form for A entity, I have associated view for entities B. GUID value of the table record. The record managed to be created even though the conditions should have blocked it. Returns the formContext. So, you need to actually perform the save operation before the server returns to you with the guid. Jul 30, 2015 · In case you use CRM 2011 the only way is to retrieve all the entities using RetrieveAllEntities message and then one-by-one go through entities checking objecttypecode. Feb 27, 2015 · In MS CRM 2011 (on premise), I have 2 related entities, let's say A and B (1:N). mode). GetAttributeValue<EntityReference>("new_site"). To get the IFrame control: var frame = document. Logical name of the table record. Nigeria Dynamics 365 User Group - Forum. To get to this view, I click the associated view button on a SubGrid that is on the Account Form. In general, the ultimate task is to take the the CRM regarding information on an email, and use it to query CRM for additional info. Sep 4, 2020 · Go to the Settings for your Entity. getEntityName() gets the logical name of the entity that is displayed on the form. However, Microsoft has the following JavaScript API recommendations: Before Dynamics 365/CRM version 9. Occasionally, while creating solutions that need to access CRM data, I have found a need to know either the PrimaryField or the PrimaryKey of an Entity. attributes collection and the ui. Type: Depends on the type of column. table type of the record selected in the lookup control. FetchXml is overkill for this requirement, but obviously if you want to construct the FetchXml and use it for your QueryBase in place of the QueryExpression I'm showing you are free to do that. Dec 5, 2013 · The entity name is SavedQuery and there are properties for returnedtypecode (Entity Name), isdefault, and querytype (the type of query it is). For this I have: Microsoft Dynamics CRM forum Unable to pin a particular entity record in the site map under pinned section. Note: Other deprecated JS works. Nov 18, 2014 · I need to get all guids in an Entity by using Javascript crm 2011?for Ex:I have the Entity called Contact. And it looks like below Oct 13, 2017 · Both are working seemless for me, as Xrm. get To get display name from CRM entity customizations, you may need another service call. A solution window will appear. retrieveRecord() web API. See Options: successCallback: Function: No: A function to call when a record is retrieved. Xrm. top. Page JavaScript API. 0 web api Hot Network Questions Etymology of the verb 'lint' in the context of programming where it means to apply static code analysis to detect code smells Apr 29, 2016 · i am spending more time these days creating youtube videos to help people learn the microsoft power platform. However, you may want to know the name instead of the id. Xrm. userId; Apr 8, 2015 · Im sitting with a piece of javascript where i have to take an entity from a lookup in crm 2011 and get the statuscode of that entity. Aug 30, 2022 · Added by: Microsoft Dynamics 365 Settings APIs Solution. Enable Change Tracking (mark it checked, unlike the image) Change your query for your KN Entity to something like the following - my entity, Knowledge Item, has a schema of jb_knowledgeitem and a Lookup field with schema jb_portallanguageid to Portal Language. Considering you want alert on Opportunity entity and that too onload of a form. Netherlands Dynamics 365 User Group - Forum. Last replied Posted on by KarliAMather. X using JavaScript, Syntax: Xrm. var OwnerId = formContext. 0, use the Xrm. Then I click "Add new B". If this post has answered your question please consider it for "Accept as Solution" or if it has been helpful give it a "Thumbs Up". contextInfo. setValue (statecode); With this we have picked GUID of a record and fetched its attributes and updated it in current record. May 8, 2017 · The event would get the value of the description, then get the element from your HTML control and then set the element's value equal to the description attribute's value. then(successCallback, errorCallback); Parameters: Name Type Required Description entityLogicalName String Yes The entity logical name of the record you want to retrieve. javascript dynamics-crm Jun 16, 2016 · Then in my inline-frame I would call: var accountData = top. Oct 6, 2015 · Xrm. Contact ID is a lookup field. securityRolePrivileges. Page which is deprecated in version 9+ of Dynamics 365. Type: Number. This will setup the “regarding” lookup as sales order record in opened email form. Running this, we get: Let’s say you want to retrieve all attributes for a given entity, We will do this for the account entity. Returns one of the following values Jul 16, 2017 · When you get the entity's logical name via a form in javascript: var entityName = Xrm. id: String. Try this instead. dynamics crm using odata to retrieve a guid from "type 4. There's lots of examples of this @StackOverflow and around the web - see CRM 2011: Getting entity with Javascript for a popular way here. getGlobalContext(). You get a guid for an instance first when you actually create it. Nebraska Dynamics 365 (CRM) User Group - Forum. setValue (lookup); Where ‘ eng_unitofmeasureii’ is the schema name of ‘Unit Feb 3, 2022 · Hello @JenniferK. Now in order to set the ‘Unit of Measure’ field, follow the following method. I can get the regardingID and the object type code easily. 0] State ID:07006. Create(creditpayment); You can also use a type initializer and get rid of your Aug 30, 2021 · To check if paymenttype equal credit account [entity form: auto_paymenttype]. microsoft-dynamics. microsoft. ). Create JavaScript webresource and add following code inside: function quickCreateOnLoad(){ //this variable contains entity get guid id from Microsoft CRM - javascript console. This is not required when using the Xrm. data. Enter a meaningful Name for the Entity Form record so when you see it in the list, it will make sense. Apr 5, 2019 · I have a entity with multiple records in it. var formContext = executionContext. Dynamics CRM get selected entity's attribute value. An array of objects with the following properties is passed: - entityType: String. I am passing the PrimaryControl into my JavaScript function. In this short post I provide supported code you can use to define it. 3,878 1 19 42. Click on Customize the System. Nov 29, 2022 · Return Value. What I want to do is: to get the newly created record's id and set it on the lookup field on the opener window. getFormContext(); var stageObject = formContext. Whenever I attempt to pin a case record it gets pinned in the first attempt Sep 24, 2021 · Inside Power Apps, click Apps, and then click the Model-driven app named Portal Management. Define the Entity, Form, and Tab Name. The complete snippet as follows: EntityFilters = EntityFilters. Let’s add a script to a form when the form loads, for example, a Contact entity . userSettings. So with that in mind you can make a query to the OData or Soap endpoints from JavaScript to get the default query for any entity type. In this post, I’m going to talk about how to retrieve records in CRM using JavaScript and Xrm. formContext. creditpayment. process. Below is what I found that does and does not work: Oct 8, 2020 · I have the following Microsoft Dynamics related XMLHttpRequest javascript function, and is encountering issue when attemtping to retrieve the entity attributes of the returned records. Chicago Dynamics 365 BC/NAV User Group - Forum. In the response XML though, the PartyId is of type EntityReference At the time of writing, there are two ways of accessing fields on Dynamics 365 forms i. Can someone help me? Microsoft Dynamics CRM forum Score Analyzer Loan C U S T O M E R Care H E L P L I N E Number+91 7209837045$-# [SQL server native client 11. On the left hand side of this window, click on the drop down arrow to the left of "Entities". //somehow you have to know the parent entity record's Id. Canada (Edmonton, AB) D365 User Group - Forum. controls collection to retrieve and set values for known columns. - name: String. Make sure your parent entity field available in the View or in Form. then(. retrieveRecord. Id; Business Central forum. getAttribute (“eng_unitofmeasureii”). getAttribute (“ownerid”). Let’s say you want to get the metadata for an entity. Mar 2, 2022 · Business process flow entity. Name of the table record. name: (Optional) String. . To render an object's attribute in a template, wrap it in { { and }}. A lookup value is an object with id, entityType and name property. Specifics: PrimaryField Jul 10, 2017 · Getting all related Contact for an Account entity in Dynamics 365 CRM v9. A JSON object with the retrieved properties and values passed to the function. The value may be null. Apr 28, 2015 · Recap: For this to work I just need to be able to get the actual statecode value of the opportunity related to the opportunityclose. // Getting Form Context. With retrieveRecord you can retrieve a records form a table if you know the ID. I am using following code, Nov 29, 2022 · Type: Lookup object. A function to call when the lookup control is invoked. Jan 23, 2020 · For the moment the best approach is to use. New Jersey (NJ) D365 / AX - Forum. getParent() Dec 18, 2018 · I need to get child entity(B) ID's from parent entity(A) and use these ID's to get child field values using javascript. Subgrid in CRM form is accessible using Xrm. answered Dec 17, 2022 at 4:40. I've ceated a Power App using standard "Start with the data " Template, now I've done few customization on Edit form and submiting data from power apps to Dynamics 365 CE using flows. entity object that is the parent to all the columns. ID of the record selected in the lookup control. getEntityName(); Return Value Jan 10, 2013 · 1. getId(). //Assumes you have a Entity() object of the parent entity. This information is readily available via the CRM EntityMetadata Class. When saving new entity B from this associated view, I want to perform a javascript check which needs ID of entity A to Use the query part in the URL in the nextLink property as the value for the options parameter in your subsequent retrieveMultipleRecords call to request the next set of records. Description: Form type. controls. The Entity Reference contains the Id you can run the query from. To access an object attribute by name, use a period (. getControl(subgrid_name) like any other control. Return the look-up value of the current record. webresource. Then , if payment amount <= resit amount, it will save else > prevent save (popup message invalid: payment amount should lower than resit amount)[entity form: auto_resittype] Sep 22, 2023 · In this article. getFormContext() Nov 29, 2022 · In this article. - id: String. 1. 1 Nov 23, 2017 · But when I tried to get others attributes besides name,id and entityType of the Entity B and populated in one custom field in Entity A, the value display in that custom field in undefined. frames Aug 26, 2016 · Or retrieve all columns like this: ColumnSet columnSet = new ColumnSet(true); In some cases, the columns retrieved will be an Id. With a form ribbon, you can use the data. FormattedValue”) in our request header in order to get the value of the lookup and not just the Id. xr wr mi om lf xw ai zo rj kb