Good Day,
I am working on a simple flow that retrieves my daily calendar meetings/appointment from Outlook and sends me an email with those daily events for quick viewing. It works but I am trying to get the "requiredAttendees" variable to display the emails in a list instead of in a row encapsulated in square brackets.
I am using the split function within the Select action.
trigger:
Recurrence
actions:
- Get events (V4)
- Select
- Create HTML table
- Compose
- Send an email (V2)
In the Select action under Map:
{
"Subject": @{item()?['subject']},
"Start Time": @{convertTimeZone(item()?['start'], 'UTC', 'US Mountain Standard Time', 'hh:mm tt')
},
"End Time": @{convertTimeZone(item()?['end'], 'UTC', 'US Mountain Standard Time', 'hh:mm tt')
},
"Location": @{item()?['location']},
"Required Attendees": @{split(item()?['requiredAttendees'], ';')
},
"Optional Attendees": @{split(item()?['optionalAttendees'], ';')},
"": ""
}
raw input from Get events (V4) action to Select action (just the Required Attendees part):
"requiredAttendees": "<email@domain.com>;<email@domain.com>;<email@domain.com>;",
raw output from Select action:
"Required Attendees": [
"<email@domain.com>",
"<email@domain.com>",
"<email@domain.com>",
""
],
Which displays in my email as:
["<email@domain.com>","<email@domain.com>","<email@domain.com>",""]
How I want it to display:
<email@domain.com>
<email@domain.com>
<email@domain.com>
Thank you