Hi,
I have just opened up a canvas app to do some enhancements and some errors have now appeared, which were not there before.
The canvas app consumes data from Datavers tables.
Has the syntax changed in the last 6 months?
I now get the incompatible type error for the "'OneFile Unit'.'OneFile Unit' = 'OneFile Unit'"and I really cannot understand why as this worked fine before. It appears that the programme is trying to compare a guid with a record, however the ClearCollect is only adding the guid column to the collection.
ClearCollect(
colOneFileStandards,
AddColumns(
Filter(
'OneFile Standards',
'Onefile Apprenticeship Standard/Framework'.'OneFile Framework Template' =
LookUp('Learning Assignment Submissions','Learning Assignment Submission' = [@ModelDrivenFormIntegration].Item.'Learning Assignment Submission').'Base Qualification'.'OneFile Framework Template'
&&
'Standard Type' = [@'Standard Type'].Programme
),
"OneFileStandardId",
'OneFile Standard'
)
);
ClearCollect(
colOneFileStandardIDs,
colOneFileStandards.OneFileStandardId
);
Clear(colOneFileUnits);
ForAll(
colOneFileStandardIDs,
Collect(
colOneFileUnits,
Filter(
'OneFile Units',
'OneFile Standard'.'OneFile Standard' = OneFileStandardId
)
)
);
ClearCollect(
colOneFileUnitIDs, colOneFileUnits.'OneFile Unit'
);
Clear(colLearningOutcomes);
ForAll(
colOneFileUnitIDs,
Collect(
colLearningOutcomes,
Filter(
'OneFile Learning Outcomes',
'OneFile Unit'.'OneFile Unit' = 'OneFile Unit'
)
)
);
