Power Apps Rich Text Editor Control and SharePoint multiple lines of text
ฝัง
- เผยแพร่เมื่อ 16 ก.ย. 2024
- Nothing too fancy. Just a good walk through of how you can combine the Rich Text Editor control and the SharePoint multiple lines of text field to make nicer looking text. Basically it is all HTML at the end of the day. Also, explanation of column size limits for SharePoint. 255 vs. 63,999. 😯
Power Apps Consulting and training at www.PowerApps9...
Yes! The more sharepoint, the better!! Thanks so much for these tutorials. They have helped me immensely!
You are so welcome!
It's good, after all, we're probably using SharePoint as our back end so....
Agree! How can you separate the two when they play so well together?
YES! You should definitely continue to combine SharePoint and PowerApps info in these videos.
Thanks Tyler.
While I don't use SharePoint, I like to keep in the know, so seeing both SP and PowerApps is still helpful. Thanks for the patch note at the end!
Happy to help. Have a great day. 🐶
2-year-old content and still schooling me - thanks for all the great content, Shane.
Happy to help a good guy 😊
You asked so I wanted to comment... I definitely appreciate when you make the connection back and forth from SharePoint. Helps me understand how the two correspond. Thanks
Thanks Ryan!
Tip for avoiding some errors. Rename the control you're going to delete before you delete it to the name you want to use for the new control. PowerApps will automagically change all the necessary formulas. You may have to change a few things in some cases, but that's a timesaver for me.
Love it. Thanks for sharing.
Nice tip 👍🏾
Haven't watched the video yet and you already got my like! You are truly amazing.
You're the best!
Love your videos Shane. I´m currently learning Sharepoint and PowerApps and your material is really helpful and fun. Thanks!
Great to hear!
Thanks for the clear and objective video! One update: hmtl images now don't appear broken in PowerApps anymore 😊.
Hooray! 🥳
Another vote for the SharePoint stuff along with PowerApps from me as SharePoint seems to be where I'm storing data at the moment. As ever, brilliant videos, thank you so much from the UK.
Shane! Seriously, you + any video on SharePoint is worth watching!!
Again, awesome video!!
Thanks for the support Louis. I appreciate all of your comments.
Yes I like the little tips on Sharepoint! Keep it up Shane
Glad to help. 😀
Thanks for these tutorials, Shane! Very helpful. We are heading down the Dataverse path soon but for now all of my data resides in SharePoint so this is very helpful. More sharepoint would be great!
thank you Shane , amazing as always, we need sharepoint along with powerapp for ever :)
Yes we do
Love the way you explain in simple candid way. Will be subscribing!
Great video as always, love the SP element. Thanks
Glad you enjoy it!
You're the best Shane !
Thanks! 😍
Thank you Shane. This came in handy today
Awesome
Very helpful! Adding Sharepoint info is a great add since that's what I use for my data.
Glad it was helpful!
Appreciate this video, I was able to fix my form and keep the rich text feature.
Purrrfect!
Great as ever Shane. Thank you
Happy to help. Have a great day. 🐶
Thank you for this! These videos are so awesome and helpful!
Thanks Shane excellent video
Glad you enjoyed it
More SharePoint!! More Everything! Teach me your ways, Microsoft Master
Will do!
A little SharePoint helps me too... it's the underlying data-source for the apps I'm creating.
Cool. Thanks for the feedback.
Please continue. This is good. we need to understand how the unlerlying data works too.
In the meantime, please think of giving tips on MS Dataverse (CDS) with Power Platform; some tips and ticks around Model Driven Apps. My previous request is still pending... In case you have forgotten( using multiple screens to save an item in SharePoint list when it has lots column to update )
Cool. I like bite size items like this video.
Glad you like them!
This was very helpful! thank you
I'm so glad!
Yes, more SharePoint tips would be nice. Also, i know you share my dislike of forms, how about a video on SharePoint customized forms where you delete the inbuilt default form and replace with labels and textinputs and use patch instead. I do this and i find the forms look and behave much better.
Really interesting feature implementation
Thanks 😀
Hi Shane. Here's another video where I drove up late to the party. I needed the Rich Text/HTML answer for a Power App I'm working on now. I'm curious about your comment that you don't use forms. For me, 99% of my Power Apps and Flows use SharePoint lists as data source. Do you have a video on the pros and cons of using SubmitForm vs. Patch for new records? Thanks.
Thank you so much for this video!
Glad it was helpful!
How can you get it to show all the other entries and not just the last one?
Hi, I would also like to display all entries of the multiline text field that has the Append Changes to Existing Text set. Were you able to do that? Thanks.
Shane this is not the first time you’ve released a video on the exact topic I’d be addressing in my own app on that same day. Are you creepin’? Have you hacked my microphone?
I am a spy. Shhhh. Don't tell anyone. 😀
hi shane. awesome videos and many thanks. question tho, how did you add those pictures of (users/created by) on the left side gallery?
In my sharePoint list I have a column called Face. It is a Hyperlink column set to Picture. I then store the URL to the image for each person. Boom. We get their pretty faces.
This is great thanks for the tutorial! What've noticed though now is the line spacing is 1.5 or 2 within RTE.
Shane are you aware of a way to change it to sat 1..?
I am not Andy. Maybe you could try taking the html it outputs and messing with it?
@@ShanesCows Thanks. Yeah I'll wait and see how the end user feel or if they even notice.
Hello Shane,
Thank you for your video. I admire your energy and I quite understand that you can't answer all the questions from all over the world.
What I don't understand is: Fonts and for example line spacing between SharPoint and PowerApps are quite different.
I don't think you can set the text edit control to fixed values. I'll just mention something. verdane 12 points.
If you retrieve text from sharepoint and want to edit in Power Apps then it becomes chaos regarding fonts and line spacing.
Wish you a nice December month....
Frans
I've found that if you create the texts in Power Apps, not SharePoint, you have less of a hassle with line spacing, for example.
So creating texts only in Power Apps works better.
Gald you got it Frans. Thanks for the note. :)
This is great. Thank you! I am having problems with appended notes showing back up to add to in power apps. Multiple apps for one spo list and the earlier comments aren’t feeding through and newer comments are overwriting old throughout the app even though its still is spo record. Weird.
If SharePoint is getting changed outside of the app (like by someone in another app) then your session doesn't know about it. You might need to add a periodic Refresh in the app that forces Power Apps to recheck the data source. Refresh is usually bad idea but probably your only option.
@@ShanesCows thank you!
Thanks Shane, this is really a good one.
Thanks Danny. I liked it was kind of excited when it was done.
The only down side to the Rich Text Editor is the difficulty changing the line spacing.
Yeah, the control is a bit clunky at times. Agreed.
Hi Shane, thanks a lot for your channel ! Very helpful. I have one question regarding this video. How can I remove/delete multi-line items from sharpoint list ? Is there any workaroud please? Thanks a lot for your support. Renata from Czech Republic :)
Love the videos, Shane! SO very helpful - you're a great resource! Quick Q: I understand it's not possible to add a rich text editor to a gallery, but might there be a work-around? (Hi Chewy!!) woof!
Love the videos. How about a video to delete records from large sharepoint lists? Over 5000+ records.
Interesting. I can see where that would have issue because of view issues. I will think about this.
I love it
Thanks!
Great video. Did you try adding two rich text editors in one form? When I did that, it all messed up. On updating, only the last edited field gets updated, and the other field content gets wiped out. I managed to reproduce the bug every time I tried. Scenario: Editing SharePoint forms.
how the hell does the populate word document step in flow STILL not support rich text??? Any workaround you have would be incredible. I've even gone so far as to create a custom column to allow rich text in document libraries (it's turned off by default), and the quick part does not appear in the dropdown
Got me. I have never really used the Word connector. Always seemed like a lot of work. We have other people on the team that have done cool stuff but so far I have stayed away. 😐
Hello Shane,
Is there any option to insert Table as an input in Rich Text Editor in Canvas PowerApps?
I see that in SharePoint Enhanced Rich Text column it supports Tables.
I don't know, I haven't done that one. I am assuming it would just be an HTML table but you would have to hand write it.
New to powerapps, I have a problem I'm hoping you can work your magic on.
Imagine having a gallery of employees, click one, it brings you to a form of their data pulled from sharepoint, then also on that page would be a gallery that would draw files based on that employee's id number from a sharepoint document library (all files have a consistent naming convention based on the relevant persons id#). So you click on employee# AA001, you go to a page that pulls their info (both fed from the same sharepoint list), and then you click a button like "Yearly Reviews" and the button does pulls a gallery of all files from a sharepoint document library that start with AA001. Does all that make sense?
So you could create an object variable on select when the original selection is made. When you navigate to the form/gallery screen you will then have to pass thay object /var to thay 2nd screen. The next step is to filter your SP list based on the ID of that variable you passed in from the first screen. The list should then only display entries where the user ID is 'AA001' or whatever other one you select.
I would also advise looking on the powerapps forums. I'm on there answering questions as well as people much more knowledgeable than me, such as Master Shane 🙌, and there are almost no problems that don't get solved there. Good luck mate!
Yes, that is doable. Go and search, I did find it for my purposes a while ago and was not that difficult :)
Thanks for good explanation. Any clue why text label has no spacing between lines, but rich text editor seems to have double spacing between text?
Text label capture a new line character if you hit enter. Rich Text Editor captures an HTML I am pretty sure. So how they display after the fact is dependent on if you what you are using to display the data. I know that isn't an exact answer but hopefully gives you the pieces to think about.
@@ShanesCows In Display I did a substitute to remove line breaks. Unfortunate, no line spacing options within rich text editor settings. Thanks. confirming not missing a small setting.
Thank you :) Helped a lot!!
You're welcome!
I built a nifty notes section to my app using a rich text editor and a multiline column in SharePoint. However I'm unable to nest the editor in my gallery where users want it. How would you get around this? Are there any tricks using containers or making a custom editor using a multi line text input with bold and italic buttons added in?
I have a problem. How do I put the RTF-editor in to the DataCard? I can only put the RTF-editor directly on the EditScreen. What is the reason for that?
Rich text editor menu options at the top are too small. How to make it readable?
I don’t think you can sorry.
Please do a video, or link me to a video with the Apend changes to existing text. if this is possible
PowerApps Append Text - Using forms or Patch create update only fields
th-cam.com/video/dre1E9GiDJM/w-d-xo.html
HI Shane, great video, I am a complete novice but how do I echo or recall/see my previous entries? The gallery HTML box shows what is currently being saved but what about previous entries? can i recall them as a list?
Echoing everyone else, love the videos, would it be possible to do a short video on SharePoint integration making edit forms (with multiple forms on one screen) that you can view/save using SharePoint default buttons
Amazing 👏, but couldn't apply this with table 😞 it appears in rich text without table style, could you please help 🤗
Power Apps doesn’t like to show tables in my experience 😔
@Shane Young
I have a classic SharePoint list, in that comments section is not showing in correct format. The comment is enhanced rich text but it showing in HTML format. Could you please help me in that.
Hi Shane, i need to do something similar but on a collection, and the form doesn't want to base itself on that collection. So how can I update the collection from the richtextcontrol as the onchange event doesn't seem to work. You mention you did something on previous video, I can't seem to find it :(
Hi is it possible to switch from plaintext to enhanced text and vice versa and applicable to whole list data in SharePoint
Yes, but need to be careful. It can cause data loss.
Thanks for the video, I would like to create a doc editor using RTE control with features like save to a document, load from a document, print a document etc... is this possible using RTE control ? Any sample that you can share...
Not sure about that one. I don't use the RTE much.
Hi Shane,
Thanks for the great video.
Any ways to populate richtext to PDF?
RichTextEditor.HTMLText outputs HTML so yes, it should work to build a PDF.
HI, thank you Shane for your work. I used a rich text editor on the forms of my team, but they prefer the "DogNotesFancy" way (a new window to enter plain text). How can I retrieve it or recreate it ?
Thanks a lot
Hi Shane, Love your videos. I try to send a rich editor text to a SharePoint list, but when I input a screenshot into the rich editor SP list does not see it... Any advice? :)
Thanks Shane, Off topic any idea what the Pending function does "Pending(source,state,error_state)" another mystery function with no documentation what so ever lol, seems to generate a Table if you whack it in a variable?
Shane, I have found that Apple devices seem to render all the RTE code in the HTML control as Times New Roman, seemingly ignoring the Font markup. I know the HTML the RTE generates is always a bit complex, have you seen such issues with Apple devices and can you think of a way to resolve it?
Is there any way to be able to paste images into the PowerApps rich text field from the clipboard? This would be to support Gino's face to show up and upload another pic at 12:20 marker. TFS supports this.
NOt that I know of :(
@@ShanesCows Thanks Shane and thanks for all your videos.
I wish I could have a control which functions like the default one for a SharePoint form, shows the formatted text with a pencil which you click to open a nice big editor for the individual field. That you can't do this out of the box is just another frustrating limitation of this crappy app (trying to use Power Apps to create a useable SharePoint form which shows 'ALL' the fields not just the first 4 or 5).
You can edit the form to show all of the fields. The expanding text input would be cool for sure.
@@ShanesCows yes thanks, doing that but the way I have to use a more custom solution to get multiple usable rich text boxes for both view and edit mode because the default form won't give me all the field is rather painful.
I paste an image in the rich text editor and it doesn't upload to the sharepoint list
That is interesting Casey. I had never tried that but I did this morning. I have ideas but nothing concrete to share yet on ways to build this functionaliy.
Casey I thought you would like to know I did solve this. I think this will be next week's video. I was going to mention that the idea for the video came from you in comments. If you want me to put a picture or a small video of you waving in the video shoot me an email shane at powerapps911.com and we can figure out something. Thanks for the idea, the solution is slightly complicated but seems to work.
Hi I noticed that the Canvas App Rich Text Editor can handle table formatting correctly. It renders the html differently compared to the Rich Text Editor used by Model Driven Apps. Is there a way to customized or edit the Rich Text Editor in Canvas Apps?
Hi Shane - is it possible to use the RTE in a Canvas App and pre-populate the RTE with html code saved in a SQL Database? I'm attempting to save a template created with the RTE that can then be emailed but also saved to SQL for future editing. I cannot seem to populate the DEFAULT variable of the RTE with the saved database (simple) html. Even if it can't be saved to SQL, can it be saved to anything else (e.g. a html file?) Thanks in advance.
Hi Shane, can it be possible to add "Rich Text Editor" control inside the gallery itself? I am not able to add somehow. This is required for me to edit the data in the selected row of the gallery but not in the form.
Is these possible to set same image based on starting word of the text label in gallery
Is there a way to add table using the rich text editor? or a work around?
Hmmm. I haven’t tried. Nothing comes off the top of my head. Sorry. Do you just need to collect table data? Maybe put it in a collection and then use Concat to create an html table.
@@ShanesCows not really, I just mean a table in a old-fashion way, if I copy-paste a table from a word file or a excel file, it's nice to be able to add images or links but no table, it's just so wierd....it's like one of the most commonly used function in MS Office...maybe this seems a little abrupt, but love your videos and feel so lucky to see your comment to me!
Hi..i have a doubt..in rich text editor how can we restrict users in pasting images..is there any way to do that?
Hi @Shane, you mention you don't use Forms. Can i ask why? What is the pro and con compared to patch?
I was wondering this to.
It is on the list of videos to make. 😀 Long story short forms don't allow a lot of control and can't do complex things so for me they rarely fit.
@@ShanesCows so to be clear you just build your own forms using patch statements as they provide more of an open sandbox where you can be much more fancy and have more complete logic? This is what I do but I assumed I was breaking the 'meta' by not using the built ins. They just seem lackluster as the come...
@@scoozilife Yup. No forms for me. 😀
@@ShanesCows good to know! I gave up on trying to make them work in anything other than the auto generated apps from SP. They are find for that but add anything to it and it breaks immediately most of the time. Great video!
How to pass this rich text editor as parameter in Power Automate?
Rich text editor in a gallery with repetition needed.. Please help
Hey Shane! Can u teach how to send email as user and receive as admin using powerapps
I don't understand receive as an admin. th-cam.com/video/vpYkOccwn4Y/w-d-xo.html This should help the send part.
@@ShanesCows Thanks ! It did help! U r doing a great job!
Can you push enhanced rich text from sharepoint into Microsoft Word using the premium connector and maintain the formatting? i.e. (If you make a bulleted list in a power app can you push that list into Word?)
I have the same query. Did you find a solution?
Yes please to amend existing text,
Noted. Thanks
SP + Power Apps please.
Got it 😔
Hello @Shane young, I have created a list in microsoft team. I want to use it as a form in already created app. Can you tell me how can I do that?
Lohit do you have edit privileges to the app?
@@rivernet62 yes
I'm using an edit form actually. How will i set the default value to lastsubmit for a richtexteditor?
Parent.Default not working.