Now we will see how we can easily perform some actions based on user input data during chat.

In my example

1. Chatbot will ask user to enter a Mobile number
2. After providing a mobile number a Power Automate Virtual Agent flow will search that Mobile number in CDS database against account entity
3. If account is successfully found then It will return output in form of Account Name to the Chatbot
4. Chat bot will display that account number to user.

Now for first requirement we will have to create a topic or we can modify existing one. I am going to select a topic from the list and click on the circled icon to open the flow for this topic.

You can see a flow which is created against each topic behind the scenes. We will use the same topic and modify it.

• Click on + icon and add a question.
• Now type an appropriate question such as I am asking customer to enter mobile number. Then select a type to identify the type of input from user. I have selected phone as we are expecting a phone number.
• Now give a name to the variable at the bottom. This variable will save user input and further can be used to perform any actions. In our case we will use this mobile number input to our flow to fetch the account record.
• Now create on + icon below the Question we added then click on Call an action.
• This will open a Power Virtual Agent flow with an Input and Output.
• Click on Add an Input add then on Text
• Give any appropriate name to input. Such as I have given mobile.
• Click on + sign and then search for Variable. Select Initialize a variable. We will use this variable to save the returned value of Account name and will populate the output of this flow for our chatbot.
• Give any appropriate name and select type as string
• Now after creating Variable click on + sign under Variable. We will now use List component to retrieve account record from Power Platform CDS database. You can use any other data source.
• In the list Control first select the Account entity. This entity is automatically created once a CDS database is created in Power Platform environment. I have mentioned above how you can create Power Platform environment and database.
• In the filter query we can use Odata query language. I am simply using a filter where I am filtering the telephone field of Account entity and matching it with the input from chatbot i.e. a mobile number entered by user.
• telephone1 eq ”
• between quotes click then it will open a small window. Under Power Virtual agent select Mobile.
• Also I am setting Top count as 1. Which means only return 1 record at the top of results. I am assuming my mobile number is unique for each account.
• After adding List. click on + icon under it and then add Condition component like you added List before. Click on left text box which will open a small window then put below query under Expression tab.