Workflow triggered successfully but yielding no results

[Elijah_Magrane]

Good Day,

I am experiencing a bizarre result when trigger a scheduled report.

I have created a very simple template expression…

<<Start: Daily Report[ID]>>
  Q1: <<[TEMPLATE].[Q1]>>
  OPT1: <<[OPT1]>>
<<End>>

The result is successful however, this is the result perplexing to me. Moreover, when I avoid the template expression altogether and just enter the columns directly in the email body (without a template) I get this error

Any help would be appreciated

ScheduledReport (2).pdf (12.5 KB)

[Bellave_Jayaram]

Try
SELECT(Daily Report[ID], TRUE)

[Elijah_Magrane]

Using <<Start: Select(Daily Report[ID], TRUE)>> yields the exact same results

[Steve]

Elijah_Magrane:

Q1: <<[TEMPLATE].[Q1]>>

Does the Daily Report table have a column named TEMPLATE? The report generator thinks not.

[Elijah_Magrane]

Indeed it does have a [TEMPLATE] column, it is a ref. I have tried other columns as well and it makes no difference. Same behavior

[Steve]

My question was bad:

Steve:

Does the Daily Report table have a column named TEMPLATE ?

Your <<Start>> tag is this:

<<Start: Daily Report[ID]>>

which means column references between that <<Start>> tag and its <<End>> tag will refer to columns of the rows identified by the [ID] values, NOT columns of the Daily Report table. Does the table to which the values of the ID column refer have a TEMPLATE column?

[Elijah_Magrane]

Yes, the Daily Report is just a slice, all of the columns of the Daily Report[ID] are included in the slice, including the Template column

[Steve]

Please post a screenshot of the configuration screen of the ID column of the Daily Report table/slice.

[Elijah_Magrane]

Slice (the row filter condition is working as intended. There are entries , regardless, I have tried to completely remove it-no difference)

Table

Id Column settings 1 0f 2

Id column settings 2 of 2

[Steve]

Does View Data display the rows you expect?

[Elijah_Magrane]

Yes,

Taken from slice

[Steve]

Hmm. Looks good there.

Please post a screenshot of the configuration of the Template column of the Inspections table.

[Elijah_Magrane]

I originally thought this may have been the issue but no matter the column I throw in the template the results are the same

[Steve]

Well, I’m at a loss! I’m going to have to refer you to support@appsheet.com so someone there can look deeper. Once you’ve figured it out, I’d appreciate if you’d share the fix here in the community. I’m definitely curious!

[Elijah_Magrane]

Thanks, @Steve. I will open a ticket and definitely post an update.

I appreciate it

[Elijah_Magrane · Accepted solution]

Update: it appeared as though my security filters were causing the issues.

I bypassed them and I was able to generate a proper workflow. Still confused as to why considering I was not one of the users who would have been affected by the filtered data.

Regardless, thanks for the assistance