answering a value based on user input

(0) Share

Report

Posted on by ThitChoLover

Hi guys I'm trying to use the bot to walk users through a troubleshooting process. It goes something like this

does your product have high or low concentration

high/low each leads to a branch with different directions

I can get to this but is there a way for the user to input the amount of product and PVA will give them an answer of what to do?

example:

low concentration>

PVA: what is your product amount in grams

500

PVA does a calculation (500 * 6%) and tells the user to add in that much (30) of a product (6% is a constant number for products with low concentration)

thanks

Categories:

Building Copilot Studio chatbots in Microsoft Teams

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

Expiscornovus 33,830 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @ThitChoLover,

You could do the calculations via a Call action and a Power Automate flow. In Power Automate there are functions like div (divide) and mul (multiply).

@rishona_elijah recently written a nice blog about calculations. Have a look at that one as a starting point:

https://powerusers.microsoft.com/t5/Power-Virtual-Agents-Community/Use-Power-Virtual-Agents-to-automate-calculations/ba-p/1264417

If you need any additional help setting it up let us know here.

Was this reply helpful? Yes No
ThitChoLover 8 on at

Like (0)

Report
Copy link

Link copied!

I tried but got this error

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

Like (1)

Report
Copy link

Link copied!

Hi @ThitChoLover,

It looks like you added the expression as regular text instead of into the expression editor. If it is recognized as expression you should see an fx icon in front of it when editing.

Below I have created an example of the same calculation in a topic.

The flow with the same function.

The bot in the authoring canvas.

Was this reply helpful? Yes No
ThitChoLover 8 on at

Like (0)

Report
Copy link

Link copied!

it worked! Thank you so much

Was this reply helpful? Yes No