Hello All,
I'm trying to get approval comments and summary to be added to a multi line column in a SharePoint List. Basically the approval record is sent and response comments and the summary are added to a SharePoint column, but the problem is the comments are all bunched together which makes it hard to read. I would like each response comment to be on a separate line with some white spaced added between the comments.
Also to note that I tried this solution and as mention it is no longer working and I could not get the "concat" formula to work either. (expression error)
This the SPO Column and yellow is response comment and orange is response summary with no white spacing or line feed
The flow that builds tries to append line feed and white spacing
Hi!
My suggestion is, on your 'Set variable' action block...
-either try to add a new line by hitting 'enter' just after the dynamic content output you assigned as its current value ('Responses comment' , right?)
Or, try to add a new line by adding <br>, but in this case, you will probably need to activate 'Rich text' in your column definition, as explained here
https://www.sharepointeurope.com/rich-text-column-sharepoint-document-library/
Hope this helps
Proud to be a Flownaut!
Hi @IT_Matt,
You could add the URI code "%0A" between the sentences you want to break line, then use the decodeUriComponent() function to decode it, for Example:
Add lines between your text with the URI code.%0AThis code your text better and makes it easier to read.
Result:
Add lines between your text with the URI code.
This code your text better and makes it easier to read.
Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@efialttes I'm not sure I understand your suggestion. I review the link and it is an older version of SharePoint and I'm on SharePoint Online. As for adding a line by pressing enter, if you review the image you can see I've added that but Flow ignores it. I had a space at the top and between the variable and "response comments" but both were removed or ignored. I even tried quotes with a space and that didn't work either. Your suggestions are greatly appreciated.
Hi!
Sorry for my English. I was referring this
Hope this helps
Proud to be a Flownaut!
@v-litu-msft I also tried the "%0A" and it was unsuccessful. I'm unfamiliar with that URI code so I even tried it with a zero and capital "O" ("%OA") since I didn't know which was correct.
Thank you for your response and l look forward to any other suggestions or feedback.
1st thanks for responding and your English is fine! @efialttes
Unfortunately, I try adding that carriage return (enter key) to the "set variable" but that was unsuccessful. I also tried adding to the "Compose" and "Append to String" actions (pictured in my first post) and that was unsuccessful.
Thank you for your response and l look forward to any other suggestions or feedback.
Were you two able to get your suggestion to work on your tenant? If so, I might have a reason why it's different on mine.
Weird.
There must be something really simple we are missing...
wait, wat, wait.. how are you handling more than one response with current Apply to Each? I mean, why 'Update item' inside the 'Apply to Each'? Can you share a screenshot of 'Update item' design details?
THanx!
Proud to be a Flownaut!
Hi @IT_Matt,
It is "%0A",
Add lines between your text with the URI code. %0AThis code will make your text better and makes it easier to read.
decodeUriComponent(outputs('Compose'))
Run result:
Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Update SPO List item after each response
Hi @IT_Matt,
Thank you for your screenshot, just as I said, please input the expression into the Update item action, not append the output of Compose directly. The "%0A" should decode by the following expression, then the line will break:
decodeUriComponent(outputs('Compose'))
Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@v-litu-msft Thank you for extending your help to help me resolve this!
Unfortunately, it's still hasn't worked.
I'm posting the screenshot of the output in the "Notes" column of the SPO List. I'm also posting the screenshot of the adjusted code in the "Update Item" to see if I'm missing something.
highlighted the changes in my flow
Notes column of my SPO List
Thank you, again for your assistance.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
27 | |
26 | |
24 | |
13 | |
11 |
User | Count |
---|---|
62 | |
51 | |
30 | |
29 | |
25 |