Create copilot actions

Scenario

In this lab, you will:

Create copilot actions

What you will learn

How to add use Power Automate to access data in Microsoft Dataverse

High-level lab steps

Create a Power Automate cloud flow to retrieve Dataverse data with a copilot action
Create a Power Automate cloud flow to create Dataverse data with a copilot action

Prerequisites

Must have completed Lab: Work with entities

Detailed steps

Exercise 1 - Create Copilot action to retrieve data from Dataverse

Microsoft Copilot Studio can access data in Microsoft Dataverse using Power Automate cloud flows.

Task 1.1 - Create Power Automate flow to retrieve a property

Navigate to the Microsoft Copilot Studio portal https://copilotstudio.microsoft.com and ensure you are in the appropriate environment.
Select the Test button in the upper-right of the screen to close the testing panel if the panel is open.
Select Copilots from the left navigation pane.
Select the copilot you created in the earlier lab.
Select the Actions tab.
Select + Add an action.
Scroll down and select Create a new flow.
Sign in to Power Automate if prompted.
Select Run a flow from Copilot in the top-left of the screen and enter Get Property as the flow name.
Select the trigger step Run a flow from Copilot and select + Add an input.
Select Text.
Enter Bedrooms for Input and Number of Bedrooms for Please enter your input.
Select the + icon between the two steps in the flow and select Add an action.
Enter Dataverse in the Search field and select See more for the Dataverse connector.
Select the List rows action.
If prompted for authentication, select OAuth and select Sign in.
Select Real Estate Properties for table name.
Select Show all.
Enter contoso_bedrooms eq in the Filter Rows field.
Use Dynamic content to select the Bedrooms parameter and select Add.
Select the Respond to Copilot action and select + Add an output.
Select Text.
Enter PropertyId for Enter a name, click into the Enter a value to respond with field, and select Insert Expression.

Enter the following expression:

 first(outputs('List_rows')?['body/value'])['contoso_realestatepropertyid']

Screenshot of configuring response action.

Select Add.
Select + Add an output.
Select Text.
Enter PropertyName for Enter a name, click into the Enter a value to respond with field, and select Insert Expression.

Enter the following expression:

 first(outputs('List_rows')?['body/value'])['contoso_propertyname']

Select Add.
Select Settings.
Ensure that Asynchronous Response is set to Off.
Select Save draft.
Select Publish.
Close the Power Automate tab.

Task 1.2 - Add a Copilot action to retrieve a property

Select Refresh.
Select the Get Property flow.
Select Next.
Select Next.
Select Finish.

Task 1.3 - Add the Get Property Copilot action to the topic

Select the Topics tab.
Select the Book a Real Estate Showing topic.
Select the the + icon below the How many bedrooms do you need question? node and select Call an action.
Select the Get Property flow.
Select the NumberofBedrooms variable for the Bedrooms input parameter.
Select the three dots in the Which property do you want to see? question node and select Delete.
Select the the + icon under the action node and select Send a message.
In the Enter a message field, enter the following text:

Property
Select the Insert variable icon and select the PropertyName variable.
Select Save.

Exercise 2 - Create Copilot action to create data in Dataverse

Microsoft Copilot Studio can ceate data in Microsoft Dataverse using Power Automate cloud flows.

Task 2.1 - Create Power Automate flow to make a booking

Select your copilot in the Copilot pane on the left-hand side of the screen to return to the Overview tab.
Select the Actions tab.
Select + Add an action.
Scroll down and select Create a new flow.
Select Run a flow from Copilot in the top-left of the screen and enter Create Booking Request as the flow name.
Select the trigger step Run a flow from Copilot and select + Add an input.
Select Text.
Enter PropertyId for Input and Property for Please enter your input.
Select + Add an input.
Select Text.
Enter ViewerName for Input and Viewer Name for Please enter your input.
Select + Add an input.
Select Text.
Enter ViewerEmail for Input and Viewer Email for Please enter your input.
Select the + icon between the two steps in the flow and select Add an action.
Enter Dataverse in the Search field and select See more for the Dataverse connector.
Select the Add a new row action.
Select Booking Requests for table name.
Select Show all.
Enter Copilot booking in the Booking Name field.
Enter contoso_bookingrequests() in the Property (Real Estate Properties) field, move the cursor within the brackets, and use Dynamic content to select the PropertyId parameter.
Use Dynamic content to select the ViewerName parameter for the Viewer Name field.
Use Dynamic content to select the ViewerEmail parameter for the Viewer Email field.
Select the Respond to Copilot action.
Select Settings.
Ensure that Asynchronous Response is set to Off.
Select Save draft.
Select Publish.
Close the Power Automate tab.

Task 2.2 - Add a Copilot action to create a booking request

Select Refresh.
Select the Create Booking Request flow.
Select Next.
Select Next.
Select Finish.

Task 2.3 - Add the Create Booking Request Copilot action to the topic

Select the Topics tab.
Select the Book a Real Estate Showing topic.
Select the the + icon below the What date and time do you want to see the property? node and select Call an action.
Select the Create Booking Request flow.
Select the PropertyId variable for the PropertyId input parameter.
Select the Name variable for the ViewerName input parameter.
Select the EmailAddress variable for the ViewerEmail input parameter.
Select the the + icon below the action node, select Topic management, select Go to another topic and select End of conversation.
Select Save.
Select Publish and select Publish again.

Exercise 3 - Test the copilot actions

Task 3.1 - Make a booking request

Select the Test button in the upper-right of the screen to open the testing panel.
Select the three dots at the top of the testing panel in the upper-right of the screen.
Select Track between topics.
Select the Start a new conversation icon at the top of the testing panel.
When the Conversation Start message appears, your copilot will start a conversation. In response, enter a trigger phrase for the topic that you’ve created:

I want to book a real estate showing

Enter the following information:

 Name: <Your name>
 Email address: <Your email address>

After you supply the information, an Adaptive Card displays the information that you entered, a question asking if the information is correct, and options to select Yes or No.
Select Yes.
Select House for the type of property prompt.
Enter 3 for the number of bedrooms prompts.
Enter Tomorrow 2:00 PM to the What date and time do you want to see the property? prompt.
Select Yes to the Did that answer your question? prompt.
Select any rating.
Select No to the Can I help with anything else? prompt.

Task 3.2 - Verify the booking request

Navigate to https://make.powerapps.com.
Make sure you are in the appropriate environment.
Select Play on the Real Estate Property Management model-driven app.
In the left navigation pane, select Booking Requests table.