Friday, 3 February 2023

Bind Team Members in Lookup field in Model Driven app

 We have can bind for a specific team's members in Lookup field in Model driven app/dataverse using code


Upload the below code on Web Resources  and add on page load event and pass the formcontext parameter



function bindLookUpField(formcontext)

{

    var frmcontext= formcontext.getFormContext();

    var viewId = "GUID";

    var entityName = "systemuser";

    var viewDisplayName = "Team Members";

    frmcontext.getControl("InternaleLookupFieldName").addPreSearch(function () {

    var fechxml='<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="true">'+

    '<entity name="systemuser">'+

    '<attribute name="fullname" />'+

    '<attribute name="systemuserid" />'+

    '<order attribute="fullname" descending="false" />'+

    '<link-entity name="teammembership" from="systemuserid" to="systemuserid" visible="false" intersect="true">'+

    '<link-entity name="team" from="teamid" to="teamid" alias="ac">'+

    '<filter type="and">'+

    '<condition attribute="name" operator="eq" value="Team Name" />'+

    '</filter>'+

    '</link-entity>'+

    '</link-entity>'+

    '</entity>'+

    '</fetch>';

    var layoutXml = "<grid name='resultset' object='1' jump='systemuserid' select='1' icon='1' preview='1'>" +

                    "<row name='result' id='cr6a2_teamsmember'>" +

                    "<cell name='fullname' width='150' />" +

                    "</row>" +

                    "</grid>";

   frmcontext.getControl("InternaleLookupFieldName").addCustomView(viewId, entityName, viewDisplayName, fechxml, layoutXml, true);

    });

    

}




No comments:

Post a Comment