Forum Discussion
How to store full user–agent conversation in a custom Dataverse field?
You can use Power Automate to capture and log the conversation. In your Copilot Studio bot, add a Power Automate flow at the end of the conversation. Pass the full conversation as a string (using system variables or context tracking) to the flow, and then use the Dataverse connector to update the Lead table and write to the Conversation field (multiline text). This way, every time a conversation ends, it’s stored automatically in Dataverse.
Thanks so much for your response! That approach works well for structured conversations, but in my scenario, the agent responses are generated dynamically through generative AI, and the conversation doesn't have a clearly defined end or fixed path. Because of that, I'm not currently able to pass the full dialogue into a variable at a single point.
I’m exploring ways to continuously capture the user and bot messages during the conversation and store them incrementally or aggregate them into a global variable. If you or anyone else has suggestions for handling dynamic, open-ended conversations like this, I’d really appreciate it!