Problem with workflow condition

[Mohd_Nur_Arief]

How do i create a workflow with target data named “Details” with the “If this is true” condition is depends on the column that is exist on table named “PMC”.

Table “Details” contain column: ID, Name, Date, address.
While table “PMC” contain column: PMC date, Status, Need corrective action?.

So that the workflow will generate a notification with the “Details” detail in the notification, only when column “Need corrective action” is equal to “yes”.

[Aleksi]

You can use LOOKUP() expression but first you need to have some kind of relationship so you can find the correct record from the PMC table. Are you using a REF field?

[Mohd_Nur_Arief]

Not sure but this might help

[Aleksi]

How many PMC records can you have that belongs to Detail record?

[Aleksi]

At least this could work… IN(TRUE,[Related PMCs][Need corrective action])

[Mohd_Nur_Arief]

LOOKUP([ID],“PMC detail”,“PMC ID”,“Need corrective action?”)=“Yes”

the formula is correct but it does not trigger the workflow, where did i do wrong?

[Aleksi · Accepted solution]

The reason is probably missing [_THISROW]…

LOOKUP([_THISROW].[ID],“PMC detail”,“PMC ID”,“Need corrective action?”)=“Yes”

[Mohd_Nur_Arief]

Thank you

[Aleksi]

You’re welcome