Just catching up on videos after my brief holiday and I surely wasn't disappointed. Great video and great concept. One of the great features about your videos is that, it shows me what's possible even though I may not have a use case for it as yet. It goes into the "Bank" nonetheless. Thanks for sharing and enjoyed it.
Game changer!!! I almost want to cancel my plans tonight and try this out instead! Jk! 🙃 Looking forward to opening the complete solution soon to understand the @mention version. Thank you Reza for all that you do for this community of Power Platform learners!
Thanks for the heads up Reza. I’ll try my best, and at least now I know it’s possible. This may end up being one of my three requests for training sessions after Power Automate!
Thank you so much for the super helpful video Reza. I can't wait to try implementing this. I also wanted to display this chat (following the same format) in an email whenever a user adds a new comment to the ticket. How can I display this field using a power automate flow? Thank you!
Another great video Reza. The @ mention is great but the email notification redirects people to the list instead of the app which isn’t ideal in our use case. We'll likely end up reproducing a similar experience by using another list to store our comments instead. We might even go nuts and attempt a reply button to keep them in threads 🎉
Another option would be to use the @mention logic in power apps but not actually post it as an @mention in comments. Rather send a custom notification from PAuto
AWESOME! Once I wanted to show Title and Comments columns in Power BI but the @mention is object instead of user name. No sure if anyone can extract Email or User Name from @mention.
Thanks! I have not tried with doc libs. I dont see the same comments feature there. There is Office comments within files in libraries. There could be an option to get that, but not something I have explored.
Hi Reza, thanks for this. I have built something based on the video but curious on how to filter the chat based on a date range, displaying the date is fine but would like the dynamically control the view of the comments,
@@RezaDorrani Thank you, but I don't see where you make the Issue Information Form, I need to make that before I can follow this, it's not working for me. The modern controls have a lot of great examples, but I don't see that one. Sorry.
@@georgeloughery8570 You wont see an exact replica of that form but I have done several videos where I have built the form and gallery on home screen. There are all placed in the modern controls playlist. I had a colleague use it a week ago.
I have a general question that's not directly related to this video. Whenever I create a new screen, I find myself constantly referring back to previous screens to match colors, sizes, and other control settings. Is there a way to centralize these layout elements so that any new controls I add automatically inherit the width, height, font, and other design properties, saving me from manually adjusting them each time?
With modern controls, the only option is modern themes which is limited. With classic controls, you can frame a pattern www.iammancat.dev/2022/01/power-apps-branding-template-v3/
@@benjietunchie I make videos when I receive multiple requests on a topic. Every 6 months I ask subscribers for topic suggestions on Community Tab of my channel. Most voted idea gets added to my backlog. Make sure to post this idea whenever I post the next topic suggestion post.
Hi Reza, brilliant video as always. Is it possible to display the message order from oldest to latest, as by default it shows from the most recent one down to the oldest one. Thank you
Great video! I have learned so much from your videos. I am having one issue on the OnVisible: Set(varComments, GetandPostComments.Run("Get",Table1.Selected.ID).response). What is Table1 referring to in your demo video? I am not able to get this to work on the Power App I created from a SharePoint list.
Hello Reza, awsome idea 💡just curious to know, we do have similar feature with MS List and even we can use Jira as well to keep track of issues, may I know the most benefit of this?
Great and well explained sir. I was wondering if it's possible to continue with a part 2 where you can show us how to add a counter for number of unread comments/ messages in the gallery like in whatsapp unread messages. Is that possible sir?
Hi Reza! Awesome work. thanks a lot. Just one question. You see a way how to make mentioning possible in the PowerApp directly? I am neither able to see mentioning in the app, nor I am able to mention somebody in the app.
I’ve been following you for a couple years and have a mate in Malawi also really loves your work and would benefit from lessons. I’ve been trying to assist him but I too am still learning. The exchange rate makes it very difficult from an affordability perspective. Is it possible to obtain a discount for interested parties in Malawi?
Thank you so much for supporting my work over the years. I truly appreciate it, and I’m glad to hear that your mate in Malawi enjoys the content too. Regarding the membership, the pricing is set uniformly across all members, as TH-cam doesn't offer an option for regional-based pricing at this time. I understand that this can be challenging due to the exchange rate, but I hope the content continues to bring value to you both. I tried to build this Q/A doc that would help address common questions on memberships thepoweraddicts-my.sharepoint.com/:w:/g/personal/rdorrani_thepoweraddicts_onmicrosoft_com/EbvjdBY80QRGkT6svJEmzZwBz64PNYQDRvKHm8eRHEYe6Q?rtime=GVrSLBDk3Eg
Looks good! Do you have a solution on how to build a fully functional @mention function in Power Apps? I have almost got it by showing a people picker when typing "@" character, but it's not fully functional like other chat apps. Then I used rich text control instead of textinput which means I had to workaround html also...
Is it possible to show a count of the number of comments? For example, I have an icon that opens the comments screen. I would like to display the number of comments next to that icon. Thank you.
Hi Reza, thanks 👍 yet another exciting tutorial. I was wondering if we can give option to delete comment, as in SharePoint we have delete as well as edit option for each comment. I have added a trash icon 'OnSelect': Set(varComments, flow.Run("Delete",Table1.Selected.ID).response), and in the flow i have added an Or condition branch to check if the input is equal to Delete then using the send an HTTP request method type 'DELETE' to delete the particular comment, but no luck. I keep getting error code 502, the type Microsoft.SharePoint.Comments.Comment EntitySet does not support HTTP DELETE method. One thing i noticed is once i use ThisItem.Value id in a text label property it gives me the exact "id" of the item as per the JSON structure in the flow. I am hoping that i am the right track to crack this, any guidance will be much appreciated.
When I check the flow results I keep getting error code 502, the type Microsoft.SharePoint.Comments.Comment EntitySet does not support HTTP DELETE method.
@@RezaDorraniFinally got the DELETE method to function perfectly. To delete a specific comment we need to provide a commentID input parameter type number(make it optional) in the api after Comments(commentID) similar to what we do to get ItemID. And to get commentID value associated with each comment dynamically I added a text label in the gallery with Text property set to: This item.Value.id. Where 'id' denotes the comment id which we can see in the output JSON. FInally I added a Trash icon in my gallery and set its 'OnSelect' property to: Set(varComments,Flowname.run("Delete",Table1.Selected.ID, {num_2:txtlabel.Text}). response). Similarly I added an edit icon to edit each comment using the PATCH method.But all thanks 🙏 to you for your detailed and simple explanation which pushes us to think out of the box.
So each time you open a item the flow needs to run to get the comments? If yes, is there anyway to load this comments without using a flow, less delay and less calls
Only way to call SharePoint rest api using standard connectors is via flow. You could also not call flow when item is viewed and have user click a button to load the comments on demand
Thanks! I make videos when I receive multiple requests on a topic. Every 6 months I ask subscribers for topic suggestions on Community Tab of my channel. Most voted topic ideas get added to my backlog. Make sure to suggest this idea whenever the next topic suggestion post is out.
I make videos when I receive multiple requests on a topic. Every 6 months I ask subscribers for topic suggestions on Community Tab of my channel. Most voted idea gets added to my backlog. Make sure to post this idea whenever I post the next topic suggestion post.
@@yijinlin6885 This doc has all the answers thepoweraddicts-my.sharepoint.com/:w:/g/personal/rdorrani_thepoweraddicts_onmicrosoft_com/EbvjdBY80QRGkT6svJEmzZwBz64PNYQDRvKHm8eRHEYe6Q?rtime=Cd5ITIbv3Eg
I have not experienced the mentioned issue, hence not sure whats the cause for your issue. You can try downloading the solution shown in video (members only - check video description for details)
@@RezaDorrani Nevermind, your videos before were cool no hidden steps nor payment required to have full scope. But yeah, Thanks for the foundation. I understand your way now on giving advice and even download is not free now. But still you did great to all this time.
@grapesfamily29 My response was relative to your comment which got deleted as my channel policy (auto setup) blocks or deletes posts with links. No one is forcing anyone to pay. It's a choice and not mandatory. It takes a lot of effort to package, document the installation steps for the solution and help support every question that comes my way. The video itself has been used by many to frame the solution without needing to download anything.
@@RezaDorrani Agree, though, its you who let us choose instead of for free. But hey, Not arguing its your way, so no biggie. Just giving my honest comment.
@5:23 . I guess I just don't trust the Microsoft Power Automate team (I think that's actually yours Reza) to support a "drop down list" properly. So Imma use text until a very unspecified future date where I trust that your team isn't going to mess up the interfaces (again).
@6:45 ...again.... Use _api/web/lists(guid'*guid_of_your_list_here*') instead of _api/web/lists/getbytitle. Naming of lists changes too often within SharePoint and the reference can break. Using the GUID ensures you can have an unbreakable link to the list. Don't get me wrong, this is good info to share, but I need my stuff to work reliably.
Because thats what the json returns. A lot more work is needed to get the details of the mentioned user. Video description has link to download entire solution (members only - check description for details)
@@RezaDorrani Any chance you could take us through @mention solution, I’ve downloaded your app but struggling to incorporate it in to my own existing app. Thanks in advance.
Brilliant! And excellently explained! Thanks so much, Reza!
Awesome! Very happy to hear the feedback.
What would we do in this world without Reza? That man is my god
Hey, thanks man! Im no God :)
Just catching up on videos after my brief holiday and I surely wasn't disappointed. Great video and great concept. One of the great features about your videos is that, it shows me what's possible even though I may not have a use case for it as yet. It goes into the "Bank" nonetheless. Thanks for sharing and enjoyed it.
Welcome back!
@@RezaDorrani Thanks Reza. 🤣
I love your excellent R and D. You help us see what is possible.
Thank You so much
Excellent Session Bro
Thanks for listening
Excellent video. Thank you Reza...!
My pleasure!
Thanks raza. I soent the day learning graph api from you. My search is out of control now!
You're the best bro
Thanks so much! I try my best to bring something new and unique each time.
v useful Reza, love the way you build on prior tutorial solutions, so its easier to digest. Thanks so much
Glad you like it!
Trying my best to keep tutorials crisp and to the point.
Awesome!!!, very well explained
Thank you for sharing your knowledge and experiences
Thanks!!
Thanks Reza really good functionallity.
Most welcome!
Game changer!!! I almost want to cancel my plans tonight and try this out instead! Jk! 🙃 Looking forward to opening the complete solution soon to understand the @mention version.
Thank you Reza for all that you do for this community of Power Platform learners!
You are most welcome!
Warning: The @mention version is complex. I wish it was easier.
Thanks for the heads up Reza. I’ll try my best, and at least now I know it’s possible.
This may end up being one of my three requests for training sessions after Power Automate!
@@muktirashmi9263 I have already shared a request form for feedback to gold members. Check community tab.
Awesome Sir Reza
Thanks
Cool! Great and useful explanation. Reza, do you have any solutions for making chat experience in model-driven app based on dataverse? Thank you!
Thanks!
I dont have any of model-driven apps
Great video again @Reza
Thanks again!
Thank you so much for the super helpful video Reza. I can't wait to try implementing this. I also wanted to display this chat (following the same format) in an email whenever a user adds a new comment to the ticket. How can I display this field using a power automate flow? Thank you!
The chat data is obtained from flow. You can simply format that in html and share it in email. It should not be that hard.
Thank you so much Reza
Most welcome
Another great video Reza. The @ mention is great but the email notification redirects people to the list instead of the app which isn’t ideal in our use case. We'll likely end up reproducing a similar experience by using another list to store our comments instead. We might even go nuts and attempt a reply button to keep them in threads 🎉
Another option would be to use the @mention logic in power apps but not actually post it as an @mention in comments. Rather send a custom notification from PAuto
AWESOME! Once I wanted to show Title and Comments columns in Power BI but the @mention is object instead of user name. No sure if anyone can extract Email or User Name from @mention.
Thanks
Loving it. Can we do the same on SharePoint documents libraries?
Thanks! I have not tried with doc libs. I dont see the same comments feature there. There is Office comments within files in libraries. There could be an option to get that, but not something I have explored.
Hi Reza, thanks for this. I have built something based on the video but curious on how to filter the chat based on a date range, displaying the date is fine but would like the dynamically control the view of the comments,
Not something I have explored
@@RezaDorrani Sorted it thanks anyway.
Awsome Idea
Thank you! Cheers!
Great tutorial. Please post tutorial to make the Issue Tracking Dashboard used for this, thank you.
Check my playlist on modern controls
@@RezaDorrani Thank you, but I don't see where you make the Issue Information Form, I need to make that before I can follow this, it's not working for me. The modern controls have a lot of great examples, but I don't see that one. Sorry.
@@georgeloughery8570 You wont see an exact replica of that form but I have done several videos where I have built the form and gallery on home screen. There are all placed in the modern controls playlist. I had a colleague use it a week ago.
I have a general question that's not directly related to this video. Whenever I create a new screen, I find myself constantly referring back to previous screens to match colors, sizes, and other control settings. Is there a way to centralize these layout elements so that any new controls I add automatically inherit the width, height, font, and other design properties, saving me from manually adjusting them each time?
With modern controls, the only option is modern themes which is limited.
With classic controls, you can frame a pattern www.iammancat.dev/2022/01/power-apps-branding-template-v3/
This is great! Is there a way to prevent comments or post from being deleted (by anyone other than admins)?
No, since as long as a user can post a comment - they can also delete it.
Great video 😊👍
Quick question, have you done any video on help desk or like a support center ?
Thanks!
Not an end to end video.
@@RezaDorrani okay
Please consider something like that
@@benjietunchie I make videos when I receive multiple requests on a topic. Every 6 months I ask subscribers for topic suggestions on Community Tab of my channel. Most voted idea gets added to my backlog. Make sure to post this idea whenever I post the next topic suggestion post.
Hi Reza, brilliant video as always. Is it possible to display the message order from oldest to latest, as by default it shows from the most recent one down to the oldest one. Thank you
Most welcome.
You can always sort the results based on date.
@@RezaDorrani I try to sort based on Value.createdDate but it doesn't work, can you please provide me any tips ?
It should work. Not sure what other tip I can share.
Great video! I have learned so much from your videos. I am having one issue on the OnVisible: Set(varComments, GetandPostComments.Run("Get",Table1.Selected.ID).response). What is Table1 referring to in your demo video? I am not able to get this to work on the Power App I created from a SharePoint list.
Table1 is name of table control on my home screen.
The video description has details of the link to download the entire solution (members only)
@@RezaDorrani Thank you!
Hello Reza, awsome idea 💡just curious to know, we do have similar feature with MS List and even we can use Jira as well to keep track of issues, may I know the most benefit of this?
MS list and Sharepoint list is one and the same.
Great and well explained sir. I was wondering if it's possible to continue with a part 2 where you can show us how to add a counter for number of unread comments/ messages in the gallery like in whatsapp unread messages. Is that possible sir?
Thanks!
I have no plans for a follow up on this video and not sure if the scenario mentioned is a possibility
Excellent video. How to add a label to show if the there is a new comment for an item?
You can check to see if there were any comments posted and accordingly show the message.
CountRows can be used
Hi Reza! Awesome work. thanks a lot. Just one question. You see a way how to make mentioning possible in the PowerApp directly? I am neither able to see mentioning in the app, nor I am able to mention somebody in the app.
End of video I do show the option for @mention.
Details on link to download the full app is in video description
Thanks! So focused on building along, that I missed the end 😢😂
@@TengBangable I always show something dramatic at the end 😊
I’ve been following you for a couple years and have a mate in Malawi also really loves your work and would benefit from lessons. I’ve been trying to assist him but I too am still learning. The exchange rate makes it very difficult from an affordability perspective. Is it possible to obtain a discount for interested parties in Malawi?
Thank you so much for supporting my work over the years. I truly appreciate it, and I’m glad to hear that your mate in Malawi enjoys the content too. Regarding the membership, the pricing is set uniformly across all members, as TH-cam doesn't offer an option for regional-based pricing at this time. I understand that this can be challenging due to the exchange rate, but I hope the content continues to bring value to you both.
I tried to build this Q/A doc that would help address common questions on memberships thepoweraddicts-my.sharepoint.com/:w:/g/personal/rdorrani_thepoweraddicts_onmicrosoft_com/EbvjdBY80QRGkT6svJEmzZwBz64PNYQDRvKHm8eRHEYe6Q?rtime=GVrSLBDk3Eg
Looks good! Do you have a solution on how to build a fully functional @mention function in Power Apps? I have almost got it by showing a people picker when typing "@" character, but it's not fully functional like other chat apps. Then I used rich text control instead of textinput which means I had to workaround html also...
You mean the one I showed as demo in end of video?
@@RezaDorrani Yes, but more like a other chat apps like in Teams or Sharepoint when you mention someone by typing @
@@PatrickPedersen85 I have not tried that @mention scenario
Is it possible to show a count of the number of comments? For example, I have an icon that opens the comments screen. I would like to display the number of comments next to that icon. Thank you.
You can always use countrows function to get that info
Hi Reza, thanks 👍 yet another exciting tutorial. I was wondering if we can give option to delete comment, as in SharePoint we have delete as well as edit option for each comment. I have added a trash icon 'OnSelect': Set(varComments, flow.Run("Delete",Table1.Selected.ID).response), and in the flow i have added an Or condition branch to check if the input is equal to Delete then using the send an HTTP request method type 'DELETE' to delete the particular comment, but no luck. I keep getting error code 502, the type Microsoft.SharePoint.Comments.Comment EntitySet does not support HTTP DELETE method. One thing i noticed is once i use ThisItem.Value id in a text label property it gives me the exact "id" of the item as per the JSON structure in the flow. I am hoping that i am the right track to crack this, any guidance will be much appreciated.
You seem to be on the right track. It should be possible. I have not tried this though, so my inputs would be more theoretical
When I check the flow results I keep getting error code 502, the type Microsoft.SharePoint.Comments.Comment EntitySet does not support HTTP DELETE method.
Im not sure about this. I will suggest posting your issue on forums at powerusers.microsoft.com/
@@RezaDorraniFinally got the DELETE method to function perfectly. To delete a specific comment we need to provide a commentID input parameter type number(make it optional) in the api after Comments(commentID) similar to what we do to get ItemID. And to get commentID value associated with each comment dynamically I added a text label in the gallery with Text property set to: This item.Value.id. Where 'id' denotes the comment id which we can see in the output JSON. FInally I added a Trash icon in my gallery and set its 'OnSelect' property to: Set(varComments,Flowname.run("Delete",Table1.Selected.ID, {num_2:txtlabel.Text}). response). Similarly I added an edit icon to edit each comment using the PATCH method.But all thanks 🙏 to you for your detailed and simple explanation which pushes us to think out of the box.
So each time you open a item the flow needs to run to get the comments? If yes, is there anyway to load this comments without using a flow, less delay and less calls
Only way to call SharePoint rest api using standard connectors is via flow.
You could also not call flow when item is viewed and have user click a button to load the comments on demand
@@RezaDorrani thank you for answering great videos
How do you add the date field? I’m assuming it’s a this item.value but not sure the next command, would it be createddate?
ThisItem.Value.createdDate
To format it use: Text(DateTimeValue( ThisItem.Value.createdDate),DateTimeFormat.ShortDateTime)
@@RezaDorrani amazing! Thank you
Reza can we achieve same using graph api in powerapp without integrating flow
Not something I have explored, hence not sure
How can I get date and time with format as well as mention
All info is shared in app solution shared in video description
Another great video! Could you please build a room or desk booking app that avoids duplicates and time conflicts?
Thanks!
I make videos when I receive multiple requests on a topic. Every 6 months I ask subscribers for topic suggestions on Community Tab of my channel. Most voted topic ideas get added to my backlog. Make sure to suggest this idea whenever the next topic suggestion post is out.
@@RezaDorrani Sure. I will make sure to do that. Do you have an upcoming q&a session?
@@tsion1919 Today at 5 pm cst for channel members only
@@RezaDorrani Thank you! Do we have to submit questions before hand?
No, it would be LIVE on call only.
Please, can you make video on "Power Platform Admin View App" in Power platform @Reza Sir
I make videos when I receive multiple requests on a topic. Every 6 months I ask subscribers for topic suggestions on Community Tab of my channel. Most voted idea gets added to my backlog. Make sure to post this idea whenever I post the next topic suggestion post.
I was trying to do this but using json, I had a hard time doing it
I hope this was easier
For me the values are comming nul when i run the flow please help me its urgent
Video description has details on link to download the app.
I have not faced any issues with it.
"I want to become a Silver member, and my question is whether 'Access to Apps & flows' means that I can see the code?"
You will get the app or solution export which you can import in your tenant.
@@RezaDorrani Thank you, are these all of your works or just a few special ones?
@@yijinlin6885 This doc has all the answers thepoweraddicts-my.sharepoint.com/:w:/g/personal/rdorrani_thepoweraddicts_onmicrosoft_com/EbvjdBY80QRGkT6svJEmzZwBz64PNYQDRvKHm8eRHEYe6Q?rtime=Cd5ITIbv3Eg
The comments are coming as null in the response. Any suggestions?
Can you please help in this
Video description has link to download entire solution (members only - check description for details)
I would suggest giving that a try.
@@RezaDorrani Im using an old list. It allows me to add comments in sharepoint. But are not visible over the api response.
@@RezaDorraniit is working fine for lists that i recently created
@@tusharsingla6364 Im not sure if there is some limitation with older lists
My comment got erased. need to pay to help with the error? ,,,,, :(
I have not experienced the mentioned issue, hence not sure whats the cause for your issue.
You can try downloading the solution shown in video (members only - check video description for details)
@@RezaDorrani Nevermind, your videos before were cool no hidden steps nor payment required to have full scope. But yeah, Thanks for the foundation. I understand your way now on giving advice and even download is not free now. But still you did great to all this time.
@grapesfamily29 My response was relative to your comment which got deleted as my channel policy (auto setup) blocks or deletes posts with links.
No one is forcing anyone to pay. It's a choice and not mandatory.
It takes a lot of effort to package, document the installation steps for the solution and help support every question that comes my way.
The video itself has been used by many to frame the solution without needing to download anything.
@@RezaDorrani Agree, though, its you who let us choose instead of for free. But hey, Not arguing its your way, so no biggie. Just giving my honest comment.
@grapesfamily29 Being free or not is my decision as I am the one spending the time and effort to deliver a packaged solution.
@5:23 . I guess I just don't trust the Microsoft Power Automate team (I think that's actually yours Reza) to support a "drop down list" properly. So Imma use text until a very unspecified future date where I trust that your team isn't going to mess up the interfaces (again).
The team does not work for me. If you dont trust the dropdown, then you are free to use the text option.
Reza, how do you add the text for the date and time?
I tried This.Item.Value.created, but it is not showing the date
I shared the code in a comment posted by another user. Please check.
I used: Text(DateTimeValue(This Item.Value.createdDate), "[$-en-US]mm/dd/yyyy hh:mm AM/PM")
@6:45 ...again.... Use _api/web/lists(guid'*guid_of_your_list_here*') instead of _api/web/lists/getbytitle. Naming of lists changes too often within SharePoint and the reference can break. Using the GUID ensures you can have an unbreakable link to the list. Don't get me wrong, this is good info to share, but I need my stuff to work reliably.
Good point. However I am putting out a video to ensure things are explained in simple terms.
Thanks Reza, why am I getting '@mention{0} just testing something dont responded'
Because thats what the json returns. A lot more work is needed to get the details of the mentioned user.
Video description has link to download entire solution (members only - check description for details)
@@RezaDorrani Any chance you could take us through @mention solution, I’ve downloaded your app but struggling to incorporate it in to my own existing app. Thanks in advance.