adding data to a template from a different data source

[Jack_Bates]

I have an Inspection table that has referance table from a different data source.

What i’m having trouble with is writing the expression so that it pulls the information for the inspection ID with all of the referanced data. Per the template image the created expressions do not work. It cannot find those columns.

Referanced tablesData sourcecreated report

[Joseph_Seddik]

Your expressions seem correct. How do you trigger your bot?

[Jack_Bates]

By either creating a new report.

also with a behavior

[Joseph_Seddik]

1. What is the name of the table being referenced by the other three tables shown in your report?
2. What data change exactly is triggering your bot? and on which table?

Please show screenshots of your bot. Thanks.

[Jack_Bates]

All of the Referenced Tables are part of the Inspection Table. Data source =“Equipment”

Each Referenced table is from a different data source ,Data source =“Vehicle Inspections”

Data change is “when a new inspection is done” That triggers a report for “admin”

Also from a behavior that manually triggers a report to “User”Email to Userbehaviorautomatic triggerautomatic email

Inspection Table 

[Marc_Dillon]

This type of error often indicates that a slice is being used that does not contain the mentioned column from the base table.

Maybe check the definition of those Related... columns, do they point to slices or the base table?

[Jack_Bates]

They point to the Base Table

[Jack_Bates]

They come from Ref Tables to the Inspections table