Power Platform Community Forum Thread Details

I have a Canvas app that is connected to a Dataverse. This app is used for performance evaluations of technicians. I need a way to determine if this technician was scored in their previous evaluation for the same item.

For example, in 'Fulano's' evaluation, he was late last month, so he was scored on 'Punctuality.' This month, he was late again, which is a recurrence in the 'Punctuality' item.

One way to check if he was scored is to compare the score he received in 'Punctuality' with the maximum score for 'Punctuality.' If they are different, he was scored.

In my table, I have columns for the Month, Year, and the Month and Year combined, but I don't want to rely on this data for the search as it could create future issues.

I always need to check for this recurrence, and it is cumulative. However, for it to be considered a recurrence, the occurrences must be in sequence. For example, if he was scored in February and failed again in March, 'Recurrence = 1'; if he failed again in April, 'Recurrence = 2'; but if he didn't make the same mistake in May, 'Recurrence = 0.' These values are stored in a column in Dataverse.

Does anyone have any ideas on how to do this?