I have two lists - Master, Child. Master has account number. Child has lookup for account number and then items - each account number will have multiple items.
I am attempting to create workflow for Master list that sends an email with the body that includes all the child items for the account number. How do I do this? Array?
MASTER List Columns
ACCOUNTNUMBER
ACCOUNTNAME
EMAIL
CHILD List Columns
Title
ACCOUNTNUMBER (Lookup to MASTER)
ITEM
AMOUNT
Email would look like this:
To: Current Item:EMAIL
Subject: Current Item: ACCOUNTNAME
Body: "Here are the items included:
