cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Post Patron
Post Patron

Put spaces between people names

Hello!

 

I got this column people/group in a sharepoint list that I have in my flow. The problem i got is there is no spaces in the mail it sends out with the peoples names.

 

It looks like this "NameNameName", I would like is to look like this: "Name, Name, Name".

 

So I got this flow:

msflowspaces people.PNGmsflowspaces people mail.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Super User III
Super User III

Hi!

Assign also a comma in your append to string variable

 

Please note there is a more elegant solution that is to initialize an array variable and to use its corresponding 'append to array variable'. Assuming the variable is called 'myEmailsArray', Now when adding the email addresses to the email body, you can use the expression:

join(variables('myEmailsArray'),', ')

 

Hope this helps

 



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



View solution in original post

3 REPLIES 3
Super User III
Super User III

Hi!

Assign also a comma in your append to string variable

 

Please note there is a more elegant solution that is to initialize an array variable and to use its corresponding 'append to array variable'. Assuming the variable is called 'myEmailsArray', Now when adding the email addresses to the email body, you can use the expression:

join(variables('myEmailsArray'),', ')

 

Hope this helps

 



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



View solution in original post

Nice, it worked!

 

Next question 🙂 Is there anyway to make it say 

 

1. name

2. name

3. name

4. name

Hi!

I think you can achieve this by means of HTML tags or by adding markup.

But, my humble suggestion is:

1.-Mark this topic as "Solved" by clicking "Accept as a solution". This way other community members facing this same problem in the future have the chance to find a solution faster. Please note you can even select several replies as as 'Solution', even from different community members!

Flow_AcceptSolution.png

2.- Open a new thread for your next question, following the policy: 'One Question, one post'. MAny SuperUsers pay more attention to unanswered topics, and I am not an expert in HTML. Let's hope somebody else can point us to the right direction

3.- (OPTIONAL) Click on 'Thumbs up' in any answer you found valuable.

Flow_thumbsUp.png

Even though this 3rd step is OPTIONAL, please remember it is the cheapest, easiest way to say thanks to somebody that simply tried to help. And just between you and me, everytime an inspiring answer receive a kudo, an ewok escapes from The Emperor menace  😉

 

Thanx for your contribution to keep this community great!

 



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Helpful resources

Announcements
PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Top Solution Authors
Users online (6,509)