
Announcements
Sorting by Completion Time in descending order and using Top Count = 1 will return the latest record, but this is not the correct approach.
A better approach is to replace Excel with a SharePoint list. Use the When a form response is submitted trigger, calculate the score in Power Automate, and insert a new item with the score into the SharePoint list. Then, check whether the score exceeds the defined threshold and send an email accordingly.