PowerApps customizing SharePoint form - Multiple lines of text column showing HTML

%3CLINGO-SUB%20id%3D%22lingo-sub-201794%22%20slang%3D%22en-US%22%3EPowerApps%20customizing%20SharePoint%20form%20-%20Multiple%20lines%20of%20text%20column%20showing%20HTML%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-201794%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20customizing%20a%20custom%20list%20using%20PowerApps%2C%20my%20multiple%20line%20of%20text%20fields%20no%20longer%20behave%20as%20expected.%20In%20the%20forms%20they%20turn%20into%20single%20line%20of%20text%20and%20start%20displaying%20HTML%20in%20the%20output.%20I%20have%20managed%20to%20set%20the%20field%20behaviour%20to%20'Edit%20multi-line%20text'%20which%20helps%20a%20bit%2C%20but%20it%20still%20returns%20HTML%20output%2C%20and%20there%20does%20not%20seem%20to%20be%20an%20option%20to%20have%20rich%20text%20editing%20in%20the%20new%2Fedit%20forms.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20give%20me%20tips%20on%20how%20to%20work%20with%20multi-line%20fields%20using%20PowerApps%20for%20SharePoint%20lists.%20Also%20tell%20me%20if%20there%20is%20an%20option%20for%20using%20the%20normal%20SharePoint%20new%20form%20and%20just%20modifying%20the%20view%20form%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThx%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-201794%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EPowerApps%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-216950%22%20slang%3D%22en-US%22%3ERe%3A%20PowerApps%20customizing%20SharePoint%20form%20-%20Multiple%20lines%20of%20text%20column%20showing%20HTML%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-216950%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Etry%26nbsp%3Bsetting%20the%20Mode%20property%20of%20the%20DataCardValuexx%20to%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETextMode.MultiLine%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20399px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F37883i6867D07996EDF1AF%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%222018-07-19_16-28-00.png%22%20title%3D%222018-07-19_16-28-00.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-202221%22%20slang%3D%22en-US%22%3ERe%3A%20PowerApps%20customizing%20SharePoint%20form%20-%20Multiple%20lines%20of%20text%20column%20showing%20HTML%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-202221%22%20slang%3D%22en-US%22%3E%3CP%3EDone%20some%20more%20work%20on%20this%20today%20and%20found%20that%20if%20I%20add%20a%20new%20text%20field%20of%20type%20HTML%20text%20and%20then%20bind%20it%20to%20the%20datacard%20of%20the%20multi%20line%20column%2C%20then%20the%20HTML%20output%20displays%20as%20I%20want.%20The%20original%20datacard%20can%20thereafter%20be%20set%20to%20hidden.%20Having%20to%20use%20plaintext%20would%20not%20fulfill%20my%20needs.%3CBR%20%2F%3EMy%20next%20step%20is%20to%20find%20out%20how%20to%20be%20able%20to%20edit%20this%2C%20still%20keeping%20the%20formatting.%20While%20searching%20for%20the%20HTML%20field%20I%20also%20came%20across%20a%20new%20'Rich%20text%20editor%20(experimental)'%20field%20which%20I%20am%20now%20testing%20out.%20Plan%20is%20to%20show%20the%20read%20only%20field%20on%20the%20view%20form%20and%20the%20editor%20when%20form%20is%20in%20new%20or%20edit%20modes.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20558px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F35648i9FB3D16584368DF0%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22powerAppsHTMLEditor.jpg%22%20title%3D%22powerAppsHTMLEditor.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-202211%22%20slang%3D%22en-US%22%3ERe%3A%20PowerApps%20customizing%20SharePoint%20form%20-%20Multiple%20lines%20of%20text%20column%20showing%20HTML%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-202211%22%20slang%3D%22en-US%22%3E%3CP%3EIf%20the%20field%20is%20connected%20to%20a%20text%20column%20in%20Sharepoint%20make%20sure%20the%20Sharepoint%20column%20is%20set%20to%20Plain%20Text%2C%20not%20Rich%20Text.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1247082%22%20slang%3D%22en-US%22%3ERe%3A%20PowerApps%20customizing%20SharePoint%20form%20-%20Multiple%20lines%20of%20text%20column%20showing%20HTML%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1247082%22%20slang%3D%22en-US%22%3EThis%20worked%20for%20me.%20Thanks!%3C%2FLINGO-BODY%3E
Highlighted
Contributor

When customizing a custom list using PowerApps, my multiple line of text fields no longer behave as expected. In the forms they turn into single line of text and start displaying HTML in the output. I have managed to set the field behaviour to 'Edit multi-line text' which helps a bit, but it still returns HTML output, and there does not seem to be an option to have rich text editing in the new/edit forms.

 

Please give me tips on how to work with multi-line fields using PowerApps for SharePoint lists. Also tell me if there is an option for using the normal SharePoint new form and just modifying the view form?

 

Thx

4 Replies
Highlighted

If the field is connected to a text column in Sharepoint make sure the Sharepoint column is set to Plain Text, not Rich Text.

Highlighted

Done some more work on this today and found that if I add a new text field of type HTML text and then bind it to the datacard of the multi line column, then the HTML output displays as I want. The original datacard can thereafter be set to hidden. Having to use plaintext would not fulfill my needs.
My next step is to find out how to be able to edit this, still keeping the formatting. While searching for the HTML field I also came across a new 'Rich text editor (experimental)' field which I am now testing out. Plan is to show the read only field on the view form and the editor when form is in new or edit modes.

powerAppsHTMLEditor.jpg

Highlighted

Hello,

 

try setting the Mode property of the DataCardValuexx to

 

TextMode.MultiLine

 

2018-07-19_16-28-00.png

 

Highlighted