Retrieve the Top 3 Records from a SharePoint List

The following retrieve the top 3 records from a SharePoint list, using the following formulas:

1. Gold: The highest score:
• First(SortByColumns('Quiz Scoreboard', "Score", Descending)).Nickname
2. Silver: The second-highest score:
• Last(FirstN(SortByColumns('Quiz Scoreboard', "Score", Descending), 2)).Nickname
3. Bronze: The third-highest score:
• Last(FirstN(SortByColumns('Quiz Scoreboard', "Score", Descending), 3)).Nickname

The formulas assume that a SharePoint list is named 'Quiz Scoreboard', and it contains columns for 'Nickname' and 'Score'. One can adjust the column names accordingly to match the actual list structure.