Invalid Expression - Workflow

Guys, can you help?

3X_8_b_8b90e0900fa0293813a6a2729b09c9e803ed5f29.png

On a workflow templare (docx) I need to pull the [BranchName] from table Admin" where [Branch] of this row = [Branch] in “Admin”.

The error is below:

Failed: Action not performed because 2 errors are present. Error: Workflow rule ‘Email Customer Quote’ action ‘EmailCustQuote’ Attachment template. Expression ‘FILTER(“Admin”, AND([Branch]=[_THISROW].[Branch]))’ is invalid due to: Condition AND(([Branch] = [ID].[Branch])) has an invalid structure: at least 2 subexpression(s) required. Error: Workflow rule ‘Email Customer Quote’ action ‘EmailCustQuote’ Attachment template. Start expression ‘FILTER(“Admin”, AND([Branch]=[_THISROW].[Branch]))’ should generate a List of Ref values. Please verify that it generates a List and that the contents of the List are Ref values. Ref values should come from the ‘Key’ column of the referenced table…

But I don’t understand why this is.
Can you guys help with this?
Much appreciated.

0 10 636
10 REPLIES 10
Top Labels in this Space