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!
@ right now I'm trying a kind of walkround adding a new collumn number type named COMMENTS, so, every time a comment is placed I'll patch this collumn with the current value +1... not a fancy solution but I think it would works.
@@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.
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
Video description has link to download the entire solution for members. Note: you can always add test data. Key is the list schema which has been shared with members.
Hi Reza, thanks for another fantastic video. I am early into my Power Platforms journey but you have helped immensely this far. Do you know if it would be possible to use the form control which could be used to populate the comments field? I am trying to think of a way to create an app to document audit findings and this could be a great fit if it could be used with a form. Really appreciate any info you can provide.
You could add the comments section to form by creating a custom card. However, it would still require calling the flow to save the comment as shown in video.
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!
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 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.
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, 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,
Great tutorial! I have a question about implementing a comment feature in an app. How can I design a system where users can add comments on multiple screens, each tied to specific submodules within those screens? For example, if I have different modules on various screens, how can I ensure each module has its own comment section where users can interact seamlessly?
I do not have a video reference on the mentioned scenario and would have to try it out to know the options. I will recommend checking or posting your query on forums in case someone has done something similar community.powerplatform.com/
Great video! Will this only work if my information is coming from a Data Table? I am trying to get this to work with my Gallery design and having all types of issues with getting comments. I can see in SPO that the comments are there but for some reason not showing up in my chat area as well as the flow is grabbing comments from the column data and not the @comments area. I will try deleting my column to see if that works. Also, in the JSON, I only see "body": { "d": { "Comments": [ ] NOT "body": { "d": { "results": [ ]
I have not tried with data table. 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 UPDATE: After a full day of troubleshooting, I finally deleted one of my columns that stored comments. For whatever reason Power Apps was holding on to that data as comments coming from my column instead of using the @mentions section. After deleting, I can now see everything you did in the video. Whew! Kazzah!!
I have watched your video many times but still cannot figure out where you got the Table1 attribute field in the Set(var....) call. I look forward to hearing from you.
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.
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.
Hi Reza! I have implemented this awesome solution some time ago, and it was working perfectly, but recently i found that the response from the flow replaces ":" and maybe some other "special characters" with ascii code. They appear correctly on the list item, but in the variable where i store the flow response they are converted to ascii. Have you experienced this? is there a way to solve this? Thanks, I love your channel!
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
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.
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.
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 do not remember the code by heart. The steps are as shown in video. Once you get the json response - you can check the properties and use the values needed.
@@RezaDorrani so now I'm not sure what I'm doing wrong but now it does record the comments from the app to SharePoint. but they are not visible in the app. Hopefully you can help
and here is the error i get on Startup. QuoteComments.Run failed: The function 'Run' has an invalid value for parameter 'number' - a blank value was passed to it where it was not expected. Please make sure that a valid argument is passed to the function.
@ricklaguna9386 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)
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?
Table1.selected was the formula used from what I remember. You can try downloading the solution shown in video (members only - check video description for details)
Hi Reza, great Video. My Problem is, it always posts with the same User, its the user connected to the flow. I already tried it on iphone or ipad, its always the same author. Can you help me with that? Thank you!!!
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 Thanks to your reply. I wonder how the HTTP action in the flow identifies the user. The flow only receives the input, the ID, and the comment, not any user information. I considered passing the user's email to the flow to define the author in the HTTP action, but unfortunately, I couldn't manage to do that.
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.
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...
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 UA-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
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.
hi, I was checking for your action to delete but I cannot get my flow to work, would it be possible for you to explain more in details, as I'm new to flow, thank you
@ I have created an app that looks like Microsoft planner. My table is inside a gallery housed under a contAiner. I am not sure what to use cause when I try to use the data name it gives me 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)
The modern text control has a property called 'Trigger Output' - you can set that to 'Key Press' to enable the button immediately. It’s a simple adjustment, but I appreciate the attention to detail!
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.
@@RezaDorrani wow thanks for the fast reply. I'm actually working on it as we speak. Apparently the JSON structure has to contain an addition property called "mentions" which has an array of "results" in it. The actual mentions in the text have to be in this format: "mention{0}" where 0 is the index of the mention -> results item. I mean that's what I'm seeing from the comments, but I haven't really tested it out yet. Was hoping you have some info on that before I go down a weird rabbit hole. I didn't find the code anywhere in the video about how exactly that mention works in your app
@@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.
Great video! I follow quite a few Power Platform UA-camrs, but Reza is my favorite to learn things that nobody else has even thought of trying yet!
Thanks so much! Everyone is unique in their own ways.
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. 🤣
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.
I love your excellent R and D. You help us see what is possible.
Thank You so much
Great Job!!!
Congrats from Brazil.
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.
You are the best! How could you be such great?!
I work very hard on picking the right topics.
Awesome!!!, very well explained
Thank you for sharing your knowledge and experiences
Thanks!!
Excellent Session Bro
Thanks for listening
Thank you. Realy helped me making it
Excellent video. Thank you Reza...!
My pleasure!
What would we do in this world without Reza? That man is my god
Hey, thanks man! Im no God :)
Awesome Sir Reza
Thanks
Thanks Reza really good functionallity.
Most welcome!
Great video again @Reza
Thanks again!
Thank you so much Reza
Most welcome
awesome! I keep improving my app full powered by Reza
Great
@@RezaDorrani I'm wondering how to mark a gallery item when it have comments on it just like in the sharepoint list with a dialog icon.
@@cimarr0nargent0 Something I would have to try to know the options
@ right now I'm trying a kind of walkround adding a new collumn number type named COMMENTS, so, every time a comment is placed I'll patch this collumn with the current value +1... not a fancy solution but I think it would works.
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.
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
hi Reza, amazing job, can you share with us the sharepoint list items so that we can test on our environment?
Video description has link to download the entire solution for members.
Note: you can always add test data. Key is the list schema which has been shared with members.
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
Hi Reza, thanks for another fantastic video. I am early into my Power Platforms journey but you have helped immensely this far. Do you know if it would be possible to use the form control which could be used to populate the comments field? I am trying to think of a way to create an app to document audit findings and this could be a great fit if it could be used with a form. Really appreciate any info you can provide.
You could add the comments section to form by creating a custom card. However, it would still require calling the flow to save the comment as shown in video.
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.
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
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.
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/
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, 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.
@paddysheeran, could you share your formula for sorting the chats? Im having trouble with the FX here. Just want is to sort based on createdDate
Great tutorial! I have a question about implementing a comment feature in an app. How can I design a system where users can add comments on multiple screens, each tied to specific submodules within those screens? For example, if I have different modules on various screens, how can I ensure each module has its own comment section where users can interact seamlessly?
I do not have a video reference on the mentioned scenario and would have to try it out to know the options. I will recommend checking or posting your query on forums in case someone has done something similar
community.powerplatform.com/
Great video! Will this only work if my information is coming from a Data Table? I am trying to get this to work with my Gallery design and having all types of issues with getting comments. I can see in SPO that the comments are there but for some reason not showing up in my chat area as well as the flow is grabbing comments from the column data and not the @comments area. I will try deleting my column to see if that works. Also, in the JSON, I only see
"body": {
"d": {
"Comments": [ ]
NOT
"body": {
"d": {
"results": [ ]
I have not tried with data table.
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 UPDATE: After a full day of troubleshooting, I finally deleted one of my columns that stored comments. For whatever reason Power Apps was holding on to that data as comments coming from my column instead of using the @mentions section. After deleting, I can now see everything you did in the video. Whew! Kazzah!!
@@twismfamily thank you
I have watched your video many times but still cannot figure out where you got the Table1 attribute field in the Set(var....) call. I look forward to hearing from you.
it's at 10.08 seconds
Table1 is the name of my Modern Table control on the home page of my app.
@@RezaDorrani oh i understand thank you very much
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 😊
Hi Reza, is chat available in Dataverse?
This using office commenting feature of SharePoint.
I don't believe dataverse has that feature.
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.
Hi Reza! I have implemented this awesome solution some time ago, and it was working perfectly, but recently i found that the response from the flow replaces ":" and maybe some other "special characters" with ascii code. They appear correctly on the list item, but in the variable where i store the flow response they are converted to ascii. Have you experienced this? is there a way to solve this? Thanks, I love your channel!
I am not aware of any changes and have not experienced this.
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.
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
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!
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
Reza, awesome video... question... How do i add the date and time of the author or what is the formula?
Thanks!
I do not remember the code by heart.
The steps are as shown in video. Once you get the json response - you can check the properties and use the values needed.
@@RezaDorrani so now I'm not sure what I'm doing wrong but now it does record the comments from the app to SharePoint. but they are not visible in the app. Hopefully you can help
and here is the error i get on Startup.
QuoteComments.Run failed: The function 'Run' has an invalid value for parameter 'number' - a blank value was passed to it where it was not expected. Please make sure that a valid argument is passed to the function.
@ricklaguna9386
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)
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
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.
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.
How do you get the item id from table1. can you show us the screen.
Table1.selected was the formula used from what I remember.
You can try downloading the solution shown in video (members only - check video description for details)
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
Hi Reza, great Video. My Problem is, it always posts with the same User, its the user connected to the flow. I already tried it on iphone or ipad, its always the same author. Can you help me with that? Thank you!!!
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 Thanks to your reply. I wonder how the HTTP action in the flow identifies the user. The flow only receives the input, the ID, and the comment, not any user information. I considered passing the user's email to the flow to define the author in the HTTP action, but unfortunately, I couldn't manage to do that.
@@TimR-j8o when flow is called from power apps - the actions in flow run under app users context
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
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
Reza can we achieve same using graph api in powerapp without integrating flow
Not something I have explored, hence not sure
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 UA-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
Is it possible with dataverse table?
This video is specific to sharepoint.
@ thanks for the reply!
i am asking in general if it is possible.
@GalAsoR1 Probably yes but not something I have explored
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.
hi, I was checking for your action to delete but I cannot get my flow to work, would it be possible for you to explain more in details, as I'm new to flow, thank you
How can I get date and time with format as well as mention
All info is shared in app solution shared in video description
Can't figure out the FX to resort the order :(
I know a few folks who shared in comments they were able to do it. I don't have the formula handy.
When you choose Table1 what is that table?
That's the name of the Table control on my home screeen
@ I have created an app that looks like Microsoft planner. My table is inside a gallery housed under a contAiner. I am not sure what to use cause when I try to use the data name it gives me 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)
Nice cut at 21:03 to avoid showing that the button doesn’t become active when you type, but instead, you have to select another element in the app 🤣🤣
The modern text control has a property called 'Trigger Output' - you can set that to 'Key Press' to enable the button immediately. It’s a simple adjustment, but I appreciate the attention to detail!
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 was trying to do this but using json, I had a hard time doing it
I hope this was easier
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.
So when do you actually explain how that mention works?
I don't cover that in video as the code was complex. I believe I show the code in latter part of the video.
@@RezaDorrani wow thanks for the fast reply. I'm actually working on it as we speak. Apparently the JSON structure has to contain an addition property called "mentions" which has an array of "results" in it. The actual mentions in the text have to be in this format: "mention{0}" where 0 is the index of the mention -> results item. I mean that's what I'm seeing from the comments, but I haven't really tested it out yet. Was hoping you have some info on that before I go down a weird rabbit hole. I didn't find the code anywhere in the video about how exactly that mention works in your app
Video description has details on how to download entire solution (members only - check description for details)
"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.