Hi Community,
Is there anyone who might be able to help me with the code below? I am trying to filter a lookup column, by the value of another lookup column on the same page.
Specifically, my column "PrimaryContact" should be filter Contacts where the "Account" is equal to the "UsrCompanyName" of the same page.
I've tried many things in the "Value" for rightExpression, but can't seem to get it to work. The rest of the code seems okay because if I add a Guid of an Account to the value, it filters fine.
Thanks!
"LookupAttribute_j53fgnq_List_BusinessRule_Filter": {
"value": {
"filterType": 6,
"isEnabled": true,
"items": {
"CustomFilters": {
"filterType": 6,
"isEnabled": true,
"items": {
"cb855fc4-4526-475a-beea-8e41a7f5a439": {
"comparisonType": 11,
"filterType": 1,
"isEnabled": true,
"leftExpression": {
"expressionType": 0,
"columnPath": "Account"
},
"rightExpression": {
"expressionType": 2,
"parameter": {
"dataValueType": 1,
"value": "$PDS.UsrCompanyName.Id"
}
},
"trimDateTimeParameterToDate": false
}
}
}
}
}
},