//Collection to get all exercises in the current workout selected
ClearCollect(
WorkoutSelectedExerciseDetail,
ShowColumns(
AddColumns(
Filter(
'Workout Details',
Workouts.Workouts = galWorkoutsMain.Selected.Workouts && 'Created By'.'Primary Email' = User().Email
),
tmp_exerciseName,
Exercises.Name
),
tmp_exerciseName
)
);
// Collection to populate combobox with all exercises not in Workout
ClearCollect(
workoutSelectedComboexercises,
Filter(
Exercises,
'Created By'.'Primary Email' = User().Email And IsBlank(
LookUp(
WorkoutSelectedExerciseDetail,
tmp_exerciseName = Name
)
)
)
);
What this does is basically create a collection [WorkoutSelectedExerciseDetail] which helps me select all the Exercises in a given workout. Then [workoutSelectedComboexercises] is expected to compare those exercises against all the exercises available in the [Exercises] table and only show those which are not in the workout yet, like in screenshot1. However, you can see I am getting delegation errors with Lookup, filter, countrows, blank(), etc. when these functions are supposed to be delegable [Screenshot2]. I am comparing 2 texts.
Am I missing something? I am trying to get rid of that delegation error trying as many alternatives as possible, but I am a bit dumbfounded as to what is causing this delegation issue. Thank you!
