Issue with Execute Action on a set of rows - Referenced Rows

[Daisy_Ramirez]

I have a simple "execute an action on a set of rows" Action in place with Referenced Rows set as follows:

SELECT(project_plan_template[project_template_id],[project_template_id]=[_THISROW].[template])

The action does not work  - doesn't trigger. But, when the Referenced Rows is set to "project_plan_template[project_template_id]"  it works fine - ALL the fields are updated . Unfortunately, I need just records with the particular project_template_id designated in the SELECT statement to be updated.

Note: project_template_id is the key field for the project_plan_template table. Could this be the reason it's not working?  I've used Referenced Rows many times and not sure how I should be configuring this?

Thanks so much!

[TeeSee1 · Accepted solution]

Again, just to be sure your [template] col in the project_plan table contains project_template_id's, i.e 500001 ~13.

[Suvrutt_Gurjar · Accepted solution]

Correct, or is it mix up of key  (Template_Id) and label (Template) may be? Is [Template] having template IDs?