Hi All,
Have the below in an OnStart rule for my canvas app. varSurveyInstanceId is set by a parameter which is optional.

If(
IsBlank(varSurveyInstanceId),
Set(
varEmployee,
LookUp(
Employees,
Email = currentUser.Email
)
);
Set(
varSurveyInstanceId,
LookUp(
SurveyInstances,
EEID = varEmployee.EEID,
SurveyInstance
)
);
Set(
varSurveyInstance,
LookUp(
SurveyInstances,
SurveyInstance = varSurveyInstanceId
)
),
// Work backwards from valid surveyInstance to get user
Set(
varSurveyInstance,
LookUp(
SurveyInstances,
SurveyInstance = varSurveyInstanceId
)
);
Set(
varEmployee,
LookUp(
Employees,
EEID = varSurveyInstance.EEID
)
)
);
I'm continuously getting the error "Multiple levels of many to one expansion aren't supported" on this block of code, and I'm not certain why or how to further troubleshoot. I'm using variables to store intermediate values like the SurveyInstance, and EEID is a proper column in the SurveyInstance table to try and avoid this scenario.
Any suggestions on where I may be expanding a many to one relationship more than once?

