PowerApps Append Text - Using forms or Patch create update only fields
ฝัง
- เผยแพร่เมื่อ 30 ก.ย. 2024
- 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?).
Power Apps Consulting and training at www.PowerApps9...
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 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 "
Thanks for sharing Logan.
@@ShanesCows welcome! Your videos have been a massive help to me so wanted to give something back, even if it is very basic (like me!)
This is awesome. Thank you. Wanted to ask if there is a way to sort by most recent on top?
Thanks Logan!
@@txaussteve I had the same question / issue and was able to get the most recent comment on the top with the following formula for Items on the Notes Gallery...
Sort(Filter( Split(varRecord.Comments,"***"),!IsBlank(Result), !StartsWith(Result,"
Hi shane any chance yo can show how you created the notes gallery from scratch
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?
you figure this out?
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 ?
I am not sure I follow. Maybe see if one of the date time functions help you out? th-cam.com/video/EbYMN4ouOvQ/w-d-xo.html
Hi Shane, I've been watching your videos for a while now. I always learn bigger or smaller things from each one. This time the Char(13) tip blew my mind, I usually went for a Concatenate function on the update property, I love the simplicity of this option.....and awesome tip also the triple star separated split as well. Thanks you! Really appreciate the effort you put in:)
Great to hear! I really appreciate your comment. Sometimes I have doubts all of the crazy stuff I show helps. Thanks for the detailed feedback. 🐶
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
"My text" & Char(13) & Char(13) & Char(13) & "Should have 2 blank lines"
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 ;)
Maybe update the Patch to add a line that is something like ***** then you could split the text on that ***** which would produce a table. Then you could get the first or last item. First(Split(yourtext, "*****")).Value
Something like that :)
@@ShanesCows Looks good - I will give that a go once I've implemented the rest. Have a great weekend! :)
This is really nice video, but what about when creating new Item. When adding text it wont add User FullName, date , ...
Sorry I don't follow your issue. You can append to your Patch Username + TextInput etc but has been a long time since I made this video so I might be mis remembering.
@@ShanesCows when creating new record and in the same screen adding notes, it’s not showing user and date. Not sure why?
Hi Shane can I ask for a little help I want to append a name to a running list or text field. Non of which is connected to a sharepoint. I want to simply click a button which puts the name into the text box over and over however many times I press it. Can you help?
Set the Default of the TextInput to be a variable. Have the Variable appende user name every time you click a button. Set(varNameField, varNameField & User().FullName) or something close to that.
@@ShanesCows that is brilliant. I have litterally been looking at this for days. I played around with it to get whatbi wanted and got it working.
The code I used on the button was
Set(VarName1, VarName1 & "Noah, ") to repeat Noah, on ever press.
I have one more question can you set a button reverse this I.e. take the last entry off or one noah off? Many thanks.
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.
The Char(13) is what is creating your blank line. You will need to have an If that says if the field is blank don't do the Char(13)
@@ShanesCows The problem for my project was the underlying text field had the setting "append text". This caused all kind of bugs. Once I changed that setting it all worked.
I need a comment section on my power app, but I can't do code like you're mentioning in this video.
you and your channle are the best :D
Thank you so much 😀
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!
Thanks and good job on your app b🐶
Do you have a video of how to do something similar with a sharepoint integrated form?
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 👍👍👍
Maybe split out the entries and count them? You can also filter out any black rows so you only count rows with info.
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.
Glad you got it working Ian. :)
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)
I haven't messed with it yet Adam but if I do you can be sure a video would follow.
Fantastic Tutorial Shane as always... !! Many thanks 🙏🏻🙂
My pleasure!
Hi Shane, I have 2 questions basically on notes gallery:
1. How can we delete comments as selected ?
2. Is that possible to show latest comments on the top as descending order ? Just like tweets or FB post ?
If you want to delete comments keep in the a separate table as child
Items.
Patch the new comment then the old data and the latest would always be on top.
@@ShanesCows What do you mean then the old date? Can you show the code in here based on the video example?
I was very happy that I found this video Shane, it was just what I needed to add notes. thank you so much!!
Happy to help. Have a great day. 🐶
Hello . . . For some reason the first line of the gallery showing the notes posted is always blank. I'll write a note, save it, and then it shows a blank line then the note. After that it updates line by line. Only the first entry is blank. I'm not sure what I'm doing wrong. Any insight is appreciated.
Also, the gallery showing the notes doesn't refresh after I submit it. I have to refresh my browser to see it. I'm not sure if that's because of how my company setup the servers or what. Of course the Refresh(data-source) doesn't work either to get the data updated. Is there anything else I can try to make that update when an item is submitted?
I'm using the Patch version.
Well explained.... I have a question ,
how to get second list columns value in first list columns like I want to get date column value from second list to first list date column value in power apps I used filters lookup but nothing was helpful can u pls solve this on next vdo sir pls.... Thnx I'm not using galleries only list forms customized
Reference the control for the Default of the other control. Or use the LookUp function to get the value from the data source.
@@ShanesCows pls vdo on it. ?
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)?
Use Patch. 😎 But no I have never done a video where I straight up explain the why. I need to. Soon
@@ShanesCows I was just going to ask the same question! Did you ever do this vid?
Hi Shane, I have a Problem. What if I have records (files) and this records are commented by 3 approvers (John, Jack and Nancy). Records(files) has to contain approvers comments, not the approvers are in the records as You have here (Employees). I do not use a gallery of records, I can use a gallery of John, Jack and Nancy. How can I solve this?
Hi Shane, I consider you as a great tutor. Clear and neat, I have a doubt, Is it possible to remove one particular note from the list of Notes added? I tried Remove function, but its not working.
Yes, it should be. You would have to remove the note and then write back all of the notes. I see how that could be tricky. I will make a note and see if at some point I can cover it. In the meantime just focus on getting to that one record so you can get rid of it. You will need to save your Split output into a collection.
@@ShanesCows Thanks Shane 🤟🏼
Nice one Shane, you're a good lad. Thanks 👍🏻
Thanks. 😎 Lots of little fun nuggets in that one for sure!
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!
Hi Shane, I've created a separate screen with comments for specific person. But when I add another record to the chat htmltext doesn't show the last record It shows an old records, so I need to back to a screen with gallery, choose again required record again and then a new record is shown. Is it possible to update the htmltext automatically?
Hi Shane, I have a question. I need to show "form name" as well in a new column when the form is submitted. For e.g. If I submit an entry there should be a column that says it's coming from "Form 7". That Form 7 is not a field in the form but an additional column in SharePoint that is automatically populated on form submission. Could you please help me with this? Thanks in advance! :)
Shane, as always great video. Question. Did you meddle with trying to delete one of the appended lines. I followed some of your other tips, added a label to see if my delete was picking the "selected item", which it did, but using REMOVE was just not budging to pull out a comment one might not want. I followed one of your other videos for deleting. I tried building the field as a new collection, then tried removing the selected item from that collection... to use that and update the final table. No joy. Sigh. Learning a new trick opens pandoras box of 10 addition fixes:) thanks for all your work!!!
HI Shane. Many thanks for the fantastic tutorials. When I hit the submit button to add a note, it updates and displays in the SharePoint list, but not in Power Apps unless I save, close, and re-open the app in Power Apps. Any thoughts about what I'm doing wrong?
You are my PowerApps hero Shane!
Thanks Jamie! 🤩
This is awesome. Thank you as always.
You are welcome Jen. Have a great day!
Can I use a dataverse table instead of sharepoint? I was able to get everything to work except the page break doesn't seem to work. Any thoughts?
Hey Shane my Guru, Once again a nice tutorial. Thumbs up for that.
Just a small ask. I have 4 buttons; based on the button click; could it be possible to capture button color or button title or anything to indicate which button i clicked in text inout or pen input pls?
Hi Shane, following your videos for a long time now. I am having a problem with my notes gallery displaying the notes I have and also adding a new one following your examples. Do I need to declare in the items what sharepoint library I am reading the notes from?
This app is in your website?
Yes, part of training.powerapps911.com/courses/video-library subscription. :)
This is what I was looking for. Thank you!
Glad I could help!
If I want to delete comments, how can I delete selected comments? Thank you!
Thank you. Can you use A from to append?
Love the idea of using varRecord instead of Gallery1.Selected! However i'm having trouble accomplishing what I need to do. Basically I have a CDS sheet which stores a value in a cell (a countdown feature), when i press a button, it patches that cell value to be (value - 1). If I select the gallery item, and hit the button it works great. If I select the Item and hit the button twice, it does not work! I have to select item, select button, select item, select button. Can anyone help?? Thanks!
Update: I used TemplateFill to show ThisItem is selected, then i clear it when the button is pressed, to show the user it is no longer pressed - forcing them to select it again. I think this will work for me! Shane is awesome, best PowerApps tutor out there!
Very good video again Shane :)
Very Cool. You should sort your ongoing log gallery by most recent submission/update is at top versus having to scroll down.
That's a great idea!
@@ShanesCows How do you do this?