Power Platform Community Forum Thread Details

I'm out of ideas, hoping someone can help with this tricky problem.

I have a SharePoint list structured like below:

Created	EmployeeString	Failed?
11/5/2020	John	No
12/18/2020	Eric	No
12/23/2020	John	Yes
1/20/2021	Eric	No
1/26/2021	John	No
2/5/2021	Eric	No

My first automated flow requested me to send an email every time the employee failed which was a simple process. Now I am requested to send the same email while also including the count of failures over the last 2 months.

I am aware that SharePoint rules indicate "You cannot reference a value in a row other than the current row". As such, adding an additional SharePoint column is not a valid solution here.

I'm able to determine the formula in Excel due to reference privileges if it's helpful at all:

=COUNTIFS([Created],">="&EDATE([@Created],-2),[Created],"<="&[@Created],[EmployeeString],[@EmployeeString],[Failed?],"No")

But even if I triggered the SharePoint list to add/update rows in Excel, I'm unaware of any ability to send an email based on a trigger of every time a row is added to an Excel sheet. This also seems like an overly complicated solution. Any ideas would be much appreciated!

Categories:

Building flows