replace Newline \n with in Sharepoint item column before creating a file

(0) Share

Report

Posted on by cfebvre

232

Hi All,

At the moment I'm trying to improve the structure of my app and flows a bit and I'm curious...

Is it possible to retrieve the column data (Multiline) for a selected item, and use the replace funtion to replace Newlines \n to html   and then output this changed text?

For the sake of context, I'm presently creating .txt files from a sharepoint list item, but I want to see if it's possible to create a working .jsx script I can trigger within Adobe Indesign.

I feel like I'm close, but I can't quite work my head around it.

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

cfebvre 232 on at

Like (0)

Report

For added detail:
I want to manipulate the 'BodyCopy' Dynamic content below to replace all insatnces of \n with 
The dynamic content I want to manipulate. $An example of the \n newline I want to replace with $ An example of the \n newline I want to replace with 

Was this reply helpful? Yes No
Verified answer

v-bacao-msft on at

Like (1)

Report

Hi @cfebvre ,

Please check this similar thread and see if it helps:

https://powerusers.microsoft.com/t5/Building-Flows/How-to-print-a-row-with-new-line-character-from-excel-to-teams/td-p/349942

Note that you need to add a space bar to the value of Variable.

Hope it helps.

Best Regards,

Was this reply helpful? Yes No
cfebvre 232 on at

Like (0)

Report
Hi @v-bacao-msft,

Thanks for getting back to me. I'm attempting your solution but not having success at the moment - my expression is invalid.
I'm using the compose action prior to the create file action and attempting to use a replace expression:
replace(@{body('Get_item')?['BodyCopy']},'\n',' ')
I'm inputting this expression, but it says its invalid.
I'm then using the output from this action to create the .jsx file content.
As you can see, I'm trying to replace all instances of '\n' with ' ' within the BodyCopy dynamic content I retrieve earler in the flow.
I'm a bit hopeless at expressions, and I expect I've got this terribly wrong.
I notice in the example you provided, the expression isn't typed in the expression field, uses and @ symbol at the beginning, and is encased in quotes.

Was this reply helpful? Yes No
v-bacao-msft on at

Like (1)

Report
Hi @cfebvre ,

I used the variable, you don't seem to use it here, please follow the method I provided to configure the Expression.

Like:

replace(body('Get_item')?['BodyCopy'],variables('Enter'),' ')

Best Regards,

Was this reply helpful? Yes No
cfebvre 232 on at

Like (0)

Report

Hi @v-bacao-msft ,

You're a champ as usual! I completely misunderstood what you meant the first time round, but this has fixed my problem entirely.

Was this reply helpful? Yes No