Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Unanswered

split on semicolon delimitator in Select action

(0) ShareShare
ReportReport
Posted on by 8

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:

  1. Get events (V4)
  2. Select
  3. Create HTML table
  4. Compose
  5. 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

  • bbeckstrom Profile Picture
    8 on at
    Re: split on semicolon delimitator in Select action

    @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.

  • ManishSolanki Profile Picture
    15,085 Super User 2025 Season 1 on at
    Re: split on semicolon delimitator in Select action

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

     

     

  • bbeckstrom Profile Picture
    8 on at
    Re: split on semicolon delimitator in Select action

    @ManishSolanki 

     

    bbeckstrom_0-1718302212480.png

     

  • ManishSolanki Profile Picture
    15,085 Super User 2025 Season 1 on at
    Re: split on semicolon delimitator in Select action

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

     

     

  • bbeckstrom Profile Picture
    8 on at
    Re: split on semicolon delimitator in Select action

    Hi @ManishSolanki,

     

    Here it is:

    bbeckstrom_0-1718301545739.png

    Here those actions are expanded:

    bbeckstrom_1-1718301657578.png

    bbeckstrom_2-1718301684021.png

    bbeckstrom_3-1718301728884.png

    Thank you

  • ManishSolanki Profile Picture
    15,085 Super User 2025 Season 1 on at
    Re: split on semicolon delimitator in Select action

    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.

     

     

     

  • bbeckstrom Profile Picture
    8 on at
    Re: split on semicolon delimitator in Select action

    Hi @ManishSolanki,

     

    Thank you for the reply.

    That returns:

     

    email@domain.com<br>email@domain.com<br>email@domain.com<br>

     

    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'],';'),'<br>')

    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'],';'),'<br>')

    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,

  • ManishSolanki Profile Picture
    15,085 Super User 2025 Season 1 on at
    Re: split on semicolon delimitator in Select action

    Hi @bbeckstrom 

     

    Pls use the below expression for required attendees:

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

    Here, we are joining the elements of an array with html <br> 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.

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1