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”.
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?
How many PMC records can you have that belongs to Detail record?
At least this could work… IN(TRUE,[Related PMCs][Need corrective action])
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?
The reason is probably missing [_THISROW]…
LOOKUP([_THISROW].[ID],“PMC detail”,“PMC ID”,“Need corrective action?”)=“Yes”
Thank you
You’re welcome
