How to Use the New Dataverse “Prompt Column” to Automate Categorization with AI

#powerapps #powerplatform

This article was originally published on My Tech Blog.

A new "Prompt column" has been added to Dataverse, so I verified how it works.

Prompt column

The new Dataverse feature, "Prompt column," is a column where generative AI automatically populates values by referencing information from other columns in the table.

It is faster to demonstrate it in action than to explain it, so here is a verification of its behavior.

Preparation

Let's assume we have an "Inquiry" table like the following.

Suppose we want to add a "Category" column to this table and "automatically" categorize items into "Request," "Question," "Consultation," etc.

Previously, I would combine Power Automate and AI Builder, but this time I will achieve this using the Prompt column.

Configuration

First, select [New column], choose [Prompt] for the [Data type], and

Click [Add new prompt].
*Currently, the format is "Text" only.

Then, configure the prompt as shown below and save it.

Finally, save the column to complete the configuration.

Verification

Add the category column to the form for verification.
*Set it to read-only so it is not modified by mistake.

Next, enter an appropriate title and body in the form, and when you click [Save],

The result categorized by the AI will be populated.

If the title and body indicate a "Question," the category becomes "Question."

This is convenient!

While the Prompt column is extremely useful, it appears to operate using AI Builder credits. Therefore, exercise caution if you create it in a table where a large number of records are added, as unexpected costs may occur.