Forum Discussion
To give a clearer picture on what I was attempting to do, I wanted to trigger a pipeline when a record from table A is updated, search for records in table B that are related, then search for records in table C that have a matching email address from the table B search OR have a specific checkbox in table C checked.
The error in question was due to me trying to use related member from a Search records action without a Loop. For the solution, my pipeline is setup as follows:
Record updated > prepare bulk record set > search records (table B) > Do loop > search records (table C) with matching email address from B and designated checkbox not checked > update record > end loop > end loop > commit upsert > prepare bulk record set > search records (table C) with checkbox checked > loop > update records > end loop > commit upsert
I know that each search result from table B will only return one match from table C (if any) and it's a matter of whether or not that result will have the checkbox in question checked or not. I went with not checked for the sake of this nested loop, so I can do a separate search for those that are checked and update them accordingly. Updating table C, in this case, triggers a notification and I did not want to notify people multiple times off one pipeline run.
So, focusing on the error, you have to use the search results inside a Loop or you will get this type of error. Thanks, again, Doug, for reminding me of that, which allowed me to come up with this solution for my pipeline. Let me know if there are questions, and I will do my best to answer.
------------------------------
James Carr
------------------------------