
Hi @topazz11 :
If the data source is a BI dataset, then I am afraid that this requirement cannot be achieved(As far as I mentioned in this post). If you consider using another data source like SharePoint or Excel (saved in OneDrive),you could try this solution:
1\Create a Schedule flow that triggers daily
2\Get all rows form the data source
3\Use the filter array action to filter out records with a percentage greater than 100%
4\Use the apply to each function to traverse the filter results, and send an email to each eligible user in the loop body
Best Regards,
Bof