Unanswered

"\n" characters being included in the end of my string, how to remove?

(1) Share

Report

Posted on by melf123

Hi everyone,

I have a flow where I'm grabbing the meeting invitees from a Sharepoint list, these are formatted in multiple email addresses that can be different each time and submitted as "example1@example.com;example2@example.com" in the list.

When I select the meeting invitees I get "example1@example.com;example2@example.com\n" as my string. I'd like to remove the /n characters as this is causing my create a teams meeting action to fail when I use the output of my meeting invitees for the required attendees field.

Could someone please help me out figure this out?

Thank you in advance

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

rzaneti 4,241 Super User 2025 Season 2 on at

Like (1)

Report

Hi @melf123 ,

Try the replace() expression:

Output:

Let me know if it works for you or if you need any additional help!

-------------------------------------------------------------------------
If this is the answer for your question, please mark the post as Solved.
If this answer helps you in any way, please give it a like.
http://digitalmill.net/

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

Like (1)

Report

Hi @melf123 ,

You can inject a compose action and use a replace() expression. Here's my test.

replace(items('Apply_to_each')?['field_1'],'\n','')

Was this reply helpful? Yes No
Verified answer

Paulie78 8,422 Moderator on at

Like (2)

Report
Use replace to remove the \n - if you don't have any luck with the \n replace as per the examples above use:

decodeUriComponent('%0A') instead of the \n.

Example:

replace(TheThingToReplace, decodeUriComponent('%0A'), '')

Blog: tachytelic.net

YouTube: https://www.youtube.com/c/PaulieM/videos

If I answered your question, please accept it as a solution 😘

Was this reply helpful? Yes No
melf123 on at

Like (0)

Report

Thank you for your help, this formula worked!

Was this reply helpful? Yes No