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
4 ай бұрын
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
4 ай бұрын
@@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
4 ай бұрын
@@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
4 ай бұрын
@@andrewhess123 I'd love to see them if possible. Make it happen. lol
@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!
@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!
@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!
@ajaychoudhary5596
Жыл бұрын
Awesome 👍... thanks for sharing again a great video!
@andrewhess123
Жыл бұрын
Thanks for watching ajay!!
@catherinemacale4134
Жыл бұрын
This is really helpful. Thank you for this :). Subscribed!!!
@andrewhess123
Жыл бұрын
Thanks so much Catherine, have a wonderful day!
@nichalmaharaj8756
Жыл бұрын
Thank you, Excellent video
@andrewhess123
Жыл бұрын
Thanks Nichal!
@melfleming6675
7 ай бұрын
Helpful
@andrewhess123
7 ай бұрын
Awesome Mel! Glad it was helpful
@AprendiCompartilhei
6 ай бұрын
Tks
@andrewhess123
6 ай бұрын
Thanks for watching!
@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
@samlorro3104
6 ай бұрын
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
6 ай бұрын
Does your sharepoint column multi line text field have enhanced rich text on?
@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.
@mohamedamine7839
Жыл бұрын
Thx man !
@andrewhess123
Жыл бұрын
Thank you Mohamed!!
@DeepakSingh-jm4oh
Жыл бұрын
Realy helpful
@andrewhess123
Жыл бұрын
Thank you Deepak!
@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
@mony451
6 ай бұрын
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
@RyanSmith-mh1lj
9 ай бұрын
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
9 ай бұрын
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
9 ай бұрын
@@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
9 ай бұрын
Alright my newest video explains again: kzitem.info/news/bejne/1Yltq32fpamdaZw@@RyanSmith-mh1lj
@MichaelDeBlasis1369
5 ай бұрын
Love you… Andrew. Lmao jk. But ty!!
@andrewhess123
5 ай бұрын
Woooo Thanks mdizzle PCMD!
@MichaelDeBlasis1369
4 ай бұрын
@@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
4 ай бұрын
Its a drop down. Strange thing is it can see other columns in the list. Just not the lookup column. I'm stumped.
@MichaelDeBlasis1369
4 ай бұрын
NM I got it. ; )
@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
@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
9 ай бұрын
Hi Courtney in my newest video, in the first option, i do just that: kzitem.info/news/bejne/1Yltq32fpamdaZw
@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
@trishashepley3349
7 ай бұрын
Can this be done using a Dataverse table?
@andrewhess123
7 ай бұрын
Yes, I would think this would be just fine with Dataverse too.
@trishashepley3349
7 ай бұрын
Do you have any suggestions or thoughts why it is not updating it deleted everything other than last added.
@andrewhess123
7 ай бұрын
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
@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
9 ай бұрын
Hi Fountain, I will have a new video on this topic tomorrow. Hopefully this helps!
@andrewhess123
9 ай бұрын
Hi Fountain, My newest video goes over the topic again: kzitem.info/news/bejne/1Yltq32fpamdaZw
Пікірлер: 64