Create your OWN Appending Comments in PowerApps

[@geralddahl9159]

Helpful steps executed efficiently in Power Apps AND thanks also for showing at the start some SharePoint configuration steps to achieve similar steps quickly in case one doesn’t require the enhanced features afforded by Power Apps. Happy New Year!

[@andrewhess123]

Thanks Gerald, you too! Happy New Year, thanks for the continuous support!

[@MichaelDeBlasis1369]

This is one of My fav Power Aps use case videos because this idea has quite a few potential use cases. I just added a notes column to my main list rather than make it separate. That way users don't have to associate via a look up column. But I keep coming back to this video for more ideas. Def nice work Andrew.

[@andrewhess123]

Awesome PCMD, I feel like thats the purpose of the channel not to tell you what exactly to do, but to inspire you to get more ideas! Thanks much!

[@MichaelDeBlasis1369]

​@@andrewhess123 I'd love to see ideas on maximizing space on screens. I asked CHatGPT and it lead me to an idea about setting certain items visible based on a toggle switch. So I literally was able to double my space by combining 2 screens. Each had a form on it. I set a dual gallery screen to show each form when the gallery is selected. Genius! You could title the video, double the screen space on almost any app. ;)

[@andrewhess123]

@@MichaelDeBlasis1369 That's a good idea, one day I'm going to have to demo some of the apps I made. I will need permission though to show any info that may not be available for the public. Cus I have done the same having 2 screens on 1 form 😀 Thanks for the idea though, love the title!

[@MichaelDeBlasis1369]

@@andrewhess123 I'd love to see them if possible. Make it happen. lol

[@colin7406]

I love that you show the goal at the start, thank you

[@andrewhess123]

Yeah, I need to do that on every video! Thanks Colin!

[@sheiep1]

I love this. I have a different app where the SharePoint comments field has 'append changes to existing text' and it works very well to add new comments, but in order to see all the notes in the Power App I had to use Flow to grab all the version history of the notes field and display separately, which takes much longer to display. This method simplifies it by not appending, but rather grabbing the existing text and adding on to it in a non-versioned way.

[@andrewhess123]

Thanks sheip! Glad it's working well for you!

[@RyanSmith-mh1lj]

Hi Andrew, I am having issue @19:33 when you add/edit comments, patch function doesn't work, does not add comments, I have replicated few times, even I have followed through your steps same way you have done; but no result, any idea, why patch button is not working? Thanks

[@andrewhess123]

Hi Ryan, what does the error message say? I could make another video about this topic, I guess. I was thinking of what to do for tomorrow.

[@RyanSmith-mh1lj]

@@andrewhess123 , there is no error, when I click "Patch", button does not do anything, its like button is not working, I appreciate your fast reply, thanks! I do appreciate if you make another video, that be great!! Thanks again. Your videos are very helpful and to the point.

[@andrewhess123]

Alright my newest video explains again: kzbin.info/www/bejne/qoSadnyfodyfbMk@@RyanSmith-mh1lj

[@catherinemacale4134]

This is really helpful. Thank you for this :). Subscribed!!!

[@andrewhess123]

Thanks so much Catherine, have a wonderful day!

[@ajaychoudhary5596]

Awesome 👍... thanks for sharing again a great video!

[@andrewhess123]

Thanks for watching ajay!!

[@emersonnatividad5948]

Dear Andrew, your video is really amazing. I have 1 question when I'm hitting the patch button, it's updating on my sharepoint list but my HTML text is not. can you help me this? thank you

[@andrewhess123]

Hi Emerson, I'd need to see your Patch Statement. So are you patching your HtmlText1.HtmlText? The formulas are in the description of the video too. If that helps?

[@emersonnatividad5948]

@@andrewhess123 Hi Andrew, thanks for your response. Now, It's updating but delayed, i need to go back or navigate other screen and come back to comment screen then worked. Maybe you can help me why causing of the delay? Thank you

[@nichalmaharaj8756]

Thank you, Excellent video

[@andrewhess123]

Thanks Nichal!

[@Rich-hm9ux]

This has definitely improved my comments section! One thing I am struggling with is I am using a flexible height gallery so you can show multiple lines of text, but some of the items are overlapping each other. Any ideas how to fix? The gallery is showing an HTML label of that item's comment. So some times it is just one line and other times it is several lines.

[@roystaggs2965]

Awesome. The built-in feature (first 3 minutes of video) will work for comments with versioning for me, but on my side the TheComments column in List is blank after adding comments. If I Append, it shows a link in the column which works while in SharePoint, but I need to export those last comments to Excel for a report. The Appended option exports html language. The un-appended option is blank. Any comments?

[@andrewhess123]

Hi Roy, sorry for the late reply, just seeing this. So for excel.. with SharePoint, normally I don't export I create a connection instead. That way you can use Power Query to form your data. There's many questions here and not sure I know how to answer through text without actually seeing the issue. Why is your TheComments blank? Where is it blank in SharePoint? So at @4:15 I explain you need to do like X = X + Y, you have to take the old comments and then add the new comments to itself.

[@melfleming6675]

Helpful

[@andrewhess123]

Awesome Mel! Glad it was helpful

[@samlorro3104]

Hi Andrew! Everything works great, except when I look at my sharepoint list comments column, the "" and other html codes show up. Is there a way around that?

[@andrewhess123]

Does your sharepoint column multi line text field have enhanced rich text on?

[@bharanidharanboss]

Is there a way to edit existing comments that have been added already in the SharePoint list. The video is about creating new and adding comments to existing items.

[@andrewhess123]

Hi Bharani, Using the Patch Statement we write a formula, if "varNewForm" then on the other side of the statement is the Else clause, so if it is not New. Then you would edit the existing item. Like @18:51

[@jl1399]

This is making a new entry into SharePoint per entry aka a new item?

[@andrewhess123]

no this is using a multi-line text field and writing overtop of it, and would change the version history of the row

[@jl1399]

@@andrewhess123 ok i got confused at 1326 in the video in the galley it is showing that each new title is a separate entry. So effectively you doing both. New Titles are separate entries while the Comments are all on the same list item. Could you also have the Gallery itself show the separate entries besides putting it in a single line of text?

[@andrewhess123]

@@jl1399 Yes, The titles are new lines, the comments are not. The reason to do this is delegation issues if you use SharePoint as a datasource. If you want the gallery to show every single comment as a separate entry, most likely you will need to go to Dataverse or some other datasource like SQL. Unless you do some other workaround to deal with delegation.

[@jl1399]

@@andrewhess123 Im thinking to have it patch to a separate list and use a master id, then get the data back from the history list and filter on that master id with the gallery

[@courtneyhamilton51]

Hi Andrew, any tips on how i could get each new comment to display in a gallery?

[@andrewhess123]

Hi Courtney, yes this is totally possible. Would probably take a new video to explain, and I think this is actually the better way to do it.

[@andrewhess123]

Hi Courtney in my newest video, in the first option, i do just that: kzbin.info/www/bejne/qoSadnyfodyfbMk

[@DeepakSingh-jm4oh]

Realy helpful

[@andrewhess123]

Thank you Deepak!

[@mohamedamine7839]

Thx man !

[@andrewhess123]

Thank you Mohamed!!

[@mony451]

Hello I'm doing something similar and I would like to know how I should proceed to put a people picker properly ? So far I can selecr a person once and put a comment but I can put another comment for this selected person if she already exist in the sharepoint list. What am I missing ? Thank you

[@ElkeB83]

Is there a solution to tag a group or shared mailbox in the comments in SharePoint?

[@andrewhess123]

Hi Elke, If you are talking about that out of the box comments section in SharePoint that is new-ish. I don't think there is an easy way to edit that yet. Maybe you could use Power Apps or Automate to tag a group/team in MS Teams, and then send a link to the line item.

[@ElkeB83]

@@andrewhess123 thnx for your reply! Would love to do that but how? Maybe an idea for a new video tutorial? ☺

[@andrewhess123]

Sounds like a good idea, next week for me is Labor day, I will not have a video next Monday, so it may be some time, but I will write it down. 😀@@ElkeB83

[@trishashepley3349]

Can this be done using a Dataverse table?

[@andrewhess123]

Yes, I would think this would be just fine with Dataverse too.

[@trishashepley3349]

Do you have any suggestions or thoughts why it is not updating it deleted everything other than last added.

[@andrewhess123]

My guess is that x = x + 1 idea. Make sure when you update you add in the previous input? And if that isn't working set your previous input as a variable, then add the variable to the current input.@@trishashepley3349

[@MichaelDeBlasis1369]

Love you… Andrew. Lmao jk. But ty!!

[@andrewhess123]

Woooo Thanks mdizzle PCMD!

[@MichaelDeBlasis1369]

@@andrewhess123I'm trying to link the budgets list to a lookup for my main list client name. So that when adding a budget the user can link it to an existing client. However when I try and link the drop down to the lookup column it states the column doesn't exit. I've refreshed the datasource and still not seeing it. Any ideas?

[@MichaelDeBlasis1369]

Its a drop down. Strange thing is it can see other columns in the list. Just not the lookup column. I'm stumped.

[@MichaelDeBlasis1369]

NM I got it. ; )

[@fountainabani6326]

This is helpful. I tried it on my app and the comment is patched but I have had two challenges: first, the HtmlText was not displaying anything and second, the new input kept overriding the exiting inputs. Can you help. This is my Syntax Patch( HelpDesk, SelectedTicket, { Comments: Now() & "-" & User().FullName & RichTextEditor4.HtmlText & HtmlText2.HtmlText & Reset(RichTextEditor4) } )

[@andrewhess123]

Hi Fountain, I will have a new video on this topic tomorrow. Hopefully this helps!

[@andrewhess123]

Hi Fountain, My newest video goes over the topic again: kzbin.info/www/bejne/qoSadnyfodyfbMk