@@RezaDorrani You are doing a fantastic job at that. Time and again when I'm searching for some answer in SharePoint Online or Power Platform and I see one of your videos in the results, I know I'm going to be able to do it. Thank you for all that you do!!!
You my friend are a "Super Genius". This is exactly what I've been looking for. Thank you. Also I just marvel at the amount of YT videos you produce on a monthly basis with a selfless approach to help and educate the masses. Your skill and knowledge is so impressive, especially to us mere mortals. Well done.👍
Update: With a recent update Char (10) [Line Feed] and Char (13) [Carriage Return] no longer work. Char (10) does produce a new line in labels (not buttons). Use "" instead.
Excellent tutorial, and i got it to work straight away. Awesome teacher and very clear in explanation 10/10. :-) So much better than InfoPath and looking forward to convert all my InfoPath forms to PowerApps form, but with some bells and whistles added to the look and feel for the user experience.
Hey Reza thanks for all the great info regarding Power Apps. It has been very helpful. Very happy that I joined. I have it working in a Customized List form but cannot seem to get it to work in a standalone canvas app.
Most welcome! Its been a long while since I did this video and do not recollect running into any issues. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
For those who encounter a "caching" issue, I fixed it by entering the formula that @RezaDorrani had in the Default field into the Update field and using ThisItem.Comments in the Default field. Thanks Reza for another awesome tutorial!
@@RezaDorrani No problem! The only downside is you don't get to see it update in real time. Not a huge deal, though. I think it has less to do with caching and more to do with retrieving and loading the data from the SP list in a timely manner. I don't have this problem when I use a small test list (few columns) like you did in the tutorial. But my production list has 30 columns with several lookup and calculated fields.
Reza great tutorial. I have implemented a Comments box in my form and the appending works great. However, when I create new rows in the Sharepoint List the Comments for a new row are populated with comments from another row in the list. Any advice on what this might be?
Thanks! I have not come across this issue and hence not sure what is the cause for your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Reza thank you so much for this it worked perfectly however I have a question please? How do you update this type of field in power automate as it seems to overwrite instead of append? Many thanks
Great video once again Reza. Would you have any ideas on how to notify or tag a user so they know there is a comment. Preferably a comment not made by them
Thank you so much for your excellent tutorial!! You are Awesome!! But, I have a question about the portion of "If Condition" on your video. If I want to add User's full name and Job title, grade, rank or phone... kind of user's more information, how to make it? I would appreciate if you advise.
Hi Reza, thankyou for your videos. This one in particular has solved some real issues for me. I do have an issue though. Where I'm writing my appended comments in 'appendCommentsHtml, in both the PowerApps designer/editor and New Form in SharePoint I'm seeing previous text. It's as if I have published it with text in it. How do I get rid of that text?
Its been a long while since I did this video hence do not remember the specifics. Concept in Video should still work. I would recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani thanks for the quick response, I seem to have resolved it simply by opening a new form, entering a carriage return as a comment which then cleared the test data comment history. I then cancelled the form, voila, no more legacy text in the form or designer. 👍
Hello Reza, thanks a lot for this! Do you know how this might work with a Power Automate flow that populates the email text body in the "Comments" field? Would it be then saved and populated automatically in the html text box? Many thanks once again
I am not sure as I have not tried this. I do not have a video reference on it and would have to try it out to provide guidance. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
This was awesome! I appreciate your content very much! I got this working inside a request Power App, my next goal is to be able to show users unread message count in the requests gallery, any thoughts on how to do that will be highly appreciated!
Thank You. You could run CountRows on gallery data. As for how to get unread messages, I do not have a video on this use case. I will recommend you check on the forums at powerusers.microsoft.com/
Hello thank you for this video! I was able to get this to work watching your video - wAtched so many other videos and yours was the first and only one that really made sense! Do you know if there is a way to expand on this and make it so you can edit the appended comments entered ?
Thank You! Glad to hear my videos are useful. You could make the appended comments editable. Instead of it being a label, you can make it a textbox. You would need to handle other aspects like default property and more. Not sure of the exact steps. I would have to try it out. Is this an admin only feature? A user (admin) could go directly to SharePoint list and edit the appended comments.
Hi @@RezaDorrani -- Does this only work on forms getting customized? I got it working on a modified form, but when trying to do a full Powerapp, I'm running into some odd things (e.g., the User().Fullname & Now() won't pull in right). Thank you!!
@@b8akaratn It should work in both. Formulas would be different for full Power Apps. I would have to try it out to provide any guidance. Give it a try and if you run into issues then post your query with screenshots on the forums at powerusers.microsoft.com/
Hi Reza. Many thanks for all your excellent videos. You have made my life so much easier as I try to get to grips with Power Apps. I've combined this into another one of your Apps (the Working with SharePoint List Relationships) for a Task Tracker that I'm developing. It all works perfect except I''ve found that if I open an item that has no comments - the appended comments from the last item I had open appear in the HTML control. If the user saves, those comments then get saved. For items that already have appended comments it seems OK. I've checked everthing but can't see what is causing this. Again, very many thanks for all that you do.
Thanks for watching and liking my videos. I will have to look at your App in action to provide guidance or try out the related tasks list scenario with append comments to know more. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Philip: I think I found the solution: just remove the If(Not(IsBlank(RichTextEditor.HtmlText)), OF THE FORMULA and start it with User().Fullname & “ “ & Now() & “ “ & RichTextEditor.HtmlText & Char(13)) & ThisItem.Comments) // Reza sent us to the 'man pages' since he did not have the answer.
Nice explanation. I have one doubt. Let’s say if two different users enter comments then DateTime won’t be in the same place right. How can we align the DateTime function to the right most part of the field. Thank you
@@RezaDorrani let’s say two users are commenting on the same item. Depending on their name length the Date and time would be shifting its position right. My doubt is, how can we make the Date and time stay in the same position irrespective to length of the commenters name. Thank you
I've been following your channel and question for you. Is there a way to edit existing comments that have been added already in the SharePoint list. A user made a typo error in the comment that they added previously. I want my user/admin to edit all of the comments shows on the screen.
Editing could be made possible. I would have to try it out to provide guidance. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
@@RezaDorrani Thank you for your reply.. I did check it on the forum and not found anything related to my requirement. I've posted my question in the forum.. In case if you find something let me know please.
@@bharanidharanboss Forums is a platform where you may or may not get a response. Sometimes you have to wait for days for a response as folks only respond in their free time. If this is time sensitive, then you may need to look at getting consulting help.
Reza, we implemented the Append function in our Preventive Maintenance Tracker power app. Thank you for the video it was very helpful. One follow up question, we want to see all the comments that have been appended on the PM Task view but the comment box shows blank until new comments are added. Once a comment is added, we can see the new comment, but not all the previous comments. Any ideas what we can do to bring ALL comments into view?
The video shows how to show all comments for a specific item. Im assuming something must not be done right which is causing the comments not to show up. I would recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
You may want to make sure that your sharepointForm is not displaying by default something that may be displaying the first item by default. Check under item and make sure you dont have unintended formula which could be causing it to select the first item. ee formula below that could cause what you are describing If( IsBlank(SharePointIntegration.Selected), First([@'Test List']), SharePointIntegration.Selected )
I have not come across this issue hence not sure what the reason could be. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
Hi Reza - Thank you so much for this video. This is exactly what I was looking for. Excellent job 👍 But I have a query. When I see my item that I created in sharepoint list, I see an option called "View Entries" under my multiline column. When I click on it, it shows the item, but it doesn't show me the comments for some reason (the HTML TEXT BOX) which should always be visible because it's visible property is set to true.
Thanks! In this video scenario, my column is multi line text - append changes turned OFF. You might have it turned on. Im not sure why it does not show comments in your scenario. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani really appreciate your super quick response! I found the solution. Apparently, I had set the HTML text box's height property to be equal to the height of my rich text box whereas it should always be static 🤦♂️. Blunder on my side. Thanks for this workaround by the way :)
You can add a clear button next to the comment. When user clicks on that set a variable. In default property, check value of variable. If variable is set then set default to empty else use the existing formula.
I have not come across this issue and hence not sure what the fix for your issue is. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
Hi Reza, is it possible to have multiline text storing history "approval" comments from Power Automate flow? It will be so cool to see you show us how to do that!
Probably possible. I make videos when I receive multiple requests on a topic. Every quarter I ask subscribers for topic suggestions on Community Tab of my channel. Most voted idea gets added to my backlog. Make sure to post this idea whenever I post the next topic suggestion post.
Hi ! Great solution to get around the problem of adding comments. I followed all your explanations. The richtextbox is well hidden (height=0) in view mode and displayed in edit mode but the position of the textboxhtml doesn't change. An explanation ?
You need to set Y property of textboxhtml relative to the hidden richtextbox. Check ua-cam.com/video/hzLEecSpmFo/v-deo.html If you are still running into issues, then I would have to look at your App in action to provide guidance & would recommend posting issue with screenshots on the forums at powerusers.microsoft.com/
Hello Rezza, Is there any option we can add Table as an input in Rich Text Editor? I see in SharePoint the Enhanced Rich Text handles Tables but Canvas PowerApps doesn't.
Hi Reza, I want to add the append comments section in forms. Do you have any videos on it? The thought behind is the approvers can use the comments section beneath the form to get some clarification on the details filled in the form and the user can explain in the comments section. Is it possible?
@@jayasriravichandran9455 If using form control, then patch will not be needed. I would have to try it out in form control to provide the steps and know more about the options. I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Great video. Solved my problem thanks. Question - In order to distinguish the latest comment is it possible to apply a formatting to the "User().FullName & " " & Now()" statement in the Default property? (i,e like a bold or underline). Tx F
Hi Reza ... nice video and great content as always ... but I get a problem at the part where you change der visible mode of the "richTextComments" if(MethodsForm.Mode=FormMode.View,false,true) ... do you know about this problem? Maybe someone had the same issue in the past. Thx in advance and best regards from Germany
Thanks Reza. Q: Can we tag users so they can get notified? basically can we bring in the list comments functionality into powerapps? At least access the comments section in sp through powerapps easily ...we have a task list so we utilize comment section heavily EPic failure MSFt 🤨this had to be built in feature in powerapps . so we move users to powerapps to access data but i need to tell them they need to go back to SP to comment ? 🤦♀️ even if commenting is possible how about notifying the tagged user? ugh msft
Should be possible but not something I have tried. Might be worth checking the forums in case someone has done this. Not everyone needs a commenting and tagging feature + it needs to be stored somewhere in a data source. Ideally, you should explore options to leverage the SharePoint commenting feature in power apps via Graph API (not sure if that’s an option though)
@@RezaDorrani yup that's all i need having access to the comment section sort of embedded whatever just through the app ...for each list item. Thanks Reza for taking your precious time and lending thoughts
@@yehunlavolontededieu322 Because its all in single column. You would have to break down the text and get to last comment and remove it. Would be complex.
Hi Reza, this looks great and hopefully this method still works. How would I grab the latest comment and append it to something? (rather than appending all comments).
All I remember is someone mentioned a month ago that they tried it and it still works fine. I did this video years ago and hence do not remember the specifics.
Hi Reza! Great video. Questions if you can help. Is it possible to make the User/Date text a different format than the rest of the line of text? I'd like to make them bold and the comment itself normal but I don't know how. Thank you!!
You would need to add a little bit of html formatting. Where in the Video I set the default value for the data card jts decorate the User Name and current date time with syntax. For formatting the date use the Text function within Power Apps docs.microsoft.com/en-us/powerapps/maker/canvas-apps/show-text-dates-times
Reza Dorrani I’m so new to all of this so I’m still confused. I know HTML and in a text doc I’d know where to put the tags, but in this case I just don’t know where to put them within the formula. I’ve tried defining the color and size in a different text field and then referencing that text field within the formula but it strips that formatting and displays the text all the same. I’ve read through that text function page and I’m still so confused. I’m sure you’re so busy but are there anymore hints you can provide me? I simply want the user name and date to be smaller font and a different color. Thanks again for your help!
Great! That work me and it is very helpful! Do you think it is possible if the user add a screenshot in the rich text box that it is shown then in the list as part of the historical comments? Thank you again!!
Since we are storing all comments in same column. We can allow edit comments. How? I would have to try it out to know the steps. I would recommend posting your query on forums in case someone has done something similar powerusers.microsoft.com
@@Maxi-zs2kg Forums would be your best bet. You can post your query and wait for a response. If it’s time sensitive, then you may want to look at getting consulting help
Should not be the case. I will have to look at your App in action to provide any guidance. I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com
Appreciate the response! I did wonder if there was a way to carry over timestamps from previous entries in the Sharepoint list. As I have moved from a standard form over to a power app on an existing list and have lost timestamps for any appended entries that was entered previously?
Hi Reza thank you for you contribution and sharing. I'd really appreciate to know I can prevent user add comments in the 'Details' option when they returned to SharePoint list upon closing the form. For the moment, any user can open the item details and change data, and when a new comment is added with this method, it will not be shown in the Form. Only the comments made in the Form are shown... any idea how to solve it?
Hi @@RezaDorrani thanks for your quick reply. I've found that we can turn off the Details panel in the advanced settings of the list. This will prevent users to edit items directly from there. But now I have another issue, if you, edit the item in the Form, change the Title and don't write any comments, then all the previous comments are gone. Form clean them completely and next time you edit the form you loose the comments history. How can we sort this out?
@@NunoGuerra When you say edit item in form, if form is in power app then the video shows how to maintain the comments. If form is edited in sharepoint itself, then it wont work.
@@RezaDorrani Then how can this be handled if my users are using the list in SharePoint and editing using Power Apps Form? Is there any alternative on the way of using Forms?
@@NunoGuerra Your comment states “users are using power apps form”. If form is power apps based, then my video itself shows how the append comments feature works. I would also reduce posting your issue with screenshots on the forums at powerusers.microsoft.com
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?
@@RezaDorrani thanks for the response, any idea if is there a way to tab indent inside the rich text editor? Currently pressing tab goes to the next control
hi sir , our paths cross again, seems inevitable :D Thanks once again for a great content, my use case is slightly different, i already had a form with data source as SharePoint List, to append changes to the List item, i have the 'Onselect' function of my button as 'SubmitForm(Formname), However nothing happens, the record doesn't get appended eventhough the Default Mode of my form is in 'Edit' mode, any idea what's wrong?
also worth mentioning that the count column is increasing with every submission, but i'm just not seeing the content being appended with the name of the user
@@RezaDorrani thanks Reza, i figured it out with the help of yet another video of yours. Is there a way that i could get the appended values in descending order so that the most recent comment/remark that is appended is at the top?
@@pythonblac130 Thats good to hear. Possibly make sure to append new value first and then the old values. Its been years since I did this video, so not much I remember.
Hi @RezaDorrani, I am having trouble when 2 users are trying to update the same line item. I want capture both users comments in a single line item but getting error: conflict exists on the server, please reload. Can you please suggest any method to avoid that error or show a custom error message to the user and reload the app by itself to have them submit again.
This is the case for any column update in power apps. There are options to check if updates were made by another user prior to saving. I have not explored them though. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Hi @reza thanks for the excellent video..may I request you to elaborate this content a little more as this is an old video..I have comment column and comments history column I want that whatever user enter in comment box go into comment history and comment field get reset to blank when item is submitted..please help
I did this video years ago, hence do not remember the specifics. I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
This video was done a long time ago. I have not attempted to export to excel. Surely possible but is something I have to try. I will recommend posting your query on forums at powerusers.microsoft.com
There seems to be a major issue being ignored which dozens of commenters have reported but I don't see a solution offered yet. If any other field in the form is edited or an attachment uploaded, the appended comments disappear. The only way to retain the comments is to always enter something in the comments field when editing anything on the form. As a quick fix, I have changed the default value of the comments field to include a space which results in a blank comment each time something on the form is edited, but at least prior comments are saved.
Hi Reza, thanks a lot for the solution. Please let me know if this is expected , so after I have completed the changes till the end , the comments are appending perfectly in share point however only the latest comment is getting reflected in power apps , is this expected? Does this solution make the entire comment history show up in the power apps field ?
Thanks I was trying to keep the versioning status on , in order to also fetch data from MS flow comments which triggered the issue, as I suppose the versioning needs to be turned off as a mandate?
@@RezaDorrani thanks a ton, I probably did something wrong but then I followed your steps without improvising from my end and it worked like a charm .. so I stopped trying with versioning turned on .. I thought once the versioning is enabled , only the last comment is considered as latest snapshot and is pulled into the front end app screen when the value is invoked
Reza, I followed the process and it works. This issue that I run into is that when I attempt to edit an item from my gallery and enter additional comments, the appended comments shown in the HTML text display doesn't match with the item being edited, but shows all comments, regardless of the items it was associated with. It doesn't seem to reset when I attempt to edit a different item from my list. For reference, I built this within a power app gallery. Any thoughts.
I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
This is a brilliant solution. Thank you. I had a little issue I can’t resolve. When I edit a second list item, the form shows the response to the first item in the list upon first edit. Then when I type a response, this comment disappears and is correctly replaced by the new comment. It is weird!
Might have to do with some form of caching. I have not come across this issue though. I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani many thanks for getting back to me. I managed to sort it out by setting the reset properties to true. This seemed to work, so definitely some caching issue.
@@danpaulharry Thank you for the reply! I still can't seem to find any setting called Reset. I've looked at each item under the Comments datacard. Edit: I seem to have fixed it by entering the formula that @Reza Dorrani had in the Default field into the Update field and using ThisItem.Comments in the Default field.
When you started with this form, you deleted the attachment field. In my form I have the attachment and every time a file is attached, the AppendCommentsHTML gets cleared and i lose my comments history. What happens during an attachment that is not handled by this code, how can I prevent the history to be lost during file attachment? Currently there are two versions made during an attachment and I have to manually restore to the one before the field is cleared to maintain my comments history.
Not sure about this with attachments. Should not cause an issue. I would have to try it out to provide guidance. I will recommend posting this issue with screenshots on the forums at powerusers.microsoft.com
This is exactly what I was looking for and it works great. How can we change the color of the user name or add indentation? That way it will be distinguished from the comment
You could add html code inside the functions to get that to work. I would have to recreate your scenario to provide any guidance. I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com
I made the "who" and "when" part Bold with the tag. It looks pretty good. My rich text is named "txtComments": If(Not(IsBlank(txtComments.HtmlText)), "" & User().FullName & " " & Now() & " " & txtComments.HtmlText & Char(13)) & ThisItem.Comments
Hey Reza, Thank you so much for this! I've almost implemented it successfully. Any idea why, upon saving it and coming back to the form, it erases all values except the most recent? Also is getting rid of the user/date infomation. ie. if I write "comment 1" it appears immediately as it should, but then when I save and reopen, it appears without the user/date info. If then write "comment 2" it appears as it should (immediately above the "comment 1"), but then after saving, comment 1 is erased and comment 2 remains, but without the user/date info.
Hi Colby, Not sure how to help you without checking your App in action. I myself tried this for one of my projects recently and followed it step by step and it worked. Would you mind trying the steps out one more time. Here is my latest code below (hope it helps) Comments data card "Default" property is as follow: If(Not(IsBlank(richTextComments.HtmlText)),""&User().FullName & " " & Text(Now(),"[$-en-US]dd/mm/yyyy") & " " & richTextComments.HtmlText & Char(13)) & ThisItem.Comments
Colby: I think I found the solution: just remove the If(Not(IsBlank(RichTextEditor.HtmlText)), OF THE FORMULA and start it with User().Fullname & “ “ & Now() & “ “ & RichTextEditor.HtmlText & Char(13)) & ThisItem.Comments) // Reza sent us to the 'man pages' since he did not have the answer.
when exporting the sharepoint list with appended comments to excel, the latest comment always is right next to the Name and Time. any advice to populate the new comment on a new line separate from the Name and Time. Previous Comments format as desired. Example: User TimeComment, Desired Outcome: User Time Comment.
I do not have a specific video on this scenario & would have to try it out to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Hi Reza, I entered in the same formula you had in my comments data card and my app is giving me an error message saying its creating a circular reference between properties. Is there a different way of entering in the formula? If( Not(IsBlank(enter_c.HtmlText)), User().FullName & " " & Now() & " " & enter_c.HtmlText & Char(13) ) & ThisItem.Comments
I have not come across this issue and hence not sure what the cause for it could be. I recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
Hi I have followed your instructions and established a similar one and it is really helpful.. but lately I have been seeing a weird problem.. whenever a choice column field value is changed in the item.. the history of appended text in the html vanishes.. I'm clueless on what to do here.. can you help?
I have not experienced this issue and not sure of the fix or cause. I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com in case someone has experienced something similar
Hi Reza. Fantastic solution. It seems at some point it stopped working for me though. The comments are still being appended, however, the html control I placed in my app stopped showing its content (which IS visible in the SharePoint list). Any insight you can offer? I'd love to be able to keep using this feature. Thank you.
I don’t think anything has changed to break this solution. This video was done years ago and I would have to look at your issue in action or recreate it at my end to provide any guidance. I will recommend posting your issue with screenshots on forums at powerusers.microsoft.com
@@RezaDorrani , sorry to be a bother but this can be resolved very quickly if I try to explain the issue. What happens is that the text stored in the appendCommentsHtml card is not visible until I start typing something in the RichTextEditor... After I post the comment, the content of the appendCommentsHtml card disappears again! My feeling is that the length of the text stored in the appendCommentsHtml card may be excessively long and has broken the solution. Could that be the case? Are there limitations to how much text you can add to the HTML box? The text regularly appears in the SharePoint list, so it does not seem to be an issue with text field limitations. Is there a quick workaround? I appreciate your help! Thank you
@@saln.4112 Quite possible. The thing is I have done this video 2 years ago and I do not have a running version of it. Your best bet will be to post your issue on the forums.
Hey Reza, I followed the tutorial and everything seemed to be working fine. But I just came across an issue when I try editing an already existing item. If I leave the comments text input blank while in edit mode, after saving the form, the entire field is cleared of any comments that were already there. Are you able to recreate this issue?
Hello Reza, Thanks for this brilliant video. Everything is working except new line append. my formula is : If(Not(IsBlank(MultiLineUserInput.Text)),User().FullName & " " & Now() & " " & MultiLineUserInput.Text & Char(13)) & ThisItem.'Latest Update' The only change I have done from yours is I have used Multiline plain text instead of Rich text because I need to store the new comments (in an another text field) every time user enters so that I can inform others via MS Flow email. While using Rich Text it stores the data in HTML format like ....text...... Any workaround for these? One more thing How to make User().FullName & " " & Now() in bold text?
I would need to try out your use case to see what your issue is. I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com To make text bold, in rich text box, you can use enter your text here
@@RezaDorrani I tried previously also but unfortunately power community do not show me button for posting support /question. Is there any badge need to earned for posting questions?
Hello - I'm trying to have comments added using Power Automate flow with the Dynamic Approvals. It will add the comments but removes them with the next approval. The approvals can be requested using same list item when the criteria changes. I've set up this and your Dynamic Approvals but can't seem to link them. Thank you.
I would have to reproduce the scenario at my end and try it out to know the steps and provide guidance. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
THIS IS BRILLIANT - THANK YOU very much for sharing. Small issue, my date from the Now() is printing the wrong way round (ie MMDDYYYY) even though my regional settings are set to Australia and DDMMYYYY by default - any ideas?
You are most welcome Kerrie. Hmmn regional settings. Interesting. Try to use the Text function and format the date. Reference: docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-datevalue-timevalue
Can anyone help me? I followed these instructions and everything works perfectly - except, if a change is made to the form and a comment is not added, all previous comments are deleted from the form/history. The comment counter total remains accurate but the text is gone. This only happens when a change is made to a form without a comment being included.
I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com It is tough to provide guidance here on chat without looking at your scenario in action.
I have this, too. Have you been able to resolve it? In the data card with all the stuff in it, the "Update" value has the original, hidden rt field name (so, "DataCardValue5.HtmlText" in the video example). Could the issue be there? Thanks!
UPDATE! I'm not sure if you are still looking for an answer, Tyler, but I figured it out. For your "Comments" field in the SPO list, disable the "Append to existing text" option, and in PowerApps, refresh the connection. My guess is the PowerApps code works, but the SPO field messes it up after the submit is done. HTH!
Where is the sequence number being used? is that necessary to have? I didn't add that for my form, but I noticed if an updated is made to the form but there are no new comments added, it seems to delete the previous comment history. is that because of the missing counter? if I add comments on every edit it's fine without the counter.
I am trying to do the same for attachments, to get the user name and time when the attachment was added. Have you made a video to append Attachments. Please let m know
Hi Reza, excellent video! It addressed many questions I had, but something is missing for me. Your example works well "Rich Text", but not "Enhanced Rich Text". I have a SharePoint where my users added over months lots of formatted tables. I customized the Form in PowerApps to add some additional features, controls, messages - looked really cool, but here is the problem: The existing Enhanced Rich text are displayed alright in the HTML Text control, BUT if I use the Rich Text Editor (which sucks BTW), all previous fancy formatting is lost. My users are asking me to roll back to the previous standard SharePoint experience - less fancy, but they can use an editor that gives full formatting (including Ctrl-C/V for tables) Any Idea on how to implement full enhanced in PowerApps?
I did notice that issue as well with enhanced rich text. I will have to do some investigation on this one. I will recommend you check on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Yes, you can have that. But Power Apps won’t show that information. You can define how many versions an item can hold. There is also an admin level setting for it. May be your admin has defined 3.
@@lpdowdell Power Apps only shows the latest version. Append on is a SharePoint list feature. This video does not work on that feature but gives a workaround way to achieve something similar.
I am having intermittent issues with the append comments field. In some of the list items I have, it saves the comments however in others, it does not. Can you help with this?
I have not come across the mentioned issue and hence not sure what the cause could be. I recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
I did this video 2 years ago. I believe all you would need to do is tweak the logic in the code to first append the historical data and then add the new comment at the end. It should be straight forward.
Excellent explanation, very clear and concise, straight to the point.
Kudos to you!
Now sir, you have another subscriber!
Thank you for the feedback and subscription.
Reza, you have saved me again. I don't know why everyone else makes stuff like this so complicated. I didn't even need a button control!
So glad to hear that! My goal is to explain and show things in the simplest possible way.
@@RezaDorrani You are doing a fantastic job at that. Time and again when I'm searching for some answer in SharePoint Online or Power Platform and I see one of your videos in the results, I know I'm going to be able to do it. Thank you for all that you do!!!
@@AlexRathwyn Most welcome
You my friend are a "Super Genius". This is exactly what I've been looking for. Thank you.
Also I just marvel at the amount of YT videos you produce on a monthly basis with a selfless approach to help and educate the masses. Your skill and knowledge is so impressive, especially to us mere mortals.
Well done.👍
Thank You so much for your kind words.
Thanks!
👍
This is exactly what I needed for a PowerApp! You have saved me hours of searching! Many thanks for the succinct explanation.
Glad to hear that. Thanks for watching.
Update:
With a recent update Char (10) [Line Feed] and Char (13) [Carriage Return] no longer work. Char (10) does produce a new line in labels (not buttons). Use "" instead.
Thanks for sharing
Excellent tutorial, and i got it to work straight away. Awesome teacher and very clear in explanation 10/10. :-) So much better than InfoPath and looking forward to convert all my InfoPath forms to PowerApps form, but with some bells and whistles added to the look and feel for the user experience.
Glad to hear that! Thanks so much for watching.
Hey Reza thanks for all the great info regarding Power Apps. It has been very helpful. Very happy that I joined. I have it working in a Customized List form but cannot seem to get it to work in a standalone canvas app.
Most welcome! Its been a long while since I did this video and do not recollect running into any issues. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
are you using rich text in your Canvas app?
Yes
For those who encounter a "caching" issue, I fixed it by entering the formula that @RezaDorrani had in the Default field into the Update field and using ThisItem.Comments in the Default field. Thanks Reza for another awesome tutorial!
Big thanks for sharing.
@@RezaDorrani No problem!
The only downside is you don't get to see it update in real time. Not a huge deal, though.
I think it has less to do with caching and more to do with retrieving and loading the data from the SP list in a timely manner. I don't have this problem when I use a small test list (few columns) like you did in the tutorial. But my production list has 30 columns with several lookup and calculated fields.
Thank you for this! It solved my issue with items showing comments from the item I previously had opened
Reza great tutorial. I have implemented a Comments box in my form and the appending works great. However, when I create new rows in the Sharepoint List the Comments for a new row are populated with comments from another row in the list. Any advice on what this might be?
Thanks!
I have not come across this issue and hence not sure what is the cause for your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@bobbach802 - I am having the same issue. Did you find a solution?
You are amazing! Thank you for having this video available.
You are so welcome!
Reza thank you so much for this it worked perfectly however I have a question please? How do you update this type of field in power automate as it seems to overwrite instead of append? Many thanks
Using similar logic as shown in video. Take new value and add join it with previous value.
Wow! Exactly what I needed! Thank you Reza. Now I go make coffee so I actually start the process.
Enjoy your coffee!
I cant believe how simple your solution is!!!
Simplicity for the win
Great video once again Reza. Would you have any ideas on how to notify or tag a user so they know there is a comment. Preferably a comment not made by them
You can send notifications from app. Tagging is not an option as this is a simple text control.
Thank you so much for your excellent tutorial!! You are Awesome!! But, I have a question about the portion of "If Condition" on your video. If I want to add User's full name and Job title, grade, rank or phone... kind of user's more information, how to make it? I would appreciate if you advise.
Simply append info to where the user full name and timestamp are placed.
Amazing video Reza. Do you happen to know how to use this method for a choice column?
I have not tried it with Choice column hence not sure
Good explanation. Will these comments also be exported to the Excel list when exporting?
Since all comments are stored in single column (and not using versioning concept), when exported to excel it will export the comments.
Hi Reza, thankyou for your videos. This one in particular has solved some real issues for me. I do have an issue though. Where I'm writing my appended comments in 'appendCommentsHtml, in both the PowerApps designer/editor and New Form in SharePoint I'm seeing previous text. It's as if I have published it with text in it. How do I get rid of that text?
Its been a long while since I did this video hence do not remember the specifics. Concept in Video should still work.
I would recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani thanks for the quick response, I seem to have resolved it simply by opening a new form, entering a carriage return as a comment which then cleared the test data comment history. I then cancelled the form, voila, no more legacy text in the form or designer. 👍
Hello Reza, thanks a lot for this! Do you know how this might work with a Power Automate flow that populates the email text body in the "Comments" field? Would it be then saved and populated automatically in the html text box? Many thanks once again
I am not sure as I have not tried this. I do not have a video reference on it and would have to try it out to provide guidance. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
This was awesome! I appreciate your content very much!
I got this working inside a request Power App, my next goal is to be able to show users unread message count in the requests gallery, any thoughts on how to do that will be highly appreciated!
Thank You.
You could run CountRows on gallery data. As for how to get unread messages, I do not have a video on this use case. I will recommend you check on the forums at powerusers.microsoft.com/
Hello thank you for this video! I was able to get this to work watching your video - wAtched so many other videos and yours was the first and only one that really made sense! Do you know if there is a way to expand on this and make it so you can edit the appended comments entered ?
Thank You! Glad to hear my videos are useful.
You could make the appended comments editable. Instead of it being a label, you can make it a textbox. You would need to handle other aspects like default property and more. Not sure of the exact steps. I would have to try it out.
Is this an admin only feature? A user (admin) could go directly to SharePoint list and edit the appended comments.
Excellent Reza. In this scenario, Is there a way to update another column(Ex: Column 2) with last comment from Comments (Column 1).
Possible. In the code where I append the earlier comments, all you would have to do for new column is to place the latest comments and do not append.
What a creative solution!! ⭐️⭐️⭐️⭐️⭐️
Thank you !!! It means a lot coming from you
Yeah this is fantastic; I don't have to set up a companion table to capture multiple specific updates -- THANK YOU!! 🙌👏
🤩 Thanks
Hi @@RezaDorrani -- Does this only work on forms getting customized? I got it working on a modified form, but when trying to do a full Powerapp, I'm running into some odd things (e.g., the User().Fullname & Now() won't pull in right). Thank you!!
@@b8akaratn It should work in both. Formulas would be different for full Power Apps. I would have to try it out to provide any guidance. Give it a try and if you run into issues then post your query with screenshots on the forums at powerusers.microsoft.com/
@@RezaDorrani it totally works on a full app (I must've had some bad extraneous stuff before) :-) Thanks again, Reza!
@@b8akaratn Great!
Awesome tutorial, just what I was looking for
Reza you are a life saver man
Thank you so much. :)
You're most welcome!
Hi Reza. Many thanks for all your excellent videos. You have made my life so much easier as I try to get to grips with Power Apps. I've combined this into another one of your Apps (the Working with SharePoint List Relationships) for a Task Tracker that I'm developing. It all works perfect except I''ve found that if I open an item that has no comments - the appended comments from the last item I had open appear in the HTML control. If the user saves, those comments then get saved. For items that already have appended comments it seems OK. I've checked everthing but can't see what is causing this. Again, very many thanks for all that you do.
Thanks for watching and liking my videos.
I will have to look at your App in action to provide guidance or try out the related tasks list scenario with append comments to know more. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani Wow Reza - will do as you suggest. But just wanted to say thanks for taking time out of your day for such a fast response.
@@philipbowers9635 You are most welcome
Philip: I think I found the solution: just remove the If(Not(IsBlank(RichTextEditor.HtmlText)), OF THE FORMULA and start it with User().Fullname & “ “ & Now() & “ “ & RichTextEditor.HtmlText & Char(13)) & ThisItem.Comments) // Reza sent us to the 'man pages' since he did not have the answer.
Nice explanation.
I have one doubt.
Let’s say if two different users enter comments then DateTime won’t be in the same place right.
How can we align the DateTime function to the right most part of the field.
Thank you
Thanks.
I did not understand the question.
Comments would be appended and separated by new line character.
@@RezaDorrani let’s say two users are commenting on the same item. Depending on their name length the Date and time would be shifting its position right.
My doubt is, how can we make the Date and time stay in the same position irrespective to length of the commenters name.
Thank you
@@VOUGEGAMINGAKD Put date and time first and then their names.
@@RezaDorrani Is this the only possible solution?
Thanks for you help.
@@VOUGEGAMINGAKD There may be more options. I will recommend checking on the forums at powerusers.microsoft.com
I've been following your channel and question for you. Is there a way to edit existing comments that have been added already in the SharePoint list. A user made a typo error in the comment that they added previously. I want my user/admin to edit all of the comments shows on the screen.
Editing could be made possible. I would have to try it out to provide guidance. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
@@RezaDorrani Thank you for your reply.. I did check it on the forum and not found anything related to my requirement. I've posted my question in the forum.. In case if you find something let me know please.
@@bharanidharanboss Forums is a platform where you may or may not get a response. Sometimes you have to wait for days for a response as folks only respond in their free time. If this is time sensitive, then you may need to look at getting consulting help.
Hi Reza, congratulations for video. Well Done!!!
Thank you very much!
Hello Reza, another neat video from you. Thank you!
Glad you enjoyed it!
Reza, we implemented the Append function in our Preventive Maintenance Tracker power app. Thank you for the video it was very helpful. One follow up question, we want to see all the comments that have been appended on the PM Task view but the comment box shows blank until new comments are added. Once a comment is added, we can see the new comment, but not all the previous comments. Any ideas what we can do to bring ALL comments into view?
The video shows how to show all comments for a specific item. Im assuming something must not be done right which is causing the comments not to show up. I would recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
You may want to make sure that your sharepointForm is not displaying by default something that may be displaying the first item by default. Check under item and make sure you dont have unintended formula which could be causing it to select the first item. ee formula below that could cause what you are describing
If(
IsBlank(SharePointIntegration.Selected),
First([@'Test List']),
SharePointIntegration.Selected
)
Hey Reza! Excellent video and thank you. My comments are not resetting when adding a new list item. Do you know how I might resolve this?
I have not come across this issue hence not sure what the reason could be. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
Great demo. Thank you!
Most welcome
Excellent video, Reza! Is there a way to write new entries at the "top" of the existing text?
Its been years since I did this video. Idea would be to add the new comment and then append the existing values.
Hi, keep posting ... I'll watch all the videos .. You're being my reference
#Brazil
Thank you and I will keep trying my best.
Hi Reza - Thank you so much for this video. This is exactly what I was looking for. Excellent job 👍
But I have a query. When I see my item that I created in sharepoint list, I see an option called "View Entries" under my multiline column. When I click on it, it shows the item, but it doesn't show me the comments for some reason (the HTML TEXT BOX) which should always be visible because it's visible property is set to true.
Thanks!
In this video scenario, my column is multi line text - append changes turned OFF. You might have it turned on. Im not sure why it does not show comments in your scenario. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani really appreciate your super quick response!
I found the solution. Apparently, I had set the HTML text box's height property to be equal to the height of my rich text box whereas it should always be static 🤦♂️. Blunder on my side. Thanks for this workaround by the way :)
@@jagritsharma. Most welcome
Very nice demonstration and very helpful. How can we delete an added comment if we want to? Thanks
You can add a clear button next to the comment. When user clicks on that set a variable. In default property, check value of variable. If variable is set then set default to empty else use the existing formula.
Hi Reza!!
This worked like charm. I had a issue when i add an attachments the comments all gets disappered. Any idea.
I have not come across this issue and hence not sure what the fix for your issue is. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
Hi Reza, is it possible to have multiline text storing history "approval" comments from Power Automate flow? It will be so cool to see you show us how to do that!
Probably possible.
I make videos when I receive multiple requests on a topic. Every quarter I ask subscribers for topic suggestions on Community Tab of my channel. Most voted idea gets added to my backlog. Make sure to post this idea whenever I post the next topic suggestion post.
This is so badass...!!! Great job breaking this down.
Thank You
Great video, thanks!! Is it possible to create this functionality with normal multiple lines of text column which is not Rich text?
Peter Griac Yes
Hi ! Great solution to get around the problem of adding comments.
I followed all your explanations. The richtextbox is well hidden (height=0) in view mode and displayed in edit mode but the position of the textboxhtml doesn't change. An explanation ?
You need to set Y property of textboxhtml relative to the hidden richtextbox.
Check ua-cam.com/video/hzLEecSpmFo/v-deo.html
If you are still running into issues, then I would have to look at your App in action to provide guidance & would recommend posting issue with screenshots on the forums at powerusers.microsoft.com/
You are really the super genius) so simple and so efficient approach! Thank you!
Most welcome
Reza this works great! I was looking for a workaround just like this. A+
Thanks Mark.
This is an old video and happy to know its still useful
Hello Rezza,
Is there any option we can add Table as an input in Rich Text Editor?
I see in SharePoint the Enhanced Rich Text handles Tables but Canvas PowerApps doesn't.
I am not sure about that
Hi Reza, I want to add the append comments section in forms. Do you have any videos on it? The thought behind is the approvers can use the comments section beneath the form to get some clarification on the details filled in the form and the user can explain in the comments section. Is it possible?
It should be possible. I don’t have any videos on it though.
Can you help me on this please.. Does the patch function work?
@@jayasriravichandran9455 If using form control, then patch will not be needed.
I would have to try it out in form control to provide the steps and know more about the options.
I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
This is fantastic and exactly what I was searching for!
Great! Thanks for watching.
Great video. Solved my problem thanks. Question - In order to distinguish the latest comment is it possible to apply a formatting to the "User().FullName & " " & Now()" statement in the Default property? (i,e like a bold or underline). Tx F
Yes
Hi Reza ... nice video and great content as always ... but I get a problem at the part where you change der visible mode of the "richTextComments" if(MethodsForm.Mode=FormMode.View,false,true) ... do you know about this problem? Maybe someone had the same issue in the past.
Thx in advance and best regards from Germany
Thanks!
I did this video a long time ago and don’t remember running into this issue.
Thanks Reza. Q: Can we tag users so they can get notified? basically can we bring in the list comments functionality into powerapps? At least access the comments section in sp through powerapps easily ...we have a task list so we utilize comment section heavily
EPic failure MSFt 🤨this had to be built in feature in powerapps . so we move users to powerapps to access data but i need to tell them they need to go back to SP to comment ? 🤦♀️ even if commenting is possible how about notifying the tagged user? ugh msft
Should be possible but not something I have tried. Might be worth checking the forums in case someone has done this.
Not everyone needs a commenting and tagging feature + it needs to be stored somewhere in a data source.
Ideally, you should explore options to leverage the SharePoint commenting feature in power apps via Graph API (not sure if that’s an option though)
@@RezaDorrani Thank you 🙏 I'll try
@@RezaDorrani yup that's all i need having access to the comment section sort of embedded whatever just through the app ...for each list item. Thanks Reza for taking your precious time and lending thoughts
Can we delete a single comment?🤔 after submission
@@yehunlavolontededieu322 Because its all in single column. You would have to break down the text and get to last comment and remove it. Would be complex.
Hi Reza, this looks great and hopefully this method still works. How would I grab the latest comment and append it to something? (rather than appending all comments).
All I remember is someone mentioned a month ago that they tried it and it still works fine.
I did this video years ago and hence do not remember the specifics.
Hi Reza! Great video. Questions if you can help. Is it possible to make the User/Date text a different format than the rest of the line of text? I'd like to make them bold and the comment itself normal but I don't know how. Thank you!!
You would need to add a little bit of html formatting.
Where in the Video I set the default value for the data card jts decorate the User Name and current date time with syntax.
For formatting the date use the Text function within Power Apps
docs.microsoft.com/en-us/powerapps/maker/canvas-apps/show-text-dates-times
Reza Dorrani I’m so new to all of this so I’m still confused. I know HTML and in a text doc I’d know where to put the tags, but in this case I just don’t know where to put them within the formula. I’ve tried defining the color and size in a different text field and then referencing that text field within the formula but it strips that formatting and displays the text all the same. I’ve read through that text function page and I’m still so confused. I’m sure you’re so busy but are there anymore hints you can provide me? I simply want the user name and date to be smaller font and a different color. Thanks again for your help!
Very Nice. My students will love this
👍
Great! That work me and it is very helpful! Do you think it is possible if the user add a screenshot in the rich text box that it is shown then in the list as part of the historical comments? Thank you again!!
I dont think so but would be a good one to try
Excellent tutorial... You've saved my day :)
You’re most welcome
Hello, great video. I would like to be able to edit the created comments. Is that possible and if so how? Thanks a lot for your help
Since we are storing all comments in same column. We can allow edit comments.
How? I would have to try it out to know the steps. I would recommend posting your query on forums in case someone has done something similar
powerusers.microsoft.com
@@RezaDorrani Hello thank you for the answer. Unfortunately I didn't find any useful results in forums.
@@Maxi-zs2kg Forums would be your best bet. You can post your query and wait for a response. If it’s time sensitive, then you may want to look at getting consulting help
Nice one Reza
Thanks
Thank you so much Reza!
You are most welcome David
Another very useful video, thanks!
Most welcome!
Great guide! I am having a minor issue where my first appended change is not displaying until I enter a second, it then reappears. Any ideas? 🤔
Should not be the case. I will have to look at your App in action to provide any guidance. I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani I think I have it figured out. Another data card was clipping over the top and obscuring the view. 🤭
Appreciate the response! I did wonder if there was a way to carry over timestamps from previous entries in the Sharepoint list. As I have moved from a standard form over to a power app on an existing list and have lost timestamps for any appended entries that was entered previously?
@@idolwon5584 Not sure about this one. I will have to try it out.
@@RezaDorrani I think it's versioning that is causing the issue. As each update creates a new version of the item. Great video by the way 😊
This saved lot of my time. Thank you so much.
You're welcome!
Excellent tutorial!
Thank you!
Hi Reza thank you for you contribution and sharing. I'd really appreciate to know I can prevent user add comments in the 'Details' option when they returned to SharePoint list upon closing the form. For the moment, any user can open the item details and change data, and when a new comment is added with this method, it will not be shown in the Form. Only the comments made in the Form are shown... any idea how to solve it?
To block users from editing in SharePoint after a particular state, the best option would be to break permissions for that item.
Hi @@RezaDorrani thanks for your quick reply. I've found that we can turn off the Details panel in the advanced settings of the list. This will prevent users to edit items directly from there. But now I have another issue, if you, edit the item in the Form, change the Title and don't write any comments, then all the previous comments are gone. Form clean them completely and next time you edit the form you loose the comments history. How can we sort this out?
@@NunoGuerra When you say edit item in form, if form is in power app then the video shows how to maintain the comments.
If form is edited in sharepoint itself, then it wont work.
@@RezaDorrani Then how can this be handled if my users are using the list in SharePoint and editing using Power Apps Form? Is there any alternative on the way of using Forms?
@@NunoGuerra Your comment states “users are using power apps form”. If form is power apps based, then my video itself shows how the append comments feature works.
I would also reduce posting your issue with screenshots on the forums at
powerusers.microsoft.com
Hi Reza, how many updates does this multiline rich Text column (not appending ) store? 10 more than 10?
Yes since we are appending to the same multi line text column.
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?
Im not sure about this.
I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
@@RezaDorrani thanks for the response, any idea if is there a way to tab indent inside the rich text editor? Currently pressing tab goes to the next control
@@SrSneakyBoy I dont think that is possible but I have nt tried that before.
hi sir , our paths cross again, seems inevitable :D
Thanks once again for a great content, my use case is slightly different, i already had a form with data source as SharePoint List, to append changes to the List item, i have the 'Onselect' function of my button as 'SubmitForm(Formname), However nothing happens, the record doesn't get appended eventhough the Default Mode of my form is in 'Edit' mode, any idea what's wrong?
also worth mentioning that the count column is increasing with every submission, but i'm just not seeing the content being appended with the name of the user
Im not sure what the cause of the issue could be. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani thanks Reza, i figured it out with the help of yet another video of yours. Is there a way that i could get the appended values in descending order so that the most recent comment/remark that is appended is at the top?
@@pythonblac130 Thats good to hear. Possibly make sure to append new value first and then the old values. Its been years since I did this video, so not much I remember.
Hi @RezaDorrani, I am having trouble when 2 users are trying to update the same line item. I want capture both users comments in a single line item but getting error: conflict exists on the server, please reload. Can you please suggest any method to avoid that error or show a custom error message to the user and reload the app by itself to have them submit again.
This is the case for any column update in power apps. There are options to check if updates were made by another user prior to saving. I have not explored them though.
I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Hi @reza thanks for the excellent video..may I request you to elaborate this content a little more as this is an old video..I have comment column and comments history column I want that whatever user enter in comment box go into comment history and comment field get reset to blank when item is submitted..please help
I did this video years ago, hence do not remember the specifics.
I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
It worked! Thanks. Do you know how to export only the last comment to Excel? It exports them all. I only want the latest comment.
This video was done a long time ago. I have not attempted to export to excel. Surely possible but is something I have to try. I will recommend posting your query on forums at powerusers.microsoft.com
There seems to be a major issue being ignored which dozens of commenters have reported but I don't see a solution offered yet. If any other field in the form is edited or an attachment uploaded, the appended comments disappear. The only way to retain the comments is to always enter something in the comments field when editing anything on the form. As a quick fix, I have changed the default value of the comments field to include a space which results in a blank comment each time something on the form is edited, but at least prior comments are saved.
Thanks for sharing
Excellent solution.
Thank you
Hi Reza, thanks a lot for the solution. Please let me know if this is expected , so after I have completed the changes till the end , the comments are appending perfectly in share point however only the latest comment is getting reflected in power apps , is this expected? Does this solution make the entire comment history show up in the power apps field ?
Yes it will. Check all the steps in video. It will show the history in Power Apps.
Thanks I was trying to keep the versioning status on , in order to also fetch data from MS flow comments which triggered the issue, as I suppose the versioning needs to be turned off as a mandate?
@@yourstruly9777 Not necessary. In my case I do not need versioning since I am manually maintaining the history.
@@RezaDorrani thanks a ton, I probably did something wrong but then I followed your steps without improvising from my end and it worked like a charm .. so I stopped trying with versioning turned on .. I thought once the versioning is enabled , only the last comment is considered as latest snapshot and is pulled into the front end app screen when the value is invoked
@@yourstruly9777 Hope it worked
Reza, I followed the process and it works. This issue that I run into is that when I attempt to edit an item from my gallery and enter additional comments, the appended comments shown in the HTML text display doesn't match with the item being edited, but shows all comments, regardless of the items it was associated with. It doesn't seem to reset when I attempt to edit a different item from my list. For reference, I built this within a power app gallery. Any thoughts.
I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Nice job just what I was looking for
Glad it was helpful
This is a brilliant solution. Thank you. I had a little issue I can’t resolve. When I edit a second list item, the form shows the response to the first item in the list upon first edit. Then when I type a response, this comment disappears and is correctly replaced by the new comment. It is weird!
Might have to do with some form of caching. I have not come across this issue though.
I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani many thanks for getting back to me. I managed to sort it out by setting the reset properties to true. This seemed to work, so definitely some caching issue.
@@danpaulharry I also have this issue. Where is the reset properties you are referring to?
@@jdbrookins it is in the advanced properties of the datacardvalue for the original text box. Under data you will see the reset property
@@danpaulharry Thank you for the reply! I still can't seem to find any setting called Reset. I've looked at each item under the Comments datacard.
Edit: I seem to have fixed it by entering the formula that @Reza Dorrani had in the Default field into the Update field and using ThisItem.Comments in the Default field.
When you started with this form, you deleted the attachment field. In my form I have the attachment and every time a file is attached, the AppendCommentsHTML gets cleared and i lose my comments history. What happens during an attachment that is not handled by this code, how can I prevent the history to be lost during file attachment? Currently there are two versions made during an attachment and I have to manually restore to the one before the field is cleared to maintain my comments history.
Not sure about this with attachments. Should not cause an issue. I would have to try it out to provide guidance. I will recommend posting this issue with screenshots on the forums at powerusers.microsoft.com
This is exactly what I was looking for and it works great. How can we change the color of the user name or add indentation? That way it will be distinguished from the comment
You could add html code inside the functions to get that to work. I would have to recreate your scenario to provide any guidance. I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com
I made the "who" and "when" part Bold with the tag. It looks pretty good. My rich text is named "txtComments":
If(Not(IsBlank(txtComments.HtmlText)), "" & User().FullName & " " & Now() & " " & txtComments.HtmlText & Char(13)) & ThisItem.Comments
Hey Reza,
Thank you so much for this! I've almost implemented it successfully. Any idea why, upon saving it and coming back to the form, it erases all values except the most recent? Also is getting rid of the user/date infomation.
ie. if I write "comment 1" it appears immediately as it should, but then when I save and reopen, it appears without the user/date info. If then write "comment 2" it appears as it should (immediately above the "comment 1"), but then after saving, comment 1 is erased and comment 2 remains, but without the user/date info.
Hi Colby, Not sure how to help you without checking your App in action. I myself tried this for one of my projects recently and followed it step by step and it worked.
Would you mind trying the steps out one more time.
Here is my latest code below (hope it helps)
Comments data card "Default" property is as follow:
If(Not(IsBlank(richTextComments.HtmlText)),""&User().FullName & " " & Text(Now(),"[$-en-US]dd/mm/yyyy") & " " & richTextComments.HtmlText & Char(13)) & ThisItem.Comments
Colby: I think I found the solution: just remove the If(Not(IsBlank(RichTextEditor.HtmlText)), OF THE FORMULA and start it with User().Fullname & “ “ & Now() & “ “ & RichTextEditor.HtmlText & Char(13)) & ThisItem.Comments) // Reza sent us to the 'man pages' since he did not have the answer.
Credits!!! Great work!! Helped a lot!
Thanks for watching
You are so smart : )
Thanks :)
when exporting the sharepoint list with appended comments to excel, the latest comment always is right next to the Name and Time. any advice to populate the new comment on a new line separate from the Name and Time. Previous Comments format as desired.
Example: User TimeComment,
Desired Outcome: User Time
Comment.
I do not have a specific video on this scenario & would have to try it out to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Hello Reza. Will this work with plain text?
Yes it should
Hi Reza, I entered in the same formula you had in my comments data card and my app is giving me an error message saying its creating a circular reference between properties. Is there a different way of entering in the formula?
If(
Not(IsBlank(enter_c.HtmlText)),
User().FullName & " " & Now() & " " & enter_c.HtmlText & Char(13)
) & ThisItem.Comments
I have not come across this issue and hence not sure what the cause for it could be.
I recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
Hi I have followed your instructions and established a similar one and it is really helpful.. but lately I have been seeing a weird problem.. whenever a choice column field value is changed in the item.. the history of appended text in the html vanishes.. I'm clueless on what to do here.. can you help?
I have not experienced this issue and not sure of the fix or cause.
I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com in case someone has experienced something similar
Hi Reza. Fantastic solution. It seems at some point it stopped working for me though. The comments are still being appended, however, the html control I placed in my app stopped showing its content (which IS visible in the SharePoint list). Any insight you can offer? I'd love to be able to keep using this feature. Thank you.
I don’t think anything has changed to break this solution. This video was done years ago and I would have to look at your issue in action or recreate it at my end to provide any guidance.
I will recommend posting your issue with screenshots on forums at powerusers.microsoft.com
@@RezaDorrani I will dig deeper and post the issue. Thank you. PS: do you offer one-to-one training?
@@RezaDorrani , sorry to be a bother but this can be resolved very quickly if I try to explain the issue. What happens is that the text stored in the appendCommentsHtml card is not visible until I start typing something in the RichTextEditor... After I post the comment, the content of the appendCommentsHtml card disappears again! My feeling is that the length of the text stored in the appendCommentsHtml card may be excessively long and has broken the solution. Could that be the case? Are there limitations to how much text you can add to the HTML box? The text regularly appears in the SharePoint list, so it does not seem to be an issue with text field limitations. Is there a quick workaround? I appreciate your help! Thank you
@@saln.4112 I do not offer 1:1 training
@@saln.4112 Quite possible. The thing is I have done this video 2 years ago and I do not have a running version of it. Your best bet will be to post your issue on the forums.
Hey Reza, I followed the tutorial and everything seemed to be working fine. But I just came across an issue when I try editing an already existing item. If I leave the comments text input blank while in edit mode, after saving the form, the entire field is cleared of any comments that were already there. Are you able to recreate this issue?
Hi, I did this video 3 years ago. I no longer have access to app or was able to recreate this issue.
Hello Reza,
Thanks for this brilliant video. Everything is working except new line append.
my formula is : If(Not(IsBlank(MultiLineUserInput.Text)),User().FullName & " " & Now() & " " & MultiLineUserInput.Text & Char(13)) & ThisItem.'Latest Update'
The only change I have done from yours is I have used Multiline plain text instead of Rich text because I need to store the new comments (in an another text field) every time user enters so that I can inform others via MS Flow email. While using Rich Text it stores the data in HTML format like ....text...... Any workaround for these?
One more thing How to make User().FullName & " " & Now() in bold text?
I would need to try out your use case to see what your issue is. I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com
To make text bold, in rich text box, you can use enter your text here
@@RezaDorrani I tried previously also but unfortunately power community do not show me button for posting support /question. Is there any badge need to earned for posting questions?
@@LAXMIKANT1992 Its an open community for everyone to post. powerusers.microsoft.com/t5/Building-Power-Apps/bd-p/PowerAppsForum1
Hello - I'm trying to have comments added using Power Automate flow with the Dynamic Approvals. It will add the comments but removes them with the next approval. The approvals can be requested using same list item when the criteria changes. I've set up this and your Dynamic Approvals but can't seem to link them. Thank you.
I would have to reproduce the scenario at my end and try it out to know the steps and provide guidance. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Thanks for saving me :)
👍
THIS IS BRILLIANT - THANK YOU very much for sharing. Small issue, my date from the Now() is printing the wrong way round (ie MMDDYYYY) even though my regional settings are set to Australia and DDMMYYYY by default - any ideas?
You are most welcome Kerrie.
Hmmn regional settings. Interesting. Try to use the Text function and format the date.
Reference: docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-datevalue-timevalue
Hi Kerrie, did you manage to add the text function? As I also need to use DDMMYYYY format! Cant figure out where to put it :/
Can anyone help me? I followed these instructions and everything works perfectly - except, if a change is made to the form and a comment is not added, all previous comments are deleted from the form/history. The comment counter total remains accurate but the text is gone. This only happens when a change is made to a form without a comment being included.
I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com
It is tough to provide guidance here on chat without looking at your scenario in action.
I have this, too. Have you been able to resolve it? In the data card with all the stuff in it, the "Update" value has the original, hidden rt field name (so, "DataCardValue5.HtmlText" in the video example). Could the issue be there? Thanks!
UPDATE! I'm not sure if you are still looking for an answer, Tyler, but I figured it out. For your "Comments" field in the SPO list, disable the "Append to existing text" option, and in PowerApps, refresh the connection. My guess is the PowerApps code works, but the SPO field messes it up after the submit is done. HTH!
HERE IS A SOLUTION: File/Settings/Upcoming Features/Experimental, then turn on Formula-level error management. It works!!!!!
Where is the sequence number being used? is that necessary to have? I didn't add that for my form, but I noticed if an updated is made to the form but there are no new comments added, it seems to delete the previous comment history. is that because of the missing counter? if I add comments on every edit it's fine without the counter.
Goal here is to ensure we keep appending the existing comment to the old comment.
I am trying to do the same for attachments, to get the user name and time when the attachment was added. Have you made a video to append Attachments. Please let m know
I have not made a video for this scenario
@@RezaDorrani thank you for your response. This video is excellent, very clear and precise. Helped me apply it on all of my lists.
Will this work on existing List with Comments that have appended text?
I have not tried it but my guess is Yes
Is there a way to notify users when people comment on their items?
You could use the send email action to send notification when a comment is made.
ua-cam.com/video/GoF3vfP3YTM/v-deo.html
Hi Reza, excellent video!
It addressed many questions I had, but something is missing for me.
Your example works well "Rich Text", but not "Enhanced Rich Text".
I have a SharePoint where my users added over months lots of formatted tables. I customized the Form in PowerApps to add some additional features, controls, messages - looked really cool, but here is the problem:
The existing Enhanced Rich text are displayed alright in the HTML Text control, BUT if I use the Rich Text Editor (which sucks BTW), all previous fancy formatting is lost.
My users are asking me to roll back to the previous standard SharePoint experience - less fancy, but they can use an editor that gives full formatting (including Ctrl-C/V for tables)
Any Idea on how to implement full enhanced in PowerApps?
I did notice that issue as well with enhanced rich text. I will have to do some investigation on this one.
I will recommend you check on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Reza, is it ok to have the SP column with Append On? Mine is. Also, after 3 versions, the app removes all version history. Any suggestions?
Yes, you can have that. But Power Apps won’t show that information.
You can define how many versions an item can hold.
There is also an admin level setting for it. May be your admin has defined 3.
@@RezaDorrani what do you mean Power Apps won't show that information if I leave SP field with Append on?
Also, the
@@RezaDorrani what is the admin level setting? I checked the list setting, version history listed with 50 items. Is that what you meant?
@@lpdowdell Power Apps only shows the latest version. Append on is a SharePoint list feature. This video does not work on that feature but gives a workaround way to achieve something similar.
@@lpdowdell SharePoint Administration for your tenant. That is different.
I am having intermittent issues with the append comments field. In some of the list items I have, it saves the comments however in others, it does not. Can you help with this?
I have not come across the mentioned issue and hence not sure what the cause could be.
I recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
I need to append the new comment to the bottom . in this method it will add to the top. any option ? Thanks
I did this video 2 years ago. I believe all you would need to do is tweak the logic in the code to first append the historical data and then add the new comment at the end. It should be straight forward.