In reply to: Daniel Krüger (Cosmo Consult)
Hi Flo,
do you want to use the for each row function in a form rule or the for each operator in an automation:
The later one is documented here:
https://community.webcon.com/posts/post/for-each-operator/319/3
If it's in the form rule you can use the get row value function.
Select values will return all values from all rows therefore this will probably not work as intended.
If you need more information feel free to write a bit more about your case.
Best regards,
Daniel
Hi Daniel,
thanks for the link.
The guide shows how to start a sub-Wf with For Each.
I'm looking to do something with each row from an item list with an Active Directory Action plus an Update Related Workflow Instance Action (See Screenshot)
The item list contains a column named 'Mkz'. This I want to use to write to AD and update the related Wf-instance.
So, I thought I could iterate through each row and grab each row's value with SELECT VALUES.
Unfortunately, and as you confirmed, this collects all 'Mkz' values from all rows.
This means that if I only had one row, it all works as intended. But as soon as I add another both actions will attempt to update the AD field ad related Wf field with multiple values.
And this is the main issue.
Moreover, the values I'm mapping to the fields for these two actions are determined by business rules. They work with SELECT VALUES but like we said, only for the first row.
BR evaluate one column of the item list and if it matches a value (like 0 or 1) then another item list column value will be returned which is the one to be used for the AD and update related Wf-instance actions:
IF[GET IDs[SELECT VALUES[Item list | Column]]] = [VALUE] THEN [GET IDs[SELECT VALUES[Item list | Column]]]
Long story short, how can I get the For Each action to use the business rule to return only the current row's value instead of pooling them?
Hope that helps.
Thanks for your help.
Hope that helps.
P.S. I can only ever attach one screenshot, is that right?