Announcements
This site is in read only until July 22 as we migrate to a new platform; refer to this community post for more details.

Workflow is not working

My tables are as given below.
Table 1 Master Inspection details
Table 2 Child inspection where all checkpoints to be attended. The checkpoints are derived from another table.
Table 1 relates with Table 2.

Want my workflow on table 1 where defined checkpoints are attended. Therefore, create a virtual column “Inspection status” with below expression.

IF(COUNT(SELECT(Inspection Template[Checkpoint], [Fleet Type]= [_THISROW].[Fleet Type])) = [Questions Attended], “Completed”, “Incomplete”)

On workflow, in Update event “ALL_CHANGES” and Condition "[Inspection Status] = “Completed”.

But workflow is not working.

0 8 1,033
8 REPLIES 8
Top Labels in this Space