Skip to main content

Notifications

Community site session details

Community site session details

Session Id : AYVv97wlPxRnfOaYqt6Mc3
Copilot Studio - General
Unanswered

Downloading a conversation transcript and sending it by email

Like (1) ShareShare
ReportReport
Posted on 22 Aug 2024 10:31:44 by 113
I have created a chatbot that is on the front line of the helpdesk.
I have it set up so that if the user does not like the answers, then they can send their question to the team, but I would like the content of the entire conversation to be included in the email. To be able to track the entire situation.
Unless there is an alternative solution.
Categories:
  • AK-18071435-0 Profile Picture
    6 on 23 Aug 2024 at 18:15:44
    Downloading a conversation transcript and sending it by email
    I am not sure whther this is the rite approach, just giving a different option 2.

    If you use this below KQL , you should be able to get the full chat script.
    (there is a small write latency, since Dataverse is being used behind the scene for storage for Telemetry logs)
    May be you can expose as a service with query and email and invoke the it from the Copilot studio thru http call.(i am yet to try this)

    customEvents 
    | where customDimensions.conversationId == "eb25de31-xxxx3-45ed-bbb8-d90efaxxx52b"
    | where timestamp > datetime("2024-08-19T20:03:37.216Z") and timestamp < datetime("2024-08-23T20:03:37.216Z")
    | where name =="BotMessageSend" or name =="BotMessageReceived"
    | project name, customDimensions.['text']
  • Expiscornovus Profile Picture
    31,671 Most Valuable Professional on 23 Aug 2024 at 14:15:43
    Downloading a conversation transcript and sending it by email
    I have seen an alternative solution on this forum.
     
    With Power Fx you can use the System.LastMessage.Text and store it in a global variable. At the end of the conversation you can use that to send the content of that variable in a Power Automate cloud flow.
    Concatenate(Global.VarTranscript, System.LastMessage.Text)

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Copilot Studio - General

#1
Ekta Gupta Profile Picture

Ekta Gupta 4

#2
ricardodesouza Profile Picture

ricardodesouza 2

#2
L-1234567-0 Profile Picture

L-1234567-0 2

Overall leaderboard
Loading started