Empty Workflow Attachment

[Sarah_Keown]

Can anyone help me spot any immediate issue with the below workflow.

I’m trying to save a file that is triggered when a form is completed on the app. Users will complete the form and mark as Sign Off Required - this record is saved in a file.

Two columns of importance

1. Sign Off Required
2. Sign Off Sent

So initially the sign off sent value is going to be no, its not until the workflow is triggered that it actually changes to yes, that way Im not accumulating data I’m sending out individual records to be approved each time.

Sign off required can be set to Y or N, if it is required it should trigger the workflow.

The workflow saves the file but it keeps coming up blank, yet the view I created in the app slide/view comes up correctly.

Workflow Condition:

Template expression:

Slice/View created with same workflow content:

Table content:

Not sure what is happening but the result is a blank attachment

[JuneCorpuz]

You can go to Log and find the name of your workflow and check the error there

[Sarah_Keown]

Yeah I tried this also, great tool for workflows but its all coming back as successful so it’s obviously something within the actual expression contradicting itself

[JuneCorpuz]

Have you checked if you are using the correct file for your template?

[Sarah_Keown]

Yes its a word document template for a PDF

[Aleksi]

If the result in the PDF is just a header “Invoice Queries - Sign Off required”, it means that the template itself is working but the result of the Start: & End is an empty list. It doesn’t show any << End >> on your print screen so do you have it?

[Sarah_Keown]

Yeah its there, here is the entire thing

[Aleksi]

Okay. Then the reason is coming from the blank list.

[Sarah_Keown]

I applied the same expression in a slice and got these coming through so the data is there?

[Aleksi]

Is the “Order No” a key column?

[Sarah_Keown]

Yeah it is

[Aleksi]

If you add a virtual column with the same SELECT(…) formula, does it show a blank list?

[Sarah_Keown]

Yes it does

[Aleksi]

So… if that is giving you a blank list, then your evaluation doesn’t give any TRUE value for your records. You should test it a little what could be the reason. Start for example with TRUE.

[Sarah_Keown]

Here is a snippet of the TRUE columns, so I dont quite understand. Everything marked as TRUE without a sign off status should be reported

[Aleksi]

I mean SELECT(Accounts[Order No],TRUE)

[Sarah_Keown]

Thanks for everyones help, think I have sorted it now.

The excel was outputting TRUE/FALSE statements but it was really Y/N

[Sign Off Required]=“Y” as opposed to true.

Thanks everyone

[Steve]

Or don’t compare it to anything. This:

[Sign Off Required]

is equivalent to (and marginally more efficient than):

[Sign Off Required]=TRUE

Likewise, this:

NOT([Sign Off Required])

is equivalent to:

[Sign Off Required]=FALSE

[Aleksi]

It should work with the TRUE statement. Instead of using “TRUE”, write just TRUE.