My app is not deployed, but Iโm sending the report with the โRunโ button. On โSend to:โ is an expression [Key column].[Email column] of the table set for the report. But it returns the following error:
Properties:
{
โAppTemplateVersionโ: โ1.000325โ,
โRuleNameโ: โGrado avance Tareasโ,
โEventTypeโ: โScheduledโ,
โInvokedByโ: โEditorRunButtonโ,
โServerNameโ: โprodu3c1a0001MCโ,
โServerRegionโ: โWEST-EUโ,
โIgnoreSecurityFiltersโ: false,
โEventMatchโ: โWorkflow event successfully matchedโ,
โForTableNameRowsโ: โTable or slice โTareasโ returned 42 rowsโ,
โActionNotPerformedโ: โ1 errors present.โ,
โActionResultsโ: โCreated 42 ActionResultsโ,
โAction Typeโ: โEmailโ,
โAction Nameโ: โAction 1โ,
"Errors": โError: No workflow email was sent because โToโ, โCCโ, โBCCโ are all empty.โ,
โWarningsโ: โWarning: App version 1.000325 is not deployed. All workflow emails are therefore being sent to the app creator. This email should have gone To โโ CCโed to โโ and BCCโed to โโโ,
โEmailToโ: โguillesaez89@gmail.comโ,
โEmailCCโ: โโ,
โEmailBCCโ: โโ,
โEmailFromDisplayโ: โguillesaez89@gmail.comโ,
โEmailReplyToโ: โnoreply@appsheet.comโ,
โEmailPreHeaderโ: โScheduled rule โGrado avance Tareasโ for application โTailorProjectโ invoked at 27/05/2020 9:31:51\r\n[App version 1.000325 is not deployed. All workflow emails are therefore being sent to the app creator. This email should have gone To โโ CCโed to โโ and BCCโed to โโ]\r\nโ,
โEmailSubaccountโ: โFreeAccountโ,
โEmailSubjectโ: โScheduled rule โGrado avance Tareasโ for application โTailorProjectโ invoked at 27/05/2020 9:31:51โ,
โEmailTitleโ: โScheduled rule โGrado avance Tareasโ for application โTailorProjectโ invoked at 27/05/2020 9:31:51โ,
โEmailAttachmentโ: โโ,
โEmailOtherAttachmentsโ: โโ,
โAppTemplateNameโ: โ3617c72d-1df3-4360-8ce3-05da38067d4aโ,
โOperationโ: โWorkflow actionโ,
โResultโ: โFailureโ
}
Can someone help me with this?
Thanks in advance!
Solved! Go to Solution.
@Lynn I donโt think that will work. He wants one email per manager, so he wants to have grouping performed over the table (by manager email) and then one email sent per group with all the tasks in the group.
@Guillermo to achieve this, you might think of structuring your data differently. Think of having a table of Managers and then a table of Tasks. Then your scheduled rule can work ForEachRow in the Managers table and send an email with a single template doc (inside which it use the Start-End placeholder pattern to collect all the related Tasks and show them)
Hi @Guillermo
Does it work if you clear the To box and save. and Run. It should go to your email as app is not deployed.
I think the problem is that that the expression used to compute the To property returns no value.
It looks like a deref expression. Either the ref itself ([Tarea]) is null or it references a missing row in the other table or the [Email] column on that referenced row is empty. That would be my guess.
Hi @Lynn, Thanks so much for your replay.
I left only to rows because is a forEachRow Report and it works
It sent me 2 emails
Hi again @Lynn, @praveen, It was my mistake, I was trying to do a dereference following some steps of a guide, but i didnโt need to because I was on the same table , so with โsend to: [email column]โ was enough. The problem is that I would like that instead of one email for each row it could create a unique email with all the tasks assigned to this email. For example I have 40 tasks and 5 managers ( 8 tasks per manager). I only want one email with the 8 tasks for each manager.
Can you help me with that?
Thank you so much for your help
Hi @Guillermo
Try selecting
@Lynn I donโt think that will work. He wants one email per manager, so he wants to have grouping performed over the table (by manager email) and then one email sent per group with all the tasks in the group.
@Guillermo to achieve this, you might think of structuring your data differently. Think of having a table of Managers and then a table of Tasks. Then your scheduled rule can work ForEachRow in the Managers table and send an email with a single template doc (inside which it use the Start-End placeholder pattern to collect all the related Tasks and show them)
@praveen , @Guillermo
OOPs Sorry skimmed over your reply too fast . Praveen has the answer.
User | Count |
---|---|
36 | |
33 | |
27 | |
23 | |
18 |