cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JackWu1123
Helper II
Helper II

Split plain text from SharePoint by '\n'

Hi

I'm designing a flow with condition to decide if the plain text includes key data. But when I tried to split the spain text to an array, it's failed.

 

Here is the flow

1.jpg

 

Here is the running status.

2.jpg

 

Would you please help to identify the reason of Split function failure ?

Appreciate if you can help on that.

 

Thanks!

Jack

1 ACCEPTED SOLUTION

Accepted Solutions
AlanPs1
Resident Rockstar
Resident Rockstar

Hi @JackWu1123 , thank you for posting in the Flow Community.

Please have a look at the below, I have started with a "Compose" called "Compose Text" to simulate your Flow & mirror your input.Capture-537.png

Here is the Flow:Capture-538.png

decodeUriComponent('%0A')
split(outputs('Compose_Text'), outputs('Compose_NewLine'))

Here is the result, an array with your seperate values and no "\n".Capture-539.png

 

If you have found my post helpful, please mark thumbs up.

 

Any other questions, just ask.

 

Thanks, Alan

 


Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!


View solution in original post

2 REPLIES 2
AlanPs1
Resident Rockstar
Resident Rockstar

Hi @JackWu1123 , thank you for posting in the Flow Community.

Please have a look at the below, I have started with a "Compose" called "Compose Text" to simulate your Flow & mirror your input.Capture-537.png

Here is the Flow:Capture-538.png

decodeUriComponent('%0A')
split(outputs('Compose_Text'), outputs('Compose_NewLine'))

Here is the result, an array with your seperate values and no "\n".Capture-539.png

 

If you have found my post helpful, please mark thumbs up.

 

Any other questions, just ask.

 

Thanks, Alan

 


Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!


View solution in original post

Hi @AlanPs1 , it works. Thank you for your help. May I ask why the plain text can be splited by 'decodeUriComponent('%0A')' but not '\n' ? what's the meaning of 'decodeUriComponent('%0A')'?

 

I'm new to Flow design. Hope to get your expertise. 🙂

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (1,180)