cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sbonera
Advocate II
Advocate II

Split ; for email address on selected item output

Capture1.PNG

Hi   

 

I have an reviewers output box on for selected item to capture 2 or 3 email addresses.  As you can put multiple email addresses in this box the output is first.user@etc.com;second.user@etc.com;

 

I would like to get the 2 or 3 emails in a varible  so tried this   
split('Reviewers',';')   to see if i could split those email address to place in different sharepoint columns

3 REPLIES 3
Anonymous
Not applicable

sbonera,

 

To return specific items from the array, append it with [#]

 

1st Email Address = split('Reviewers',';')[0]

2nd Email Address = split('Reviewers',';')[1]

3rd Email Address = split('Reviewers',';')[2]

 

Cheers

GabrielStJohn
Community Champion
Community Champion

Hello, @sbonera!

Thank you for posting on the Flow Community Forum! Have you had an opportunity to apply @Anonymous‘s recommendation to adapt your Flow? If yes, and you find that solution to be satisfactory, please go ahead and click “Accept as Solution” so that this thread will be marked for other users to easily identify!


Thank you for being an active member of the Flow Community!

-Gabriel
Flow Community Manager

- Gabriel
Community Manager
Power Automate | Power Virtual Agents
Super User Program Manager



In my case split(Triggerbody()['Email'],';')[0]  worked  which was the expression behind the reviewer field.  when I used the reviewers dynamic content it for some reason would return the word reviewers and not the email addresses.  

 

So I would say the answer got me there, however maybe this is flow issue for having to put (Triggerbody()['Email'],';')[0] ?

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Super User 2 - 2022 Congratulations 768x460.png

Welcome Super Users

The Super User program for 2022- Season 2 has kicked off!

Users online (2,804)