Power Platform Community Forum Thread Details

Hello guys,

I have a column (Choice-Column type ) rh_locations with Location A/B/C

Then I have a lookup to a table Phonebook.

My Plan is, based on the selected Location the default view of the subgrid should change to other views I already made (filtered by Location)

I tried the following code in a JSON and made an EventHandler OnLoad of the Form and OnChange on the Choice Column.

The Code doesn't throw an error but it won't work.

var OnBoarding = window.OnBoarding || {};

(
 function() {
 this.setDefaultView = function(executionContext){
 var officeLocation = Xrm.Page.getAttribute("rh_standort").getValue();
 var lookupField = Xrm.Page.getControl("rh_geschaftsnummer");
 // Check the selected office location and set the appropriate view

 if (officeLocation === "Naila") {
 lookupField.setDefaultView("bf3591dd-7eb6-ed11-83fe-0022489ca5c5");
 } else {
 lookupField.setDefaultView("488fdd3f-7fb6-ed11-83fe-0022489ca5c5");
 }
 }
 }
).call(OnBoarding)

Can you help me?

Categories:

Building Power Apps

Hi @RiccoHipp1903,

Not sure if you manage to resolve this, but based on the code, you're referencing the scripts of the lookup control instead of the subgrid. Here's how you would set the default view of the subgrid dynamically based on your code:

var OnBoarding = window.OnBoarding || {};
(
 function () {
 this.setDefaultView = function (executionContext) {

 let formContext = executionContext.getFormContext();
 let gridContext = formContext.getControl("rh_geschaftsnummer");

 let viewToSet = {
 entityType: 1039, // SavedQuery
 id: "3A282DA1-5D90-E011-95AE-00155D9CFA02", //GUID of default view
 name: "Defaukt" //the name
 };

 let officeLocation = formContext.getAttribute("rh_standort").getValue();
 if (officeLocation === "Naila") {
 viewToSet = {
 entityType: 1039, // SavedQuery
 id: "3A282DA1-5D90-E011-95AE-00155D9CF123", //GUID of the view
 name: "Naila"
 };
 } else {
 viewToSet = {
 entityType: 1039, // SavedQuery
 id: "3A282DA1-5D90-E011-95AE-00155D9CFABC", //GUID of the view
 name: "Other" //the name
 };
 }

 gridContext.getViewSelector().setCurrentView(viewToSet);
 }
 }
).call(OnBoarding)