Quote from supportTeam on July 2, 2025, 3:15 pm

Hi Archie,

Please let us know if there's a link between items in Table 1 and Table 2 that we can use to fetch the email from Table 2 and populate it in the person column in Table 1.

Quote from skigeek on July 2, 2025, 4:04 pm

There is not really. I probably could create one. I was not thinking on doing that, I was focused on querying across the two tables using the two fields itentified. 1 is a person and the other is the single line txt. I was thinking that there might be a function call on the person field that would return the email. Hope that makes sense.

Quote from supportTeam on July 4, 2025, 10:22 am

Hi Archie,

To query items from Table 2 based on the email address in the Person column (p1) from Table 1, you can achieve this by using form event actions. Please follow the steps below:

1. Open the NITRO Form settings of Table 1
2. On the top, click on variable → Click on ‘New Variable’ → Name it as ‘varPersonEmail’
3. Click on ‘Form event actions’ on the left under advanced → Click on ‘New configuration’
4. Configure the form event action settings as required
5. Under new action, click on ‘Set variable value’
   1. Give it a name and click on ‘new mapping’
   2. Select the variable ‘varPersonEmail’, configure the value as ‘$getspuserproperty([Display Name|Internal Name],email)’ as seen in image 1 and save it
6. Under new action, click on ‘Fetch items’
   1. Configure the settings as shown in image 2 and save it, the syntax used in the condition is ‘%%varPersonEmail##value%%’

Please let us know if you want to populate the values from the retrieved item into a column. We will guide you through the steps accordingly.

Quote from skigeek on July 7, 2025, 9:30 am

Works like a charm. Very much appreciated..