Workflow Emails not picking up referenced fie...

[Michael2]

Workflow Emails not picking up referenced fields

I have

a workflow that includes referenced fields in an email template. These fields show up correctly when testing the workflow but do not show in the email that is sent.

This was working recently and I’m not sure what I may have changed which has had this effect?..

As previously stated, the referenced fields show correctly when testing. I also created VCs in the primary table from which the workflow is run. The fields show correctly there and any views of this table. But, they are not in the email that is sent.

Any ideas that might point me the right direction of where to start looking would be appreciated.

[Aleksi_Alkio]

Would you please show us example what formula is not working, thanks.

[Michael2]

@Aleksi_Alkio

Expression using VCs:

Please have wood picked up at Location ID # <<[AccessLocationID]>>, Circuit <<[Circuit]>>, between pole addresses <<[Beginning Address]>> and <<[Ending Address]>>

When using references:

Please have wood picked up at Location ID # <<[AccessLocationID]>>, Circuit <<[AccessLocationID].[Circuit]>>, between pole addresses <<[AccessLocationID].[Beginning Address]>> and <<[AccessLocationID].[Ending Address]>>.

[Aleksi_Alkio]

I opened your copy app and may I ask if you could add a new row (WoodStumps) with the “normal” way. I can then follow your structure more easily when I can open that record from the audit history, thanks.

[Michael2]

@Aleksi_Alkio Well something has changed on AppSheet’s side I assume as I haven’t worked on my apps all weekend. Logged in this morning to add the row as you requested and… the fields seem to be picked up and are now present in the email. However, there’s a new problem now…

The app you have looked at is a copy of the primary application. The two are essentially identical. The COPY app’s workflows work as intended, all required fields are present in the email that is sent.

The PRIMARY app works as well BUT the emails sent are duplicated. Two identical emails are sent rather than one. Any idea what might be triggering this behavior?

The primary app is VegCrew-285473 The copied app is Copy Crew-285473

[Aleksi_Alkio]

I will check that after few hours.

[Aleksi_Alkio]

You have the same email address in “Send To” and “CC” fields. That’s the same for all workflows.

[Michael2]

@Aleksi_Alkio Don’t you hate when you miss something SO OBVIOUS!!!

I when I first noticed the problem the app was live and I didn’t want emails being sent to the intended ‘To:’ recipient so, I replaced with my email address while I trouble shot the app… I forgot to change it back…

Thank you Aleksi…

[Aleksi_Alkio]

Sometimes it’s too close and you just don’t find it.

You’re welcome.

[Aleksi_Alkio]

They seem to be okay… Have you checked the Audit history? Manage > Monitor > Audit History > Get Audit history records

[Michael2]

@Aleksi_Alkio I have checked the audit history which reports the workflow running successfully. However, the referenced fields are not present in the email that is sent…

[Aleksi_Alkio]

Is it okay if I check your app? If yes, I would need to know the app name and account ID. Thanks.

[Michael2]

@Aleksi_Alkio Yes, please do. CopyCrew-285473 Translate

[Aleksi_Alkio]

Is it a live app?

[Michael2]

@Aleksi_Alkio No, that is a copy of a live app. You can do whatever you like with it.

[Aleksi_Alkio]

What is the workflow name?

[Michael2]

@Aleksi_Alkio Start with Wood Pickup. They are all essentially duplicates with different If_True expressions.