web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Copilot Studio How to add/append to a...

Copilot Studio

Suggested Answer

How to add/append to a conversation record?

(0) Share

Report

Report

Posted on by DustinBoy

We are aiming to keep a record of the bots conversation with the user so that copilot can search the data for context based on the users previous input. How can we append or "add" to the record (which is essentially a "table"/array of transcripts that make up the entire conversation record.

It seems like there should be an easy way to do his without using power automate flows. If this is the only way, how do we go about doing this?

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

-jake- 38 on at

Like (0)

Report
Copy link

Link copied!
Struggled with with appending message objects to a conversation array in late 2023. What ended up working was storing the conversation history table/array as a global string variable.

Our responses were coming from a custom backend (via logic app). Each time that topic got called, an action would append the input/output object like this:

Here is the value formula:

Global.messageHistory & "{""role"": ""human"", ""content"": """ & Substitute(System.Activity.Text,"""","\""") & """}," & "{""role"": ""ai"", ""content"": """ & Substitute(Global.responseBodyLogicApp.responseMessage,"""","\""") & """},"

It was a major pain, and this workaround is ugly. But it works and has been reliable.

Note: you may not need the Substitute function ... I think that was something unique to our response body

Note 2: the conversation array (as a string) will have a trailing comma after the last object, like: {obj1},{obj2},{obj3},
You will need to trim that, and place the rest into brackets [ ] before converting it to a proper table data type

Was this reply helpful? Yes No
-jake- 38 on at

Like (0)

Report
Copy link

Link copied!

I think you can probably ignore what I typed up earlier. I forgot about the "update items in a list" variable action. You might need to add it from code editor but it will make this 100x simpler to achieve than what I was describing.

See answer here, for context: https://community.powerplatform.com/forums/thread/details/?threadid=d37b32ce-69c6-4488-a376-1d0313611423

Was this reply helpful? Yes No

Join the conversation