I have a calculated value control that is reading in 3 columns from a sharepoint list and displaying it in one form control.
(Classic 365 Forms layout).
I would like to display these 3 strings on 3 separate lines. Currently, I can only concatenate these. I do not want or need to save this data out into SharePoint columns. the 'New Line' function in the formula builder for calculated value controls looks promising, but I cannot find any way of using it here, and no reference to its being used in forms.
The current formula is as follows:
And the result is currently as follows.
I have 9 of these controls on my form, so I would rather not separate them out into 3 controls each.
(I only intend this data to be read in New Mode, and not to be refreshed/reloaded).
I would be very grateful if someone knows how this can be done.
Solved! Go to Solution.
This worked for me to put Hello and World on two separate lines. The trick is using the double quotes around the HTML which then seems to render/be interpreted properly:
"Hello" + "</p>" + "World"
Just a comment - this solution works if the calculation is always active (in new/edit/display modes). If not, the html just becomes text in the middle of the long concatenated text (as at the start). I have decided to refrain from this and to use ---->1 etc before each text to clearly mark them.