Guys, can you help?
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.
What donโt you understand?
Hi Steve, the expression looks ok to me, all the elements are there, I canโt see teh invalid structureโฆ
[Branch] Is in both the โAdminโ table and the โCustomersโ table.
The workflow works from the customer table, looks at the admin table and if branch and branch are the same pull the branch name.
Admin only has one row for each branch and branchname.
@Dave_Willett
AND() expression requires at least 2 parameters/sub-expressions to evaluate. The AND expression in your FILTER expression has only one, thatโs the problem. Remove the AND from the FILTER and try:
<<Start: FILTER(โAdminโ, ([Branch]=[_THISROW].[Branch]))>><<[BranchName]>><<End>>
An oversight from my perspective thenโฆ
Iโm testing from the worksflow, thanks for your support guys.
The workflow test says: SUCCESS
Thank you guys.
Youโre very welcome.
Just a thought guys.
Would the expression work if I wanted to have a logo on the top of the template, meaning change the image relating to the branch?
If you set a proper expression for that, yes of course.
Thanks Levent
Youโre very welcome
User | Count |
---|---|
36 | |
31 | |
30 | |
20 | |
17 |