PowerApps Append Text - Using forms or Patch create update only fields

Do you want to keep up a running log of information. Have a field for notes or comments that is append only. Add some time stamps and user info? This video has a little bit of everything. It shows the concept with a form and then a different way with Patch. Oh, and as bonus we talk about SharePoint append only columns and I mess up (who doesn't love seeing that?).

[theSawDawg]

I literally just had to implement this style on my company's CRM app last week! Love the tip about the concatenated gallery to show the past notes, rather than having everything in a single html text. Great videos, keep it up!

[joanconnelly]

I was very happy that I found this video Shane, it was just what I needed to add notes. thank you so much!!

[akshaynm]

Fantastic Tutorial Shane as always... !! Many thanks 🙏🏻🙂

[Queesinbean]

I wanted to add this comment in case anyone used this video and had the same issue I did: whenever I'd append data to the notes record with patch, it would add a big HTML string in front of it that was something like <div right before the first delimiter. This would cause the first record to be blank (but not really, it's an HTML text box so it technically thinks there is data, but displays blank so Shane's "!IsBlank(Result)" doesn't catch it because it's not actually blank. To fix this I added an extra step on the filter to filter any entries that start with "<div" - that made the formula look like this (using Shane's variables instead):

Filter( Split( varRecord.Notes"***"), !IsBlank( Result), !StartsWith( Result, "<div"))

I hope this helps someone else out there that struggled like I did!

[misganawkibret]

This is what I was looking for. Thank you!

[jimwaldron]

Hi shane any chance yo can show how you created the notes gallery from scratch

[RPG_ash]

Nice one Shane, you're a good lad. Thanks 👍🏻

[arvindeleon]

Hi Shane, with the third option (Form with Append Only), what did you put in the OnSelect of the save button? Did you use patch or submitform?

[adamwheeler]

I would really love a video on the Document Automation Processor that MS built. I find it confusing and I think you could tear it apart and show us to actually use it (and maybe make some improvements)

[gannfarmraised]

I need a comment section on my power app, but I can't do code like you're mentioning in this video.

[sofiarubio]

hi Shane! is there any way that we can skip two lines to allow more space between the comments? I am using a form control and tries doing char(13) twice but its not allowing more space

[ianreilly]

Thanks Shane. I wish this available a month ago. I've been doing exactly that scenario but created a new list to hold the notes. Not sure why but HTML text wouldn't get submitted using submit form. Deleted list and created a new list and it works fine now.

[syedabidaliabdi]

Hi Shane, Good Day, I am facing problem in form Control Datetime Filed, once i select any time it gives some other time value how cam i handel it and if i want to change default time control to my tile control like 10:30 AM insted of militry time then how handel it also validate this ?

[AlmostRight]

Super helpful and timely for a current project - thanks! Question please - your comment at the beginning about 'some of you like forms' with a thumbs down. Is there an existing video that would explain the reasons not to use forms (and what to do instead)?

[gerfer]

I was begging for this last year. Problem I faced was getting a blank line between when appended
How can I count number of entries per record please?
This is something very useful, good on you 👍👍👍

[jurgenguns]

This is really nice video, but what about when creating new Item. When adding text it wont add User FullName, date, ...

[sudosaurus]

Hi Shane, hope you're well. This looks great btw! How would I get the latest comment and append only that one to a document generator I have in my app (using html text controls) - Just need to know how to get the last comment, I can sort the rest ;)

[jl]

Do you have a video of how to do something similar with a sharepoint integrated form?

[NinjaMonkeyPrime]

I tried the simple version at 17:47 but either I made a mistake or there's a glitch. If you update anything else on the form and do NOT enter a note/comment, the update step appends a blank line to the note/comment. For the life of me I can't figure out a way to avoid that.

[candacelightfoot]

Hi Shane, Great videos! Question --> Why is it that you don't like using Gallery.Selected in real solutions (6:35)? I'm interested in learning best practices. Thanks!