How To Add Action To A Bot Using Microsoft Power Automate

6. Enter the question, select User’s entire response for Identity and rename the variable as var_requestID.
   
   
   

7. Click + icon and then click Call an action. Click Create a flow.
   
   
   

8. In the Power Automate portal, update the JSON schema in “When a HTTP Request is received” as shown below.
   
   
   

9. Delete Initialize variable – String and Initialize variable – Number
10. Add Get Items SharePoint action and configure the Site Address & List Name.
    
    
    

11. Add Filter array action and configure the values by adding dynamic vales from previous actions as shown below.
    
    
    

12. Add three Initialize variable actions and configure it.
13. Initialize variable – Request Title action: value - json(string(first(body('Filter_array'))))?['Title']
    
    
    

14. Initialize variable – Comments action: value - json(string(first(body('Filter_array'))))?['Comments']
    
    
    

15. Initialize variable – Status action: value - json(string(first(body('Filter_array'))))?['Status']?['Value']
    
    
    

16. Update the Body and Response Body JSON in Respond to Power Virtual Agents action as shown below.
    
    
    

17. Update the flow name as Request Status and save the flow.

Create a new solution in Power Automate

1. In the Power Automate portal, click Solutions. Click New solution.
   
   
   

2. Enter the details for the new solution and then click Create.
   
   
   

3. Go to newly created solution, click Add existing. Click Flow.
   
   
   

4. Click Outside solutions, select the newly created flow Request Status and then click Add.
   
   
   

5. Flow added to solution successfully.
6. Navigate to Power Virtual Agents, go to Get Request Status topic which was created in the previous section. Click + icon and click Call an action. Newly created flow will be available click that flow.
   
   
   

7. Select the variable from the drop down as shown below.
   
   
   

8. Click + icon and click Show a message. Add the text and output variable values as shown below.
   
   
   
   
   

9. Save the topic.

Test the bot

1. In the left navigation, click Test your bot. Enter request status and wait for the bot response.
   
   
   

Summary