| Anas Arshad
Filtering Business Process Flow Lookup field
When designing business process flows in Dynamics 365, one phase may have a data step that represents the search for another step in the next phase. In such cases, it would be ideal to filter the search options to show only relevant records.
This is not available OOB but can be done using JavaScript as an unsupported customization.
For example, BPF when selecting an account lookup and then filtering the contact lookup for only records related to the selected account.
var lookupField = Xrm.Page.getControl("fieldname");
var lookupFilter = "<filter type='and'><condition attribute='category' operator='eq' value='value'></filter>";
lookupField.addCustomFilter(lookupFilter);
In the above code, replace "fieldname" with the logical name of the lookup field you want to filter, "category" with the name of the attribute you want to filter by, and "value" with the value you want to filter on.
You can add multiple conditions to the filter by appending additional <condition> elements within the <filter> element. For example:
var lookupFilter = "<filter type='and'><condition attribute='category' operator='eq' value='value1'/><condition attribute='status' operator='eq' value='value2'/></filter>";
This will filter the lookup to only show records where the "category" attribute is equal to "value1" and the "status" attribute is equal to "value2".
Note that this code should be added to the form's OnLoad event, or to a function that is called after the form has loaded.
Join us next time, as we continue our journey of learning canvas apps.Click here to learn more about Imperium's Power Apps Services. We hope this information was useful, and we look forward to sharing more insights into the Power Platform world.
