The expectation of the syntax “[Related Children][Column Name]” is to return a list of values from all rows in the child list “Related Children” and the column = “Column Name”.
Using this syntax in the example FILTER() statement shown below, Reference Rows in incorrectly assigned a list of “Items” records associated with ALL rows in the table “Children”, not just the “Children” rows in the “Related Children” list. I.e. it gets 8 rows instead of the intended 3.
Reference Rows = FILTER(“Items”, IN([Item Code],[Related Children][Item Code]))
If I change “[Related Children][Item Code]” to the equivalent SELECT() statement, then the FILTER function works as expected.
To Illustrate this I have created a sample application you can use to test this functionality.
-
Account ID = 526414
-
The app name = “Related Items Tester”
-
The workflow rule = "Process Children.
-
The exact steps to reproduce the problem.
A. Open the app, in the Items view ensure all values are “1”. If not, edit table to change to “1”.
B. Open the Parents view and note Children and Item Code on ALL Parent records.
C. Tap the check mark action on one of the Parents. This sets a flag that triggers the Workflow.
D. When complete, view the Items table and note that ALL children associated with any Parent have updated. Not just the children for the Parent record the action was executed on. The expectation is that only the Item rows associated with the “Related Children” would have updated.
-
You have my permission make any changes to this app you need.
As a side note, the paper airplane icon executes a different action that is exactly the same as the one triggered from the Workflow. However, it does not process anything at all. Why?
Please do let me know if you need more information/clarification on these details.
Thanks!
John Baer
LinkedIn
Twitter
