Power Platform Community Forum Thread Details

I am trying to pre filter a lookup control in a model driven app based on the selection of a option list control. I have written the below script to be executed on change evented of the option list control to trigger the filtering. I am not receiving any errors but for some reason it is not filtering the lookup.

var Sdk = window.Sdk || {};

// set 'Sdk.setServiceFilter' in the Case form onchange event handler region field

Sdk.setServiceFilter = function (executionContext) {

// get the form context

formContext = executionContext.getFormContext();

//get region field value

var region=formContext.getAttribute("cssp_region").getText();

Xrm.Page.getAttribute("cssp_serviceregion").setValue(region);

if (region != 'global') {

//Prepare Condition for the filter

Sdk.filterServices = function () {

// Only show services where region is like selected region

var ServicesFilter = "<filter type='and'><condition attribute='cssp_regiontext' operator='like' value='%" region "%' /></filter>";

formContext.getControl("cssp_service").addCustomFilter(ServicesFilter, "cssp_service");

}

//Apply filter to the lookup field

formContext.getControl("cssp_service").addPreSearch(Sdk.filterServices);

}

Categories:

Building Power Apps

Ok I was able to adjust my script to the following and started with a new lookup field (i.e. removed the existing look up field I had and added a new one to the form)

SetLookupField = function(executionContext) {

formContext = executionContext.getFormContext();

formContext.getControl("cssp_service").addPreSearch(FilterService);

}

FilterService = function() {

var Region = formContext.getAttribute("cssp_region").getText();

var ServiceFilter = "<filter type = 'and'><condition attribute = 'cssp_regiontext' operator = 'like' value = '%"+Region+"%'/></filter>"

formContext.getControl("cssp_service").addCustomFilter(ServiceFilter);

}

Starting from scratch this script is working and starts filtering the data after I click “All records”. It does not filter the recently used items. I tried disabling the recently used items on the control, but then the filter is no longer properly working. It is like its not properly refreshing unless I navigate from the recently used items to the “All Records” view. Instead ite just not showing any items. Any ideas?