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>>
Solved! Go to Solution.
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.
User | Count |
---|---|
43 | |
29 | |
25 | |
23 | |
13 |