Split plain text from SharePoint by '\n'

[JackWu1123]

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

Here is the running status.

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

Appreciate if you can help on that.

Thanks!

Jack

[AlanPs1 · Accepted solution]

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.

Here is the Flow:

decodeUriComponent('%0A')

split(outputs('Compose_Text'), outputs('Compose_NewLine'))

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

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

Any other questions, just ask.

Thanks, Alan

[JackWu1123]

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. 🙂