Тёмный

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

Shane Young
Подписаться 163 тыс.
Просмотров 39 тыс.
50% 1

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.PowerApps911.com

Наука

Опубликовано:

 

21 июл 2021

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 84   
3 года назад
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:)
@ShanesCows
@ShanesCows 3 года назад
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. 🐶
@theSawDawg14
@theSawDawg14 3 года назад
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!
@ShanesCows
@ShanesCows 3 года назад
Thanks and good job on your app b🐶
@joanconnelly9547
@joanconnelly9547 Год назад
I was very happy that I found this video Shane, it was just what I needed to add notes. thank you so much!!
@ShanesCows
@ShanesCows Год назад
Happy to help. Have a great day. 🐶
@Queesinbean
@Queesinbean 2 года назад
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 "
@ShanesCows
@ShanesCows 2 года назад
Thanks for sharing Logan.
@Queesinbean
@Queesinbean 2 года назад
@@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!)
@txaussteve
@txaussteve 2 года назад
This is awesome. Thank you. Wanted to ask if there is a way to sort by most recent on top?
@geoffplaylist
@geoffplaylist 2 года назад
Thanks Logan!
@geoffplaylist
@geoffplaylist 2 года назад
@@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,"
@akshaynm
@akshaynm 9 месяцев назад
Fantastic Tutorial Shane as always... !! Many thanks 🙏🏻🙂
@ShanesCows
@ShanesCows 9 месяцев назад
My pleasure!
@futuresick100
@futuresick100 2 года назад
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?
@RPG_ash
@RPG_ash 3 года назад
Nice one Shane, you're a good lad. Thanks 👍🏻
@ShanesCows
@ShanesCows 3 года назад
Thanks. 😎 Lots of little fun nuggets in that one for sure!
@iyengar007
@iyengar007 3 года назад
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?
@imanuelagard9214
@imanuelagard9214 2 года назад
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?
@misganawkibret603
@misganawkibret603 11 месяцев назад
This is what I was looking for. Thank you!
@ShanesCows
@ShanesCows 11 месяцев назад
Glad I could help!
@misganawkibret603
@misganawkibret603 10 месяцев назад
If I want to delete comments, how can I delete selected comments? Thank you!
@petereriksson6859
@petereriksson6859 3 года назад
Very good video again Shane :)
@jamiethompson9419
@jamiethompson9419 Год назад
You are my PowerApps hero Shane!
@ShanesCows
@ShanesCows Год назад
Thanks Jamie! 🤩
@JenMayB
@JenMayB Год назад
This is awesome. Thank you as always.
@ShanesCows
@ShanesCows Год назад
You are welcome Jen. Have a great day!
@jimwaldron3858
@jimwaldron3858 2 года назад
Hi shane any chance yo can show how you created the notes gallery from scratch
@ianreilly4763
@ianreilly4763 3 года назад
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.
@ShanesCows
@ShanesCows 3 года назад
Glad you got it working Ian. :)
@hibahaider7607
@hibahaider7607 2 года назад
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! :)
@aliendb
@aliendb 3 года назад
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!!!
@candacelightfoot3684
@candacelightfoot3684 Год назад
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!
@AlmostRight
@AlmostRight 3 года назад
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)?
@ShanesCows
@ShanesCows 3 года назад
Use Patch. 😎 But no I have never done a video where I straight up explain the why. I need to. Soon
@bobthewobbly6516
@bobthewobbly6516 2 года назад
@@ShanesCows I was just going to ask the same question! Did you ever do this vid?
@arvindeleon4527
@arvindeleon4527 2 года назад
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?
@bingobangobt
@bingobangobt Год назад
you figure this out?
@minstreltokunbo
@minstreltokunbo 2 года назад
Thank you. Can you use A from to append?
@jeffmelick3987
@jeffmelick3987 2 года назад
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?
@adamwheeler1702
@adamwheeler1702 3 года назад
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)
@ShanesCows
@ShanesCows 3 года назад
I haven't messed with it yet Adam but if I do you can be sure a video would follow.
@fathimaasmitha9768
@fathimaasmitha9768 2 года назад
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.
@ShanesCows
@ShanesCows 2 года назад
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.
@fathimaasmitha9768
@fathimaasmitha9768 2 года назад
@@ShanesCows Thanks Shane 🤟🏼
@user-wl8ov8zj8o
@user-wl8ov8zj8o 4 месяца назад
you and your channle are the best :D
@ShanesCows
@ShanesCows 4 месяца назад
Thank you so much 😀
@alexandrkim173
@alexandrkim173 Год назад
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?
@gerfer6261
@gerfer6261 3 года назад
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 👍👍👍
@ShanesCows
@ShanesCows 3 года назад
Maybe split out the entries and count them? You can also filter out any black rows so you only count rows with info.
@HorvathZoltan12358
@HorvathZoltan12358 2 года назад
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?
@jl1399
@jl1399 Год назад
Do you have a video of how to do something similar with a sharepoint integrated form?
@MuhammadAdnan2.0
@MuhammadAdnan2.0 3 года назад
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
@ShanesCows
@ShanesCows 3 года назад
Reference the control for the Default of the other control. Or use the LookUp function to get the value from the data source.
@MuhammadAdnan2.0
@MuhammadAdnan2.0 3 года назад
@@ShanesCows pls vdo on it. ?
@loganmikesell1806
@loganmikesell1806 2 года назад
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!
@loganmikesell1806
@loganmikesell1806 2 года назад
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!
@radiosonicfan1726
@radiosonicfan1726 Год назад
Very Cool. You should sort your ongoing log gallery by most recent submission/update is at top versus having to scroll down.
@ShanesCows
@ShanesCows Год назад
That's a great idea!
@rachelsweetman7066
@rachelsweetman7066 Год назад
@@ShanesCows How do you do this?
@gannfarmraised
@gannfarmraised 6 месяцев назад
I need a comment section on my power app, but I can't do code like you're mentioning in this video.
@sofiarubio2394
@sofiarubio2394 4 месяца назад
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
@ShanesCows
@ShanesCows 4 месяца назад
"My text" & Char(13) & Char(13) & Char(13) & "Should have 2 blank lines"
@sonuaryan5813
@sonuaryan5813 Год назад
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 ?
@ShanesCows
@ShanesCows Год назад
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.
@rachelsweetman7066
@rachelsweetman7066 Год назад
@@ShanesCows What do you mean then the old date? Can you show the code in here based on the video example?
@jonmarkwright
@jonmarkwright Год назад
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?
@ShanesCows
@ShanesCows Год назад
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.
@jonmarkwright
@jonmarkwright Год назад
​@@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.
@jurgenguns1925
@jurgenguns1925 10 месяцев назад
This is really nice video, but what about when creating new Item. When adding text it wont add User FullName, date , ...
@ShanesCows
@ShanesCows 10 месяцев назад
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.
@jurgenguns1925
@jurgenguns1925 10 месяцев назад
@@ShanesCows when creating new record and in the same screen adding notes, it’s not showing user and date. Not sure why?
@NinjaMonkeyPrime
@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.
@ShanesCows
@ShanesCows Год назад
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)
@NinjaMonkeyPrime
@NinjaMonkeyPrime Год назад
@@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.
@Justinline
@Justinline Год назад
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?
@Justinline
@Justinline Год назад
I'm using the Patch version.
@fuertesbs
@fuertesbs 2 года назад
This app is in your website?
@ShanesCows
@ShanesCows 2 года назад
Yes, part of training.powerapps911.com/courses/video-library subscription. :)
Далее
PowerApps Save Data - Patch, Collect, and ForAll
25:52
Просмотров 243 тыс.
Wait for it 😇
00:45
Просмотров 9 млн
PowerApps Patch Function
26:45
Просмотров 212 тыс.
Create your OWN Appending Comments in PowerApps
21:12
Power Automate: How to populate a Word Template 📃
24:10
PowerApps SharePoint LookUp Column
24:36
Просмотров 173 тыс.
Power Apps: Top 3 Uses for the HTML Control
14:46
Просмотров 57 тыс.
$1 vs $100,000 Slow Motion Camera!
0:44
Просмотров 25 млн
Телефон-електрошокер
0:43
Просмотров 1,3 млн