In addition, if you want to display the saved Rich text content (from your SP list) within yout Display form, you need also take a try to add a Rich text editor control within your Dsiplay form, then bind it to the Multiple lines of text type column in your SP list. Please check the following GIF image for binding Rich text editor to the Multiple lines of text type column in your SP list: So you need to remove the TextInput control from the RichText Data Card control, then add a Rich text editor control within this Data Card control, and bind it to the Multiple lines of text type column in your SP list. I assume that you have created above Multiple lines of text type column in your SP list, but when you generated a Edit form for your SP list, the Multiple lines of text type column would be decorated as a TextInput control as below: Highlight the range you want to transpose. More details about the Rich text editor control in PowerApps, please check the following article:Īs an alternative solution, you could consider take a try to create a Multiple lines of text type column which has enabled " Use enhanced rich text" option within your SP list, then use the Multiple lines of text type column to store the Rich text content from the Rich text editor control. Replace any formula with text in the range which you want to transpose. if you want to save Rich text content from Rich text editor control into a Sinle line of text type column of your SP list, I think you need to parse the Rich text content firstly, because the input format or output format of the Rich text editor control are both HTML data. Which type column do you use to store the Rich text content within your SP list? A Sinle line of text type column or Multiple lines of text type column?įurther, could you please share a screenshot of your app's configuration? Now we have a transposed version of the original range and all the formula’s have maintained their original references.Hi you want to save the rich text content from the Rich text editor control of your Edit form into your SP list? Press the Replace All button. Press the OK button in the pop up that follows, again it should say we made 6 replacements as there were 6 formula’s in our range.In the Find what box type in #= and in the Replace with box type in =.Open the Find and Replace window with the Ctrl + H keyboard shortcut or from the Home tab in the ribbon.Now we just need to change the text in the transposed version back to formulas. Step 3: Change The Transpose Range Back To Formula Select the All radio button under the Paste options.Select an empty cell where you want the transposed version and paste special. You can either use the Ctrl + Alt + V keyboard shortcut or the Paste button in the Home tab of the ribbon.
You can either use the Ctrl + C keyboard shortcut or the Copy button in the Home tab of the ribbon. Highlight and copy the range which you want to transpose.Now we can transpose our selection with copy and paste special. It should say we made 6 replacements as there were 6 formula’s in our range. I like to use # as it’s a character that’s unlikely to appear in any of the formula’s but you can use any text in front of the equal sign as long as it’s not in any of your formulas. This will turn any formula into a text string. In the Find what box type in = and in the Replace with box type in #=.Alternatively, you can use the Ctrl + H keyboard shortcut to open the Find and Replace window. Under the Editing section press the Find & Select button.
0 kommentar(er)
