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

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
efialttes
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
efialttes
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
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Solution Authors
Users online (1,795)