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.