Power Platform Community Forum Thread Details

I have two fields: Module and Region. I want to set the 'RBA Team_DataCard', which is a combo box of groups, to the appropriate group based on the selections made in the Module and Region fields.

Rather than setting variables OnChange with duplicate code, I am trying to use a Named Formula that will pick up the correct group based on the values in the Module and Region fields.

If I set a label's text property to RouteToRBATeam.DisplayName, everything works as expected given these named formulas:

fModule = Module_DataCardValue.Selected.Value;
fRegion = Region_DataCardValue.Selected.Value;

RouteToRBATeam =
 With(
 First(
 Filter('MyCarestream Requests - Routing',
 'Support Level' = 1 And 
 Module.Value = fModule And
 Region.Value = fRegion
 ).'Route To'),
 {
 Claims: ThisRecord.'Route To'.Claims,
 DisplayName: ThisRecord.'Route To'.DisplayName,
 Email: ThisRecord.'Route To'.Email,
 Picture: ""
 });

However, when I try 'RBA Team_DataCard'.Default = RouteToRBATeam, I get the following error, "This rule creates a circular reference between properties, which is not allowed. A property cannot reference itself or other properties affected by its value. This is the shortest circular reference: 'RBA Team_DataCard'.'Default' -> 'RBA Team_DataCard','Default'."

I get similar errors if I try RBA_DataCardValue.DefaultSelectedItems = RouteToRBATeam

Here's what I've figured out from debugging:

If I replace the named formulas fModule and fRegion with their expressions directly, the results are the same
If I hard-code the Module and Region filters rather than referencing the dynamic field selections then RBA_DataCard.Default = RouteToRBATeam works perfectly.
Setting a label's Text property = "Region: " & fRegion works as expected

RouteToRBATeam =
 With(
 First(
 Filter('MyCarestream Requests - Routing',
 'Support Level' = 1 And 
 Module.Value = "Business Workspace" And
 Region.Value = "GCC"
 ).'Route To'),
 {
 Claims: ThisRecord.'Route To'.Claims,
 DisplayName: ThisRecord.'Route To'.DisplayName,
 Email: ThisRecord.'Route To'.Email,
 Picture: ""
 });

Thank you for your help!

Categories:

Building Power Apps