[_THISROW] in nested start expression

If I have nested start expressions in a template, does the THISROW expression change to the the row selected in the start expression once it hasn’t reached the END expression or does it always refer to the row that triggered the template?
For example in the below, does the _THISROW in the second start expression refer to “ProjectDetails” row selected or the same row that the _THISROW in the first start statement points?

<<Start: Filter("ProjectDetails", [StartDate] > [_THISROW].[Date])>>
             ........
              
             <<Start: Filter("ProjectActivities", [ProjectID#] = [_THISROW].[Project Name])>>
                     ........
             <<End>>

 <<End>>

Hello @Cathal_Noone, first let me show you the best explanation there is for [_THISROW], it applies to both regular expressions and workflows.

By looking at the masterfully explained diagram, we can see that [_THISROW] is always going to refer to the origin row.

4 Likes

Thanks a million @Rafael_ANEIC-PY, that is exactly what I was looking for.

2 Likes

I’m facing the same and I know I could resolve by introducing a new VC that can be consumed by the nested Start but I would rather avoid that if possible.

So I’m curious how you solved this problem?

If you have a look at Rafaels post the solution is in the attached FAQ. Essentially, use [_THISROW-1] to go up one level to the previous start, [_THISROW-2] to go up 2 levels, etc…

2 Likes

Ah, I didn’t quite gather that’s what you needed. I have a different need. I’ll continue searching and open a Question if I can’t find the answer. Thank you for the response.