I’m currently trying to add multiple names in the ‘To’ and ‘Cc’ fields from an Excel file.
However, when the draft email is generated via Power Automate, all the email addresses are getting combined into a single string, rather than being separated properly.
For example, in the Excel cell, I have:
'To' - abc@gmail.com; xyz@gmail.com
But in the draft, it appears as one continuous string rather than separate addresses.
Is there a step I’m missing, or do I need to format the email IDs differently — perhaps as separate strings or using a different delimiter?
Below is the body code I’m using (for your reference):
{
"subject": "@{items('For_each')?['Subject']}",
"importance": "Normal",
"body": {
"contentType": "HTML",
"content": "@{items('For_each')?['Body']}"
},
"toRecipients": [
{
"emailAddress": {
"address": "@{items('For_each')?['Email']}"
}
}
],
"ccRecipients": [
{
"emailAddress": {
"address": "@{items('For_each')?['Cc']}"
}
}
]
}
Thanks again for your support!
