Dynamics Community Forum Thread Details

This is an odd experience. I am using JavaScript to retrieve a project ID in Project Operations to use dynamically in a FetchXML query to filter a subgrid. I can confirm the FetchXML work as I have tested this in FetchXML Builder and https://www.ashishvishwakarma.com/FetchXmlTester/. The data is returned with no issues. However, whenever I register my OnLoad function, the projectid value is not found. I am loading a project form though:

However, checking Level up For Dynamics, the value exists. it has to. I am using the Project entity form:

Here is a snippet of my code. This code contains an OnLoad function to retrieve the project ID and passes it to my on tab change function called 'applyFetchXmlToSubgridOnTabStateChanged'. Can anyone help identify where this plugin code is going wrong or a way around this issue:

var projectId = null;
function onLoadGetProjectId(executionContext) {
    var formContext = executionContext.getFormContext(); // Get the form context
    // Check if the msdyn_projectid attribute exists and is not null
    try {
        var projectAttribute = formContext.getAttribute("msdyn_projectid");
        if (projectAttribute) {
            projectId = projectAttribute.getValue();
            if (projectId !== null) {
                console.log("Project ID loaded: " + projectId);
            } else {
                console.error("msdyn_projectid attribute is null.");
            }
        } else {
            console.error("msdyn_projectid attribute not found.");
        }
    } catch (error) {
        console.error("Error accessing msdyn_projectid attribute: " + error.message);
    }
    // Call the function to apply FetchXML when the tab state changes
    applyFetchXmlToSubgridOnTabStateChange(executionContext);
}
function applyFetchXmlToSubgridOnTabStateChange(executionContext) {
    var formContext = executionContext.getFormContext(); 
    var tab = formContext.ui.tabs.get("Financials and Sales");
    if (tab) {
        tab.addTabStateChange(function() {
            var subgrid = formContext.getControl("QuoteLineDetailsSubGrid");
            if (subgrid && projectId) {
                var fetchXml = [
                    "<fetch version='1.0' output-format='xml-platform' mapping='logical' distinct='true'>",
                    "  <entity name='msdyn_quotelinetransaction'>",
                    "    <attribute name='msdyn_quotelinetransactionid' />",
                    "    <attribute name='msdyn_description' />",
                    "    <attribute name='createdon' />",
                    "    <attribute name='cen_discipline' />",
                    "    <attribute name='cen_productcode' />",
                    "    <attribute name='cen_productdescription' />",
                    "    <attribute name='cen_quotelinesite' />",
                    "    <attribute name='cen_subdiscipline' />",
                    "    <attribute name='msdyn_amount' />",
                    "    <attribute name='msdyn_enddatetime' />",
                    "    <attribute name='msdyn_price' />",
                    "    <attribute name='msdyn_project' />",
                    "    <attribute name='msdyn_quantity' />",
                    "    <attribute name='msdyn_startdatetime' />",
                    "    <attribute name='msdyn_task' />",
                    "    <attribute name='statecode' />",
                    "    <order attribute='msdyn_description' descending='false' />",
                    "    <filter type='and'>",
                    "      <condition attribute='msdyn_quotelinetransactionid' operator='not-null' />",
                    "    </filter>",
                    "    <link-entity name='quote' from='quoteid' to='msdyn_quoteid' link-type='inner' alias='ag'>",
                    "      <link-entity name='msdyn_project' from='cen_quote' to='quoteid' link-type='inner' alias='ah'>",
                    "        <filter type='and'>",
                    "          <condition attribute='msdyn_projectid' operator='eq' value='" + projectId + "' />",
                    "        </filter>",
                    "      </link-entity>",
                    "    </link-entity>",
                    "  </entity>",
                    "</fetch>"
                ].join("");
                subgrid.control.SetParameter("fetchXml", fetchXml);
                subgrid.refresh(); // Refresh the subgrid to apply the FetchXML
            } else {
                console.error("Subgrid not found or projectId is null.");
            }
        });
    } else {
        console.error("Tab not found.");
    }
}

Hi,

The 'msdyn_projectid' column stores GUID of each project records, which is different from common columns.

So you need use the following synax to get it in js code:

formContext.data.entity.getId();

More details:

https://learn.microsoft.com/en-us/power-apps/developer/model-driven-apps/clientapi/reference/formcontext-data-entity/getid

But the resulting GUID value will contain {}, which you'll need to remove in order to use it later in the code：

Referring to this Blog:

https://carldesouza.com/get-id-record-page-dynamics-365-power-apps/

It should be like this:

var projectId = formContext.data.entity.getId().replace("{", "").replace("}", "");

I hope you can mark my answer verified if it answer your question! If you have any questions, please feel free to contact me.
Regards,
Leah

Community site session details

formContext.getAttribute cannot find my project id when loading a form

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Abhilash Warrier – Community Spotlight

Congratulations to the September Top 10 Community Leaders!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates