You are viewing limited content. For full access, please sign in.

Question

Question

For each row action is only acting on first row in custom query

asked on November 7, 2023

My custom query is a 'select *' statement from a table. All rows in the query need to be sent an email. There is an email address in each row.

There are only 5 rows in my test table (the production run will be more than 5).

When executing the workflow, I receive 5 emails that are all only the first row, vs. 5 unique emails.

I originally had conditions, but to troubleshoot, have now simplified the workflow to the following and still receive 5 emails. The other 4 emails should go to 4 other individuals. I do have myself bcc'd in the actual email, but as I said, I am receiving 5 of the exact same email.

.

 

0 0

Answer

SELECTED ANSWER
replied on November 7, 2023 Show version history

You are close! You will want to use the "For each row" tokens instead of the ones associated with the Custom Query as those always look at the first row. If they are not showing up in the for each row activity, you may need to test your query so it refreshes columns.

2 0
replied on November 7, 2023

Ugh! Such a simple thing!!! Thank you!!!

0 0

Replies

You are not allowed to reply in this post.
You are not allowed to follow up in this post.

Sign in to reply to this post.