Hi all,
I am creating an predictor app and as part of this I am adding a container where I want to be able to show the current users results based on whether they have achieved a 1st, 2nd or 3rd place.
in my data table, i want to refer to the 'UserName' column, where the registered users 365 username is stored, and the 'Points' column, where a seperate part of the app posts each users points based on what their prediction was (5 for 1st, 3 for 2nd, 1 for 3rd, -1 for getting it wrong)
Currently, I am using the below in the Text property of my label within the container.
"First Place: " & CountRows(Filter(Predictions, UserName = varcurrentUser.UserName And Points = 5))
This isnt returning any errors, but is returning a "0" when it should be returning a "1" as there is one entry in my table which matches these conditions.
Can anybody help to point out what I am missing?
