Unanswered

Place whole conversation in a variable

(0) Share

Report

Posted on by bartm

Hi all,

I was hoping to put the whole conversation that i have had since starting the bot conversation in a variable and be able to pass the whole conversation to power automate.

This is just for a hobby project. No business need.

I was trying to use the openAI connector in power automate and trigger it on a fallback topic in a power virtual agent.

This works, but the openAI connector does not give contextual answers now as only the last question is past to the connector.

Apparently i if would pass the whole conversation to the connector the context of the conversation would work, so was hoping to be able to do just that.

Any hints ?

thx

Bart

Categories:

General topics

I have the same question (0)

All responses (8)

Answers (0)

peterswimm Moderator on at

Like (0)

Report

The whole conversation is tricky; you might just want to use a bot framework bot to collect the conversation and send it to opengpt, and then call the appropriate PVA conversation as a skill.

Was this reply helpful? Yes No
Expiscornovus 33,194 Most Valuable Professional on at

Like (0)

Report

Hi @peterswimm,

It might be possible to get the conversation from the Content column in the ConversationTranscript table in Dataverse.

That will be in json format, so it might require some extracting and reformatting to be usable though.

Was this reply helpful? Yes No
HenryJammes on at

Like (0)

Report

@Expiscornovus Conversation Transcript records in Dataverse get created approximately 6 hours after the conversation, so the content isn't available at runtime.

Was this reply helpful? Yes No
Expiscornovus 33,194 Most Valuable Professional on at

Like (1)

Report

Hi @HenryJammes,

I am aware of that limitation, thanks for the heads-up 😀.

Imo it could still be interesting to explore the Dataverse approach (with for example a delay action within your Power Automate cloud flow which is set to at least 6 hours).

I know it is not real-time but I can imagine you could still have interesting use cases. Like sending an email after the conversation with suggested answers for the questions or sentiment analysis of the whole conversation with AI. You can probably also use pro-active messages for this in the context of the PVA once the OpenAI connector stuff gets processed.

And like @bartm says, it is a hobby project. I don't know if the real-time feedback/response is a requirement in this specific OpenAI connector instance?

It would be interesting to see how OpenAI handles the conversation content. I will definitely test a couple of things with it 😁

Was this reply helpful? Yes No
HenryJammes on at

Like (0)

Report

@Expiscornovus I see - sorry I thought this was a requirement to have the transcript available at run time, for example in the context of a hand off to a live agent or as part of the conversation flow.
Yes - if the need is to have access to the transcript later, then it's definitely the way to go 🙂

Was this reply helpful? Yes No
Expiscornovus 33,194 Most Valuable Professional on at

Like (0)

Report

Hi @HenryJammes,

You might be right that in this instance real-time is actually a requirement. I let @bartm either confirm or deny, who asked the question 😁

Was this reply helpful? Yes No
bartm 2 on at

Like (0)

Report

The idea here was indeed real-time, as i need to pass the whole conversation back to OpenAI to have conversation context for it's answers.

Currently i have tried to just put the whole conversation in a sharepoint list, read that list and add it to the data i feed the OpenAI connector. To make sure it's not too big i have the SP list cleaned again based on date change, but that's a dirty workaround 😄

Was this reply helpful? Yes No
Derrick2 32 on at

Like (1)

Report

So, is it possible to have access to the conversation at run time? I also need to be able to do this for two reasons:
1.) Live agent handoff so they know what has occurred without having to have the user restate things.
2.) Creating a ticket in our ticketing system and including the conversation as work notes to lessen the need for contacting the user after once a ticket has been submitted.

Was this reply helpful? Yes No