I am having difficulty with the TO expression in a workflow.
SELECT(Users[USER_EMAIL],AND(IN(5,{[GET_URGENT]}), [KEY_PRAYER]<>TRUE, IN([_THISROW].[DPT_NO],{[DPT_NO]})))
in the Users table, GET_URGENT and DPT_NO are both ENUM LIST. That is why I am using the IN(). On the record trigger this workflow (Requests table), DPT_NO is always a single value, Type REF.
This is what the log shows. It appears my condition is working properly but the expression is not finding a match and I know there are multiple users that match my test record.
Thanks.
Properties:
{
โAppTemplateVersionโ: โ1.000235โ,
โRuleNameโ: โUrgent_Notification_Scope_11_by_DPT_NOโ,
โEventTypeโ: โChangeโ,
โInvokedByโ: โUpdateโ,
โServerNameโ: โINSTANCE-US-EASโ,
โServerRegionโ: โus-east4-gcp-prodโ,
โIgnoreSecurityFiltersโ: false,
โTableNameโ: โRequestsโ,
โRuleTableNameโ: โRequestsโ,
โOperationUpdateModeโ: โUPDATES_ONLYโ,
โEventMatchโ: โWorkflow event successfully matchedโ,
โConditionโ: โ=AND([SCOPE_NO] = 11, [_THISROW_AFTER].[Urgent]=TRUE,[_THISROW_BEFORE].[Urgent]<>[_THISROW_AFTER].[Urgent], ISNOTBLANK([DPT_NO]))โ,
โMatchesConditionโ: โTrueโ,
โActionNotPerformedโ: โ1 errors present.โ,
โActionResultsโ: โCreated 1 ActionResultsโ,
โAction Typeโ: โEmailโ,
โAction Nameโ: โUrgent Email Notificationโ,
"Errors": โError: No workflow email was sent because โToโ, โCCโ, โBCCโ are all empty.โ,
โEmailToโ: โโ,
โEmailCCโ: โโ,
โEmailBCCโ: โโ,
โEmailFromDisplayโ: โโRequests Appโโ,
โEmailReplyToโ: โnoreply@appsheet.comโ,
โEmailPreHeaderโ: โUpdate to application โRequestsโ at โ9/12/2020 9:43:04 AMโโ,
โEmailSubaccountโ: null,
โEmailSubjectโ: โNew Urgent Prayer Request for Global Mobilization; Prayerโ,
โEmailTitleโ: โAlert: Update to application โRequestsโ table โRequestsโโ,
โEmailAttachmentโ: โโ,
โEmailOtherAttachmentsโ: โโ,
โAppTemplateNameโ: โ922dbed2-5196-4caa-9581-401fc815a472โ,
โOperationโ: โWorkflow actionโ,
โResultโ: โFailureโ
}
Solved! Go to Solution.
I believe you could try the expression without curly brackets around [GET_URGENT] and [DPT_NO] as these both are already enumlist type columns. So I believe curly brackets to define the list of elements are not required.
SELECT(Users[USER_EMAIL],AND(IN(5,[GET_URGENT]), [KEY_PRAYER]<>TRUE, IN([_THISROW].[DPT_NO],[DPT_NO])))
I believe you could try the expression without curly brackets around [GET_URGENT] and [DPT_NO] as these both are already enumlist type columns. So I believe curly brackets to define the list of elements are not required.
SELECT(Users[USER_EMAIL],AND(IN(5,[GET_URGENT]), [KEY_PRAYER]<>TRUE, IN([_THISROW].[DPT_NO],[DPT_NO])))
Thank you so much. It worked!
I just realized that I need to move that expression to the BCC line. Do you have to have a TO?
Sorry, I am anware if that is possible.
Thanks. Thatโs what I figured. I created an email account specifically to receive the notifications. I didnโt want them clogging up the account owners email address.
Got it , thank you.
Yes TO field needs at least one email address.
User | Count |
---|---|
60 | |
25 | |
13 | |
11 | |
6 |