Help With a Formula in a workflow

I’m working on a Inspection survey app.

What I’m looking for is a notification (workflow) that checks if the amounts of defects for an
specific Employee, for today and for an specific group is Greater that X number that comes from an other table, if so… advice me!!

This is my formula:

AND(
SUM(
	SELECT(
  	Inspection Detail[# Defects],
    AND(
    [Employee] = [_THISROW].[Emplyee],
    [Date] = TODAY(),
    [Group]="Group #10"
    )
  )
) > 

ANY(
	SELECT(
  	Alerts[Maximun Amount of defects],
    [Defect]=[_THISROW].[Defect]
  )
)
,
[_THISROW_BEFORE].[ID Inspection Detail]<>[_THISROW_AFTER].[ID Inspection Detail])

It looks mostly correct to me. How is it not working? Have you tried splitting the expression into smaller parts and confirming that they are working as expected?

Perhaps just a simple typo?

image


I do not understand what this part is for, is it pertinent?

Hi @Marc_Dillon !!.

The [Employee] was a type error, but is not the main problem.

I do not understand what this part is for, is it pertinent?

This is because sometimes I get multiples notifications for the same record, so that is a way to avoid that

Perhaps you should use a report rather than a workflow? Then you can guarantee the notification gets sent only once.

1 Like

I’ll Do it

1 Like