Skip to main content

Notifications

Copilot Studio - Calling Actions from Copilot S...
Unanswered

Sending comments by mail

(0) ShareShare
ReportReport
Posted on by

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

  • Expiscornovus Profile Picture
    Expiscornovus 31,118 on at
    Re: Sending comments by mail

    Hi @Anonymous,

     

    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 😁

     

    listrows_conversationstranscripts_6hours.png

    2. The parent flow which interacts with the bot and retrieves the correct details to find the transcript

     

    trigger_6hourstranscriptflow.png

    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.

     

    endofconversation.png

  • Re: Sending comments by mail

    @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

  • Expiscornovus Profile Picture
    Expiscornovus 31,118 on at
    Re: Sending comments by mail

    Hi @Anonymous,

     

    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):

     

    emailtranscript.png

  • Re: Sending comments by mail

    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

  • Expiscornovus Profile Picture
    Expiscornovus 31,118 on at
    Re: Sending comments by mail

    Hi @Anonymous,

     

    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?

  • Re: Sending comments by mail

    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

  • Expiscornovus Profile Picture
    Expiscornovus 31,118 on at
    Re: Sending comments by mail

    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 😁

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.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,508

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,839

Leaderboard

Featured topics