Unanswered

Save Response as Text from choice

(0) Share

Report

Posted on by Janvi1

Hello,

I am facing an issue with Power Virtual Agents where I have a choice variable in my project, but the values are stored as choices, not as text. I need to convert the choice value to text for further processing, such as storing in a SharePoint list or passing to a Power Automate flow.

Could someone please help me with how I can convert a choice to text in Power Virtual Agents? Any suggestions or solutions would be greatly appreciated.

Thank you in advance for your assistance!

Best regards,

Categories:

Topic creation & management

I have the same question (0)

All responses (10)

Answers (0)

Jameslew_MSFT on at

Like (0)

Report

Can you clarify what you're using to get a Choice type? When I use a question node with Multiple Choice Options the output variable type is text.

Was this reply helpful? Yes No
postimerkk1 12 on at

Like (0)

Report

Hi,

I am facing the same issue having converted a bot to the new PVA designed version. I have Multiple Choice Options and the variable of its output defaults to "choice" and I can't seem to change it.

Here is a separate question node I now added for an example:
Can I determine the option directly to be interpreted as a string or convert with a function after?

Was this reply helpful? Yes No
postimerkk1 12 on at

Like (0)

Report

Hi,
You may have this figured out already but for anyone else wondering about this. One workable option is to use the set variable action and use the Formula Text(Variable name), i.e. create a new variable and set its value to the Choice value as a string.

Was this reply helpful? Yes No
carlo0s_correa 2 on at

Like (0)

Report

Hi!! You need to convert it like this Text(Topic.Var1)

Regards!!

Was this reply helpful? Yes No
RobertMatthew1 32 on at

Like (0)

Report

I'm trying to do this but for a global variable, which previously worked in the classic build. Adding Text to the formula didn't seem to fix this issue.

Was this reply helpful? Yes No
HenryJammes on at

Like (0)

Report

@RobertMatthew1 wrote:
I'm trying to do this but for a global variable, which previously worked in the classic build. Adding Text to the formula didn't seem to fix this issue.
Can you share the screenshot of what isn't working?
For a global variable, the formula should look like this: Text(Global.Var1)

Was this reply helpful? Yes No
RobertMatthew1 32 on at

Like (0)

Report

This is how the variables look within classic view:

The transferred entries looked like this:

I amended 'Option Set Value' to 'Text' in the affected fields:
This didn't restore the functionality of the process though. When I run this topic in the PVA bot, the question that provides the TopLevel global variable triggers instead, and the bot resets to that stage of the process.

Edit: I also have image flows and an email topic w/o global variables that run fine within this bot.

Was this reply helpful? Yes No
postimerkk1 12 on at

Like (1)

Report

Haven't found a more convenient way myself as of now. Because the bot I converted was relatively small I instead used set variable to create a new global variable i.e. there would be a TopLevel (option) - confined to the topic and a separately set Global.TopLevel (string) variable in your specific case. Feel clumsy admittedly, so hopefully someone has a better solution for it.

Was this reply helpful? Yes No
RobertMatthew1 32 on at

Like (0)

Report

Is there a guide that covers setting a separate Global(string) variable after creating a (choice) variable? I've not had much success finding this, apologies.

Was this reply helpful? Yes No
HenryJammes on at

Like (0)

Report

@RobertMatthew1 wrote:
Is there a guide that covers setting a separate Global(string) variable after creating a (choice) variable? I've not had much success finding this, apologies.
Not explicitly for the cloud flow integration (where Power Automate expects a string), but topic and global variables are documented here, Work with chatbot variables - Power Virtual Agents | Microsoft Learn, @RobertMatthew1

Was this reply helpful? Yes No