Sorry bfilling, I have been getting better and zooming in much more since this video. Some of the code is actually in the description of the video though too.
Hello, I have a question, why are the messages deleted in the Html.text display? The previous ones do not continue to be shown, only the most recent ones. Example: ListInSharepoint: has values from previous days more than 1000 characters Power app htmltext: 20 cartacters, lastcomment
hi josue, I'm not sure. make sure your column in Sharepoint is multi line text. Also when you patch make sure to grab the existing htlmtext.html + the newtext.html that you write. It should grab the previous html too.
Hi Andrew, as always, its a great video and can be utilize with many other apps, thank you for sharing your knowledge, look forward for more videos like this, 👍
Epic exactly what i m looking for ; I surfed the entire internet couldn't find anything similar that applies for my requirement. Thank you a lot Andrew. Q: my scenario requires a little extra work , Instead of comments I'm looking to add back n forth Q/A kinda feature for approval process, Literally the same SP List comment section. Before approving the manager may need some clarification from the PM , So when the manager asks something , I'd like to send some sort of notification/WF to the PM , Maybe using '@" . The manager(James) would say "@Andrew , Hey could you pls confirm if we've got resources?" , Then Andrew(PM) get notification and reply @James, Yes confirmed. How can i achieve this ? thanks
That's actually a cool use case! I'm thinking of a CRM when you leave a comment for each time you talk to a customer, where you don't want to edit the comments, but just append.
Andrew, great video! For a noobie, it was a little daunting to follow along but I followed the video to the letter and it worked first time! I do, however, have one question. In your video, you display the comments in the order [Comment] [Date] [Displayname]. For alignment purposes, I'd like to change the order to [Date] [Displayname] [Comment] but no matter how I have tried to edit the Item Property, it fails. Is this even possible?
Hmmm good point, maybe if you refresh the datasource before the patch it will fix the issue? That way it picks up the most recent comment no matter what
@@andrewhess123 yeah, it will reduce the likelihood but not eliminate. I wish they had native comment support. Great video btw. I think I'm going to write new comments to a separate table, and have a trigger flow process them and do the updates to the main record. This avoids the race condition.
Hey Andrew, I watched video and my comments section works but it's so inconsistent. It posts the comments on my sharepoint list and all the history is saved on there, but for some reason they disappear randomnly in my powerapp. Do you know what could be causing this ?
Hi Yehun, of course, you can do the out of the box alerts in SharePoint. Or you could set up a power automate on when the line item is modified. Or another option is to just let Power Apps do the work when you hit the save button when someone writes a new comment. There are many options.
This helps a ton, but like some of the other comments below I also need it to notify the individual similar to OOTB SP list notifications upon mentions... What's the most efficient way to do this? Thanks!
SO helpful! Thank you Andrew. The content you cover is practical and specific to so many use cases, and you really make things easy to understand. Your channel is an absolute goldmine.
Hi Andrew! i'm running into a problm where powerapps is giving me an error message with the left function, this is my formula and it's also embedded into the Patch code: Left(EnterComments.HtmlText,Len(EnterComments.HtmlText)-4)
Thank you Andrew, Your method helped me getting my running comments! Appreciate you sharing this knowledge with us. I have a unique issue. I love having a running comments either by me or by another user for the same Task. However, I need a Delete functionality. I should be able able to delete any one of my previous comments. Is it possible? I tried placing the comments in a gallery thinking that I could have a trash can to remove that item. However, it posted as a group of all the comments. I guess I am looking for the better of both world. Any thoughts on if it is possible? Thanks, SueA.
Hey Andrew, this is exactly what I was working on for the last two days! It's like you read my mind. Thanks for taking the time to make this great video. I'm sure it will be useful to many others too! I have immediately subscribed to your channel and am already curious about what I find there next ;) . Thanks again !
Once again, you are amazing!! I do have a question - is there a way I can edit previously left comments? I made the mistake of making a complicated power automation live before it was ready, and it accidentally added a poorly formated comment to ALL items instead of the one I intended to update. So now I want to go back and delete this comment on multiple items, as well as my test comments. I'd like the only thing left to be particular comments in each item which are actually left by users not as a test or during my accidental power automation run. Thank you!!
Great video! I'm working on a ticketing system and they are wanting to track who and when different fields were changed related to the ticket inside of the comment section as well as comments back and forth between users. It works great when a single field is being updated, but when multiple fields are updated it seems the patches overwrite each other so only 1 update is recorded in the comments column. Any ideas how to avoid that?
Hi Austin, maybe have 2 different patch statements depending on how you get to the screen. Create a variable and let yourself know if you're in Edit or New, and then change the patch statement based on true or false of that variable.
I think User() only displays the current user of the Power App, where as the connector can pull different users in your Azure, like with a people picker. But the same content should be in each.
@@andrewhess123 Yes I think so too. I only asked because I've had instances where User().DisplayName didnt match the value on the createdby display name on sharepoint even though it was the same user. Thought maybe office365 connectors would be more reliable. These days I just filter using the email address, more reliable.
@@kingsleyudeagha @udeagha I think you're right the o365 connector should be more reliable, but that is another connector you have to add.. and I believe when a user first uses your app with that connector it asks for permission, which could be confusing for some people. We'd have to look at the backend on Azure AD, there's all kinds of things going on there, names, name changes (when married), alias names, emails, custom columns.. etc. I'm not an Azure AD expert but do have some experience poking around there.
Hi Andrew, this helped a ton. do you know if "richComments" in your example can be made a required field? I tried it on a form where I inserted a "rich text editor" in a custom card. I made the card required, and put left("",-5) to default to make sure the content is empty. but I couldn't get it to work. all other required fields that I brought from "Edit Fields" on the form works but not this custom one. do you have any suggestions?
Hi Baris, glad its helpful. So if you put richComments in a regular label field does it have any content? Have you tried If(IsEmpty(richComments),Disabled,Edit) or If(IsBlank(richComments),Disabled,Edit) on your submit button DisplayMode. If its empty/blank then disabled else Edit.
There's no easy way or out of the box way from Microsoft of right now to just hitting the Enter Key. People are voting for that idea here:powerusers.microsoft.com/t5/Power-Apps-Ideas/Add-the-ability-to-run-formula-when-a-user-clicks-enter-return/idi-p/952001#M33832 To clear the field to type a new comment is possible using Reset
Hi Yehun, should be possible with an equation like: RemoveIf(datasource, primaryId = gallery.selected.primaryId). You could build a gallery instead also and say remove on thisitem.isselected. There are a few options
Thanks for watching Darren & Jenay, I made a new video on the same topic here: th-cam.com/video/_fe-a38y30Y/w-d-xo.html&t if you have time and want to check out more about running/appending comments
I have an app that needs a comments section adding to it. so good to see you do this similar to how I would have thought about doing it. Thanks again so helpful.
Awesome Phil, two great minds thinking alike! I'm sure other clever people will add on to these ideas for the comment section and make them even better too. Thanks for always watching and your support!
This is great example of how to implement comments in the app. Thanks for sharing this with the world, I'm sure a lot of us will use this kind of logic in our apps.
I feel you on the JavaScript and classic pages, I had to build a whole calendar there once, about 4 years ago I guess. Still have a customer who refuses to get off that classic calendar page too hahah :) can't convince them to try something new.. Thanks for watching Jonathan! Hope you're doing well
Hey Andrew, Important question here. Why does everytime i submit data to an item. The list of comments just resets, instead of showing the entire list of comments. Thanks in advance. Love the content.
Hey heelgaster, I'm guessing, there could be a few reasons, maybe your Patch Statement is overwriting instead of pulling in the previous comment, if you see the formula in the description. On the last line of the formula, this is where it rewrites the entire & htmlComments.HtmlText that was stored in my gallery to begin with. So you have to patch the new comments, with the o365().username, the date, and then also the old comments. Do you have your equation ?
@@andrewhess123 Hi Andrew, thank you for the reply. I have solved this issue by changing the comments column in sharepoint. It previously had the append text function enabled, but once i disabled it, the issue stopped. Thanks.
Hi heelgaster, I recently did something similar, and the main issue I ran into was I created a variable when in Edit Mode or New Mode, and patched differently depending on that variable.
@@heelgaster5552 Hi heelgaster really the main thing is to say if its Edit or New, and the formula on the patch statement when doing New you don't do a defaults. That way it writes a New line.
Hi Andrew, I just found this video very helpful. Does this work when populating lists in Microsoft Lists.
Should work the same with Lists, especially how Microsoft is pushing out the new List look and feel inside all SharePoint lists.
Love the video, I wish I could see the code better, sucks being newby and not knowing if its a curly brace, semi colon, parenthesis.
Sorry bfilling, I have been getting better and zooming in much more since this video. Some of the code is actually in the description of the video though too.
Hello, I have a question, why are the messages deleted in the Html.text display? The previous ones do not continue to be shown, only the most recent ones. Example:
ListInSharepoint: has values from previous days more than 1000 characters
Power app htmltext: 20 cartacters, lastcomment
hi josue, I'm not sure. make sure your column in Sharepoint is multi line text. Also when you patch make sure to grab the existing htlmtext.html + the newtext.html that you write. It should grab the previous html too.
Hi Andrew, as always, its a great video and can be utilize with many other apps, thank you for sharing your knowledge, look forward for more videos like this, 👍
Thanks for the kind words Imran, thanks for watching and the support!
@@andrewhess123, you are welcome!
Epic exactly what i m looking for ; I surfed the entire internet couldn't find anything similar that applies for my requirement. Thank you a lot Andrew. Q: my scenario requires a little extra work , Instead of comments I'm looking to add back n forth Q/A kinda feature for approval process, Literally the same SP List comment section. Before approving the manager may need some clarification from the PM , So when the manager asks something , I'd like to send some sort of notification/WF to the PM , Maybe using '@" . The manager(James) would say "@Andrew , Hey could you pls confirm if we've got resources?" , Then Andrew(PM) get notification and reply @James, Yes confirmed. How can i achieve this ? thanks
Awesome Yehun, glad it has a different use for your Sounds like a useful new feature. Thanks for watching Yehun!
That's actually a cool use case! I'm thinking of a CRM when you leave a comment for each time you talk to a customer, where you don't want to edit the comments, but just append.
Exactly the use case that I was assigned to create, for a CRM.
Andrew, great video! For a noobie, it was a little daunting to follow along but I followed the video to the letter and it worked first time! I do, however, have one question. In your video, you display the comments in the order [Comment] [Date] [Displayname]. For alignment purposes, I'd like to change the order to [Date] [Displayname] [Comment] but no matter how I have tried to edit the Item Property, it fails. Is this even possible?
Hi Garnea, it is definitely possible. Want to share your formula?
@@andrewhess123 Love to! It's been taking me literally days to figure out. Here's where I've gotten to so far...
Patch(IntakeTracker,BrowseGallery1.Selected,{
Comments:Left(RTE_Comments.HtmlText,
Len(RTE_Comments.HtmlText)-4) &
" - " &
Now()&
" - " &
"" &
Office365Users.MyProfile().DisplayName&
"" &
" - " &
HTML_Comments.HtmlText})
thanks for this! but may I ask, how about introducing a picture of that commenter beside his name? can you show us the function for that?
Good idea daredevil! Let me write this one down.
@@andrewhess123 looking forward on that!
Are all the comments there when you re-open the record?
In this scenario, yes.
This has a race condition if multiple users commenting at the same time. Some comments will get overwritten. i.e. last one in wins
Hmmm good point, maybe if you refresh the datasource before the patch it will fix the issue? That way it picks up the most recent comment no matter what
@@andrewhess123 yeah, it will reduce the likelihood but not eliminate. I wish they had native comment support. Great video btw. I think I'm going to write new comments to a separate table, and have a trigger flow process them and do the updates to the main record. This avoids the race condition.
@@GordonVartYep totally agree Gordon, separate table comments is probably the safest way.
Hey Andrew, I watched video and my comments section works but it's so inconsistent. It posts the comments on my sharepoint list and all the history is saved on there, but for some reason they disappear randomnly in my powerapp. Do you know what could be causing this ?
This was very helpful thanks
Thanks Kyle
I'm embarrassed to say how long I have been working on this same thing and you helped me finish it in about 30 minutes!
Wooo! Glad to help Susannah! No worries I have been working with Power Apps well over 3-4 years now! We both can keep learning.
Q:Is there a way to send notification/WF when a person leave new comment ?
Hi Yehun, of course, you can do the out of the box alerts in SharePoint. Or you could set up a power automate on when the line item is modified.
Or another option is to just let Power Apps do the work when you hit the save button when someone writes a new comment.
There are many options.
@@andrewhess123 thanks for speedy answer.
This is great. I have needed and wanted this functionality and you made it easy to understand and accomplish.
Thank you Melanie! Glad it was helpful!
This helps a ton, but like some of the other comments below I also need it to notify the individual similar to OOTB SP list notifications upon mentions... What's the most efficient way to do this? Thanks!
Absolutely Fantastic...Many thanks!!
Thank you Mark!
Great job, thank you!
Thank you Moises for watching!
SO helpful! Thank you Andrew. The content you cover is practical and specific to so many use cases, and you really make things easy to understand. Your channel is an absolute goldmine.
Thanks so much Wendy! I'm glad the style and videos are making an impact! 🏆🏆🏆
Hi Andrew! i'm running into a problm where powerapps is giving me an error message with the left function, this is my formula and it's also embedded into the Patch code: Left(EnterComments.HtmlText,Len(EnterComments.HtmlText)-4)
Thank you Andrew, Your method helped me getting my running comments! Appreciate you sharing this knowledge with us. I have a unique issue. I love having a running comments either by me or by another user for the same Task. However, I need a Delete functionality. I should be able able to delete any one of my previous comments. Is it possible? I tried placing the comments in a gallery thinking that I could have a trash can to remove that item. However, it posted as a group of all the comments. I guess I am looking for the better of both world. Any thoughts on if it is possible? Thanks, SueA.
Awesome Sue! Thanks for watching!
Hey Andrew, this is exactly what I was working on for the last two days! It's like you read my mind. Thanks for taking the time to make this great video. I'm sure it will be useful to many others too!
I have immediately subscribed to your channel and am already curious about what I find there next ;) . Thanks again !
Awesome Eduard! That's 2 peoples minds I've read today! I'm on a roll!! :D Thanks for watching Eduard!
Andrew, I wondered if you had a chance to look at my formula/syntax yet?
Once again, you are amazing!! I do have a question - is there a way I can edit previously left comments? I made the mistake of making a complicated power automation live before it was ready, and it accidentally added a poorly formated comment to ALL items instead of the one I intended to update. So now I want to go back and delete this comment on multiple items, as well as my test comments. I'd like the only thing left to be particular comments in each item which are actually left by users not as a test or during my accidental power automation run. Thank you!!
Hi Sarah, here is another video I made on those comments exactly: th-cam.com/video/_fe-a38y30Y/w-d-xo.html
Great video! I'm working on a ticketing system and they are wanting to track who and when different fields were changed related to the ticket inside of the comment section as well as comments back and forth between users. It works great when a single field is being updated, but when multiple fields are updated it seems the patches overwrite each other so only 1 update is recorded in the comments column. Any ideas how to avoid that?
Hi Austin, maybe have 2 different patch statements depending on how you get to the screen. Create a variable and let yourself know if you're in Edit or New, and then change the patch statement based on true or false of that variable.
User().DisplayName will also return the current users name. Does this have a different effect than the office365 connector ?
They should display the same, but I think user() is only for the current user.
I think User() only displays the current user of the Power App, where as the connector can pull different users in your Azure, like with a people picker. But the same content should be in each.
@@andrewhess123 Yes I think so too. I only asked because I've had instances where User().DisplayName didnt match the value on the createdby display name on sharepoint even though it was the same user. Thought maybe office365 connectors would be more reliable. These days I just filter using the email address, more reliable.
@@kingsleyudeagha @udeagha I think you're right the o365 connector should be more reliable, but that is another connector you have to add.. and I believe when a user first uses your app with that connector it asks for permission, which could be confusing for some people. We'd have to look at the backend on Azure AD, there's all kinds of things going on there, names, name changes (when married), alias names, emails, custom columns.. etc. I'm not an Azure AD expert but do have some experience poking around there.
@@andrewhess123 This is makes sense as well. It would be nice to know for sure.
Hi Andrew, this helped a ton. do you know if "richComments" in your example can be made a required field? I tried it on a form where I inserted a "rich text editor" in a custom card. I made the card required, and put left("",-5) to default to make sure the content is empty. but I couldn't get it to work. all other required fields that I brought from "Edit Fields" on the form works but not this custom one. do you have any suggestions?
Hi Baris, glad its helpful. So if you put richComments in a regular label field does it have any content?
Have you tried If(IsEmpty(richComments),Disabled,Edit) or If(IsBlank(richComments),Disabled,Edit) on your submit button DisplayMode. If its empty/blank then disabled else Edit.
Andrew, brilliant video. This is exactly the solution I’ve been looking for. Amazing.
Thanks so much Simon!
This is exactly what I have been looking for. Is there any way to submit when hitting the "Enter Key" and clear the field to type a new comment?
There's no easy way or out of the box way from Microsoft of right now to just hitting the Enter Key. People are voting for that idea here:powerusers.microsoft.com/t5/Power-Apps-Ideas/Add-the-ability-to-run-formula-when-a-user-clicks-enter-return/idi-p/952001#M33832
To clear the field to type a new comment is possible using Reset
This is very helpful!. Such a smart solution. Thank you!
Thanks for watching 8Steady!
You solved my problem. Many thanks for very informative and well explained video
Awesome Kashif, glad to help! Thanks for watching
Can we delete comments? 🤔
Hi Yehun, should be possible with an equation like: RemoveIf(datasource, primaryId = gallery.selected.primaryId). You could build a gallery instead also and say remove on thisitem.isselected. There are a few options
Thank you, i was not thinking about having a running comments and just overwriting. this is so much better.
Thanks for watching Darren & Jenay, I made a new video on the same topic here: th-cam.com/video/_fe-a38y30Y/w-d-xo.html&t if you have time and want to check out more about running/appending comments
Excellent video. Thanks a lot for taking some of your time to show is how this is done.
Thank you for watching Ainz. Let me know if there's more topics you'd like to learn.
I have an app that needs a comments section adding to it. so good to see you do this similar to how I would have thought about doing it. Thanks again so helpful.
Awesome Phil, two great minds thinking alike! I'm sure other clever people will add on to these ideas for the comment section and make them even better too. Thanks for always watching and your support!
This is great example of how to implement comments in the app. Thanks for sharing this with the world, I'm sure a lot of us will use this kind of logic in our apps.
Thanks much Goran! Hope I can provide more logic like this one :)
This is great. I had to build this last but I ended up doing it via JavaScript and the classic pages. As always thanks for sharing.
I feel you on the JavaScript and classic pages, I had to build a whole calendar there once, about 4 years ago I guess. Still have a customer who refuses to get off that classic calendar page too hahah :) can't convince them to try something new.. Thanks for watching Jonathan! Hope you're doing well
Great explanation and walkthrough. Thank you!
Thanks for watching norman!
Absolutely Amazing- Great tutorial
Thanks so much Lynn!
Hey Andrew, Important question here. Why does everytime i submit data to an item. The list of comments just resets, instead of showing the entire list of comments. Thanks in advance. Love the content.
Hey heelgaster, I'm guessing, there could be a few reasons, maybe your Patch Statement is overwriting instead of pulling in the previous comment, if you see the formula in the description.
On the last line of the formula, this is where it rewrites the entire & htmlComments.HtmlText that was stored in my gallery to begin with.
So you have to patch the new comments, with the o365().username, the date, and then also the old comments.
Do you have your equation ?
@@andrewhess123 Hi Andrew, thank you for the reply. I have solved this issue by changing the comments column in sharepoint. It previously had the append text function enabled, but once i disabled it, the issue stopped. Thanks.
@@heelgaster5552 ahhh interesting, thank you for letting me know heelgaster, glad you figured it out!
Hi Andrew, quick question. How would I implement this when creating an item so that i can add the comment directly when creating it.
Hi heelgaster, I recently did something similar, and the main issue I ran into was I created a variable when in Edit Mode or New Mode, and patched differently depending on that variable.
@@andrewhess123 HI Andrew, did you change anything specific in the formula?
@@heelgaster5552 Hi heelgaster really the main thing is to say if its Edit or New, and the formula on the patch statement when doing New you don't do a defaults. That way it writes a New line.
@@andrewhess123 Can you tell me what exactly the formula would say? I can't figure it out.
Here's an example but I don't know how much itll help. In order to explain things I really need a video.
Hey Andrew, Could you please help me to reorder the info 😞😞? Name, Date on new line comment. Just like SP comment section
Got it after some trials. Thanks for your time
@@yehunlavolontededieu322 Nice even better! 😊