Announcements
It is possible to send an email with the user's comments and that this is sent in the Body of the email. srry for the question but i new in this world
Hi @Anonymous,
Just to double check. Are you talking about comments in a SharePoint Online list/library? And do you want to sent the e-mail via a Power Automate flow?
If so, you could use the Comments method for this together with a Send an HTTP request to SharePoint action. In this thread I have shared a short example of that approach:
https://powerusers.microsoft.com/t5/Building-Flows/How-to-get-a-comments-from-a-sharepoint-list-in-an-email-with/m-p/843962/highlight/true#M118121
Btw, you don't have an additional requirement to use a chatbot in this use case? Just asking because this is the Power Virtual Agents forums 😁
really what I need is that once a user responds to the power virtual agent bot, send the last comment of the user through an email, that is, take the user's comment to the bot and make the bot send it by email using power automate
I believe it would be possible by getting this activity type (message) from the content field of the ConversationTranscript table in Dataverse from a Power Automate flow. Also sending this information would be possible from that same flow.
I can create an example of this, if you want?
If you can I would appreciate it since I am starting to make the bot and the truth is that I do not know much about dataverse and I just wanted to see to send the last comment of the user by email
I have got a first sample which I am still testing. However, I did wanted to let you know one challenge with this setup.
It takes a minimum of 6 hours for the transcripts to reach Dataverse:
https://powerusers.microsoft.com/t5/General/Conversation-Transcript/td-p/589400
So, you can only send that e-mail after 6 hours, not sooner. Don't know if you are still interested in this solution if that is the case?
For the user my current sample will look like this (embedded into the end of conversation system topic):
@Expiscornovus Yes, It works for me, at the moment I do not have anything similar, what I can do is with a team to improve it but this helps me a lot to start
Short update from me.
Still working on the sample. It is not finished yet because the filter query is not specific enough. So, there would be a high risk that you are collecting somebody else his/her transcript.
But I did wanted to share what I got so far with you so at least you know what kind of approach I was using.
1. Create a sub flow like below. This sub flow which gets triggered by the flow from step 2 and waits for 6 hours before it tries to retrieve the transcript.
This is the flow which still needs work. The filter rows field in the List rows action needs to be more specific 😁
2. The parent flow which interacts with the bot and retrieves the correct details to find the transcript
3. The changes to the End of Conversation topic. As you can see I added a question and calling the parent flow from step 2.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Valantis 410
Romain The Low-Code... 160 Super User 2026 Season 1
chiaraalina 63 Super User 2026 Season 1
