Event when TO DO list is Over

Hi guys, Im trying to trigger an event when my To-Do has all task compleated.

I got this table call TODO

ID TASK Finished? (yes/no)

I got the event on UPDATES only
with the following condition:

Count
(
	FILTER(
  	TODO, [FINISHED?] = False
  )
) = 0

This actually works pretty well but Iโ€™m concerned about performance on big data.
My question is:

  • Do you know any more simple or elegant way to do it?
  • Do you know if actually Bots process on Parallel and this will not bring a SYNC TIME ISSUE?

THANKS!

Solved Solved
0 4 162
1 ACCEPTED SOLUTION

I would not consider 2000 records to be very big.

I believe the following would also work, and probably would be more performant. But really, thatโ€™s not an expensive expression to start with.

ISBLANK( TODO[Finished?] - LIST( TRUE ) )

View solution in original post

4 REPLIES 4
Top Labels in this Space