Unanswered

split on semicolon delimitator in Select action

(0) Share

Report

Posted on by bbeckstrom

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

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (0)

ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (0)

Report
Hi @bbeckstrom

Pls use the below expression for required attendees:

join(split(item()?['requiredAttendees'],';'),' ')

Here, we are joining the elements of an array with html tag to show each address in a new line.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No
bbeckstrom 8 on at

Like (0)

Report
Hi @ManishSolanki,

Thank you for the reply.
That returns:

email@domain.com email@domain.com email@domain.com 

That is closer as it removed the square brackets, quotes, and commas. It remains in a row, however.
I get your thinking with the break line. But wouldn't that need to be used in a Compose action to function as HTML?
I tried a couple ways to manipulate that output.
I added a compose for
join(split(item()?['requiredAttendees'],';'),' ')
and then used the compose output in the Select action map. That threw an error though.
Next, I tried Initializing Variable action
join(split(item()?['requiredAttendees'],';'),' ')
and then used the output from that in a compose action, the compose action output in the select action map. This also threw an error.

Thank you,

Was this reply helpful? Yes No
ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

Pls share screen shots of the flow in edit mode. I would like to see how you have configured the actions in the flow.

Was this reply helpful? Yes No
bbeckstrom 8 on at

Like (0)

Report

Hi @ManishSolanki,

Here it is:
Here those actions are expanded:
Thank you

Was this reply helpful? Yes No
ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (0)

Report

I would request you to please click on 'Select' & 'Create html table' action and share their expanded view.

Was this reply helpful? Yes No
bbeckstrom 8 on at

Like (0)

Report

@ManishSolanki

Was this reply helpful? Yes No
ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (0)

Report

This looks fine. Did you encounter any error during flow execution? If yes, please share the details with screenshot.

Was this reply helpful? Yes No
bbeckstrom 8 on at

Like (0)

Report

@ManishSolanki
It does work, the errors I spoke of was when I was attempting to incorporate your suggestion as I was trying a few different ways to implement. This is just a format issue with how the data is displayed.

Was this reply helpful? Yes No