I have created a string variable as follow:-
then i am appending its text using the built-in "Append to string variable" action >> this action will be performed inside "foreach" for this action will get performed 1++ times:-
finally i will updated the item with the final variable string, as follow:-
now this is working but the only issue i am facing is that the variable will show the entries without new lines. as follow:-
so is there a way to fix this?
Hi @johnjohn123
A possible workaround would be to initialize a variable for a carriage return and append that in your apply to each.
1. Add a initialize variable action, call it CRLF and press enter in the value so you have two lines
2. Add the CRLF variable to your append to string action
@Expiscornovushave you tried it at your end..? because adding this extra variable will not have any effect!
Hi @johnjohn123,
Yes, I tested it first before I posted this possible solution 🙂
What kind of SharePoint column are you using, multiple lines of text?
My test result
Output of my test example in a compose action
Output of my test example in an SharePoint Update item action
@Expiscornovus i am using Rich Text field + i changed it to Enhanced rich text field,,,but still same issue..
thanks
@johnjohn123 can you share the output (a couple of screenshots) of your flow test before you changed the field to use enhanced rich text?
Btw, I just tested it on my target list with an enhanced rich text field. The solution I proposed doesn't work with an enhanced rich text field. Look at the example below.
User | Count |
---|---|
87 | |
43 | |
21 | |
18 | |
15 |
User | Count |
---|---|
130 | |
47 | |
42 | |
35 | |
28 |