Hi Andrew! Thank you for the video! I have a question. I did something similar to option 2 you show. I tried to add Reset(datacard2) for my "On select" button that submits the form but I get an error message. This is the code used for OnSelect submission button: SubmitForm(Form3); Patch( 'Inventory Lists', RecordsGallery3.Selected, { RollingComments: Now() & ": " & DataCardValue2.Text & "" & RecordsGallery3.Selected.RollingComments } ); Reset(DataCardValue2) This is the message I get: The reset function can only be used with a resettable control. Controls within a Form or Gallery control can only be reset from within the same form or gallery template. I tried searching and trying other things but nothing worked so far... do you have any ideas. Thank you!
Hi Olivia! Have you tried the ResetForm function? Also.. "You cannot reset controls that are within a Gallery or Edit form control from outside those controls. You can reset controls from formulas on controls within the same gallery or form. You can also reset all the controls within a form with the ResetForm function." I think craig white gives some great tips here in this article... may be worth checking out? platformsofpower.net/resetting-controls-in-power-apps/#:~:text=If%20you%20want%20to%20use,covered%20later%20in%20the%20article.
Great video. I had to make slight changes, i think the PowerApp language changed a bit. Specifically the ".Value" on the "TextInput" would not work, I was able to use ".Text" however. Full code snippet: "Patch( ShortageComments, Gallery5.Selected, { PartShort: TextInput3.Text, CommentShortage: "" & User().FullName & " (" & Now() & "): " & TextInput4.Text & "" & Gallery5.Selected.CommentShortage } ); Reset(TextInput4)"
Thanks for updating. Yes you're right Microsoft makes these changes a lot, especially the difference when using classic and modern. Thanks for sharing!
Andrew, this is great! I'm trying to send an email notification with the comments and a deep link to the comment screen where the record that the comments were inserted on is selected so they can see those comments and add to the conversation. I have successfully created the link to the screen, but am stuck in passing the selected record so it comes up as selected in the gallery when they click the link. Any ideas or is this even possible?
Hi Andrew, I appreciate that you have made this video. This video is awesome!! ⭐⭐⭐⭐⭐You've given many different ideas to implement, Thank you so much 👍
Thank you for your video with comment history appending with a gallery. Your video been very helpful. Please could you add a video (with comment history not associated with a gallery) for your "first" comment history entry created on a "new form" with the same username and time format as you did on the gallery linked videos. The new form entry would start the format and show up in SharePoint List correctly. If you have one, could you post a link. thank you.
Thanks Andrew. Is there any kind of property or style attribute that needs to be applied to the Comments input field to enable Power Apps to recognize when a user inserts a hard return in their comment? I have got rich text formatting turned on in my connected SharePoint field. Great walkthrough of this topic though! Thank you
@@andrewhess123 I would use if I were hard coding multi-line text myself. I'm referring here to when the USER is inputting a comment that comprises multiple paragraphs - they would be working in the multi-line input field I've provided, and they would naturally hit the ENTER key if they wanted to create a new paragraph. However this is not translating across into what gets captured back into my SharePoint list, i.e. When their multi-paragraph comment saves to the rolling comments list, it's all just one paragraph.
@@wendymeyer1250 Hi Wendy! That's a really good question and I'm not sure of the answer to that yet. The issue must lie in the source. Where the comment is written, where are they writing?... in a text input field or an html text? Some how you need SharePoint to know that there's a space and Power Apps needs to recognize that space or break first before sending it.
@@andrewhess123 Ah, OK yes, I understand the issue now. Anyhow, after trying to implement a very complicated solution using Power Automate, I managed to solve the problem myself my simply swapping out your Text input in Power Apps for a Rich Text Editor input and then I adjusted your Patch statement to refer to RichTextEditor.HtmlText instead of TextInputCanvas3.Value. So Users can now capture multiple paragraphs. I'm ecstatic!! 😄
Great video- using option 1 or 2, is there a way to notify a specific user(s) that comments were made by sending an email notification of new comments?
Usually best through TH-cam. I do have an email in my info, but right now I don't do any extra contract work or consulting. Just work for the government and then TH-cam every weekend 😅
Great video. Do you have any ideas of how we can notify a user when there is a new comment. Prefereably not a comment they have submitted. E.g communication between a user and an adminstrator
There's def a few different ways, if its through email or a teams message, or other ways. You could use Power Automate or even Power Apps functionality to just send an email Just need to decide what the trigger is and then send the notification.
Hi Andrew! Thank you for the video! I have a question. I did something similar to option 2 you show. I tried to add Reset(datacard2) for my "On select" button that submits the form but I get an error message. This is the code used for OnSelect submission button: SubmitForm(Form3);
Patch(
'Inventory Lists',
RecordsGallery3.Selected,
{
RollingComments: Now() & ": " & DataCardValue2.Text & "" & RecordsGallery3.Selected.RollingComments
}
);
Reset(DataCardValue2)
This is the message I get: The reset function can only be used with a resettable control. Controls within a Form or Gallery control can only be reset from within the same form or gallery template.
I tried searching and trying other things but nothing worked so far... do you have any ideas. Thank you!
Hi Olivia! Have you tried the ResetForm function? Also.. "You cannot reset controls that are within a Gallery or Edit form control from outside those controls. You can reset controls from formulas on controls within the same gallery or form. You can also reset all the controls within a form with the ResetForm function." I think craig white gives some great tips here in this article... may be worth checking out? platformsofpower.net/resetting-controls-in-power-apps/#:~:text=If%20you%20want%20to%20use,covered%20later%20in%20the%20article.
Great video. I had to make slight changes, i think the PowerApp language changed a bit. Specifically the ".Value" on the "TextInput" would not work, I was able to use ".Text" however. Full code snippet:
"Patch(
ShortageComments,
Gallery5.Selected,
{
PartShort: TextInput3.Text,
CommentShortage: "" & User().FullName & " (" & Now() & "): " & TextInput4.Text & "" & Gallery5.Selected.CommentShortage
}
);
Reset(TextInput4)"
Thanks for updating. Yes you're right Microsoft makes these changes a lot, especially the difference when using classic and modern.
Thanks for sharing!
Andrew, this is great! I'm trying to send an email notification with the comments and a deep link to the comment screen where the record that the comments were inserted on is selected so they can see those comments and add to the conversation. I have successfully created the link to the screen, but am stuck in passing the selected record so it comes up as selected in the gallery when they click the link. Any ideas or is this even possible?
Hi Melissa, that's a really good question, not sure about that one yet! Let me think about that one for a bit. I'll write it down.
That was super helpful and thank you for showing us different ways too!
Thank you for watching Lilly Xu!
Hi Andrew, I appreciate that you have made this video. This video is awesome!! ⭐⭐⭐⭐⭐You've given many different ideas to implement, Thank you so much 👍
Awesome Ryan, Glad to hear!
Thank you for your video with comment history appending with a gallery. Your video been very helpful. Please could you add a video (with comment history not associated with a gallery) for your "first" comment history entry created on a "new form" with the same username and time format as you did on the gallery linked videos. The new form entry would start the format and show up in SharePoint List correctly. If you have one, could you post a link. thank you.
Thanks Andrew. Is there any kind of property or style attribute that needs to be applied to the Comments input field to enable Power Apps to recognize when a user inserts a hard return in their comment? I have got rich text formatting turned on in my connected SharePoint field.
Great walkthrough of this topic though! Thank you
Hi Wendy, Thanks for your continuous support! 😀 I'm wondering if you mean the for break in HTML? Or maybe 2 line breaks with ?
@@andrewhess123 I would use if I were hard coding multi-line text myself. I'm referring here to when the USER is inputting a comment that comprises multiple paragraphs - they would be working in the multi-line input field I've provided, and they would naturally hit the ENTER key if they wanted to create a new paragraph. However this is not translating across into what gets captured back into my SharePoint list, i.e. When their multi-paragraph comment saves to the rolling comments list, it's all just one paragraph.
@@wendymeyer1250 Hi Wendy! That's a really good question and I'm not sure of the answer to that yet. The issue must lie in the source. Where the comment is written, where are they writing?... in a text input field or an html text? Some how you need SharePoint to know that there's a space and Power Apps needs to recognize that space or break first before sending it.
@@andrewhess123 Ah, OK yes, I understand the issue now. Anyhow, after trying to implement a very complicated solution using Power Automate, I managed to solve the problem myself my simply swapping out your Text input in Power Apps for a Rich Text Editor input and then I adjusted your Patch statement to refer to RichTextEditor.HtmlText instead of TextInputCanvas3.Value. So Users can now capture multiple paragraphs. I'm ecstatic!! 😄
Great video- using option 1 or 2, is there a way to notify a specific user(s) that comments were made by sending an email notification of new comments?
Hi Andrew, why is my html table only brining in the most recent comment and not all the historical like yours?
Andrew, how does someone send messages to you❓
Usually best through TH-cam. I do have an email in my info, but right now I don't do any extra contract work or consulting. Just work for the government and then TH-cam every weekend 😅
@@andrewhess123 All of my work I do is for big brother, I mean the Federal Government
But I don’t see your email…Maybe I’m cornfrused
ahess543work@hotmail.com@@jray1429
Great video. Do you have any ideas of how we can notify a user when there is a new comment. Prefereably not a comment they have submitted. E.g communication between a user and an adminstrator
There's def a few different ways, if its through email or a teams message, or other ways. You could use Power Automate or even Power Apps functionality to just send an email
Just need to decide what the trigger is and then send the notification.
Great video - thank you. I’m a massive fan of your previous rolling comments video too. Great stuff.
Thanks so much for watching and the support Simon!
What you could add is the user profile image in it
Good point, having that user profile image in the circle would be a great add.
I do like how you try to respond to folks…It’s definitely more personable
I know I appreciate it
Nice yeah, I try my hardest to respond here!@@jray1429
I like the new intro section!
Thanks jchen! Appreciate it, trying new things!