Dynamic email workflow sending email to wrong recepient

[mtuwanax]

Hi all,

I have a workflow, that reads in an input file. and creates dynamic files based on two fields: Field1 and Field2, see attached workflow. Unfortunately, my workflow is not sending the correct email to the users, especially if the email address is missing, it randomly sends an email to any email address in the database. Has anyone encountered this issue? Or can someone be able to solve the issue? 

[HomesickSurfer · Accepted solution]

Hi @mtuwanax 

I'm uncertain, however, I suggest that your input field names not be in Row1 as your summarize will group the 'Category' field without and address.

[danilang · Accepted solution]

hi @mtuwanax 

The files that you create don't reference field 1 at all.  The formula that you have is 

[Engine.WorkflowDirectory] + [Field2] + '.xlsx|||Sheet1'

With this setup, you get the same file created multiple times for each recipient with the files just overwriting each other. 

Can you give us a sample of what output should be sent to each recipient?

Dan

[mtuwanax]

Hi @danilang 

Thank you for your reply, and the correction in the workbook flow.

Please find attached the expected output for the first 5 rows of data.

[mtuwanax]

@danilang  & @HomesickSurfer 

Thank you for your replies, these solved my issue.