DEV Community

Cover image for AI builder in Power Automate
Seena Khan
Seena Khan

Posted on

AI builder in Power Automate

Greetings to all Tech enthusiasts and Tech specialists!!!

In this post, I am going to demonstrate how to use AI Builder actions in Power Automate.

Scenario: In a table of an Excel sheet identify the sentiments of the text in a column and insert another column to show whether that text meant positive or negative.


  • Prerequisites
  • Create a flow
  • Add an AI Builder action
  • Configure AI Builder action
  • Use model's inference
  • Test flow


  • Power Automate accessibility.
  • A license or trial of the AI Builder.
  • An environment with a Microsoft Dataverse database. (Applicable only for work or school accounts).
  • A Microsoft Office 365 subscription with access to Excel Online (Business) and OneDrive for Business.
  • A basic understanding of Power Automate and experience with creating a flow is recommended.

Create a flow

In this section we are going to create a Microsoft Dataverse solution for creating flow and adding AI builder actions to that flow.

  • Sign into Power Automate.
  • Select Solutions options from the side bar menus and then select +New Solution.


  • In the New Solution side screen enter the following details and select Create:-
Options Values
Display Name AIApp
Name AIApp
Publisher Select the publisher from the drop down list or create new publisher by selecting +New Publisher. I have create a publisher named AIpublisher and then selected it.


  • After creating the AIApp solution please select the solution and then Select +New > cloud flow in the action bar on the top of the screen. Then Select **Automation > Cloud flow > Instant.


  • The Build and instant cloud flow designer screen appears and enter name as AIflow on the Flowname box, then select Manually trigger a flow, then select Create.


Add an AI Builder action

  • On the Manually trigger a flow select +Add an input, then select Text and on the input box enter MyText.
  • Select +New Step.
  • In the search box, enter Analyze sentiment, then select AI Builder.
  • From the actions tab select Analyze positive or negative sentiment in text.

Depending on the needs of the underlying models, different parameters apply to each AI Builder activity.

The two required fields for the AI Builder sentiment analysis model are Language and Text.

Configure AI Builder action

  • In the Language field, select English as the language.
  • In the Text field, select My Text, which is defined in the trigger action.
    The MyText value will be provided during flow testing, so you don't need to focus on it right now.

  • Select Save. Your flow is now saved in the name of AIflow.

Use Model's inference

For this task, you'll use a Microsoft Excel file in OneDrive to store the text sentiment that is detected by the AI model.

  • Create a Microsoft Excel file named AIresults.xlsx and saved it into Onedrive.
  • In this file, insert a table with two columns and then save the file (make sure that you use the Insert > Table function of Excel).
  • In AIflow, select + New step, then select Excel Online (Business) then add the Add a row into a table action from Excel Online (Business).
  • Complete the Location, Document Library, and File fields to point to the Excel file on your machine.
  • In the Table field, select the name of the table that you created in your Excel file.
  • In the Column 1 field, add MyText, and in the Column 2 field, add Overall text sentiment, then select Save.

Test flow

  • Select Test on the upper-right corner of the flow designer screen.
  • Select Manually - Perform the starting action to trigger it. and the select Save & Test.
  • Provide the value of the MyText field from the trigger action. This text is what you want to analyze the sentiment for. For this example, we'll enter It was the best session.
  • Select Run flow. If your flow ran successfully, you would see all steps shown with a green checkmark.


  • You can expand the actions to view the running inputs and outputs of each action, which is a good way to debug your flow.

  • Check that the line has been correctly added in the Excel file.


  • Provide the value of the MyText field from the trigger action by selecting Test from the top menus. Here we'll enter A very bad session.
  • Select Run flow. If your flow ran successfully, you would see all steps shown with a green checkmark.
  • Check that the two lines has been correctly added in the Excel file.


Thanks all !!!

Hope You Enjoyed the Post!!!

Keep Learning | Spread Knowledge | Stay blessed |

Top comments (1)

jettliya profile image
Jett Liya

Elevate your automation game with the AI Builder in Power Automate, a dynamic tool designed to seamlessly integrate artificial intelligence into your workflows. This innovative feature within Microsoft's Power Automate empowers users, both technical and non-technical alike, to infuse intelligence into their processes without the need for extensive coding.

The AI Builder boasts a user-friendly interface and no-code AI capabilities, allowing users to leverage pre-built models or create custom ones tailored to their specific needs. Its integration into Power Automate enhances automation processes, making them smarter and more efficient.

Key functionalities include form processing, automating data extraction from structured forms; object detection, facilitating image recognition for visual data analysis; and prediction models, enabling users to make data-driven decisions based on predictive analytics.

Integrating the AI Builder into Power Automate is a straightforward process, and its iterative nature allows for testing and adjustments to ensure optimal performance. Embrace the future of automation with the AI Builder in Power Automate, where efficiency meets intelligence, revolutionizing the way you approach and streamline your workflows.