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.
Yes, am updating the collection at several places but this is only data that is being missed on screen switch. I will run the tool and check whats happening.
Hi RameshMukka,
That's some unusual behavior you're seeing. Are you updating your collection anywhere else in the app?
Have you tried using the Monitor tool to debug this and see what might be updating that column in the collection?
Tom
WarrenBelz
770
Most Valuable Professional
stampcoin
494
MS.Ragavendar
399