I am creating a collection at OnVisible property of the screen1. Below is my code snippet. Though I am adding several columns using AddColumns but value of the column AvgPFTDRating disappear from collection when I navigate to different screen from screen1.
ClearCollect(
ColPFTD,
AddColumns(
AddColumns(
ShowColumns(
FirstN(
SortByColumns(
Filter(
'OTJ Coaching Session_1',
'PSR Name'.DisplayName = DataCardValue4.Selected.DisplayName
),
"CurrentDate",
Descending
),
3
),
"CurrentDate",
"PSRName",
"onetofivePFTD",
"sixtotenPFTD",
"eleventofifteenPFTD",
"sixteentolastcallPFTD"
),
"FormattedCurrentDate",
Text(
CurrentDate,
"[$-en-US]dd-mmm"
),
"onetofivePFTDRating",
If(
ThisRecord.onetofivePFTD.Value = "Poor",
1,
ThisRecord.onetofivePFTD.Value = "Average",
2,
ThisRecord.onetofivePFTD.Value = "Good",
3,
ThisRecord.onetofivePFTD.Value = "Very Good",
4,
ThisRecord.onetofivePFTD.Value = "Excellent",
5
),
"sixtotenPFTDRating",
If(
ThisRecord.sixtotenPFTD.Value = "Poor",
1,
ThisRecord.sixtotenPFTD.Value = "Average",
2,
ThisRecord.sixtotenPFTD.Value = "Good",
3,
ThisRecord.sixtotenPFTD.Value = "Very Good",
4,
ThisRecord.sixtotenPFTD.Value = "Excellent",
5
),
"eleventofifteenPFTDRating",
If(
ThisRecord.eleventofifteenPFTD.Value = "Poor",
1,
ThisRecord.eleventofifteenPFTD.Value = "Average",
2,
ThisRecord.eleventofifteenPFTD.Value = "Good",
3,
ThisRecord.eleventofifteenPFTD.Value = "Very Good",
4,
ThisRecord.eleventofifteenPFTD.Value = "Excellent",
5
),
"sixteentolastcallPFTDRating",
If(
ThisRecord.sixteentolastcallPFTD.Value = "Poor",
1,
ThisRecord.sixteentolastcallPFTD.Value = "Average",
2,
ThisRecord.sixteentolastcallPFTD.Value = "Good",
3,
ThisRecord.sixteentolastcallPFTD.Value = "Very Good",
4,
ThisRecord.sixteentolastcallPFTD.Value = "Excellent",
5
)
),
"AvgPFTDRating",
Value(
Text(
Average(
onetofivePFTDRating,
sixtotenPFTDRating,
eleventofifteenPFTDRating,
sixteentolastcallPFTDRating
),
"[$-en]#.##"
)
)
)
)
My collection when I am on Screen1.
The same collection when I navigate to another screen from screen1.
