🚀 Intelligent text suggestions in Dataverse with Prompt Columns – using PV products as an example

Since August 2025, there's been an exciting new feature for Model-Driven Apps in the Microsoft Power Platform: Prompt Columns . These allow you to automatically generate content based on existing fields in a table—a bit like calculated columns on steroids. All this with the help of generative AI directly in the Dataverse form.

In this article, I will show you step by step how to set up and use a prompt column to automatically generate quote items for PV products .

🛠 Initial situation – Our "PV products" table

We use a table called “PV Products” with the following columns:

• Product name

• Item number

• Unit (e.g. piece, system)

• Manufacturer

• Power (e.g. 10 kW)

• Dimensions (e.g. 540 × 315 × 260 mm)

✨ What are prompt columns?

Prompt columns are a new column type in the Dataverse powered by generative AI. They generate content (e.g., descriptions, summaries, or recommendations) based on the existing fields in the dataset— directly in the table , without additional logic or Power Automate flow.

In addition to our use case for the automated creation of quotation items, Prompt Columns can also be used in many other scenarios:

• 💬 Sentiment analysis of customer inquiries

  Automatically generated assessment of whether a request is formulated positively, neutrally or negatively.

• 🧾 Support ticket summaries

  A compact summary is generated from subject, description and priority.

• 📦 Product suggestions for upselling

  Based on category, price and stock availability, suitable alternatives or accessories are suggested.

• 🧠 Profile descriptions for team members

  An appealing short description is created from the name, role and project history – ideal for project pages.

💡 Use case: Create automated offer position

The goal is to automatically generate a quotation description for each PV product. The description should be based on the product name, power output, unit of measurement, and manufacturer.

Example of the desired output:

🧩 Step-by-step instructions for creating the Prompt Column

🔹 Step 1: Create a prompt column

1. Open your solution in the Power Platform Maker portal.

2. Select the PV Products table.

3. Click + Column and select the new type Prompt Column (Preview) .

4. For example, name the column Offer Item (AI-generated).

   

   
   

🔹 Step 2: Define the prompt

When creating it, you now enter the prompt that will be used for text generation.

An example would be:

🔹 Step 3: Integrate Prompt Column into the form

1. Open the main form of the “Products” table in the Form Designer.

   

   
   

2. Add the new prompt column “Offer Position”.

   

   
   

3. Publish the form.

   

   
   

🔹 Step 4: Use in the app

Now, when a record is created or edited, the Prompt Column automatically generates an offer text based on the fields in the record.

📈 Advantages at a glance

✅ Time-saving : No more manual text creation necessary

✅ Consistent : Uniform formulations across all products

✅ Customizable : Prompt can be customized or expanded at any time

✅ Integrated : Works seamlessly in Model-Driven Apps – no external tools required

🚀 Conclusion

The Prompt Column is a powerful new feature that provides immediate value – especially for users

If you're already using model-driven apps, you should definitely try this feature! And remember: You'll get the best results if your prompt is clearly formulated and tailored to your use case.

Want to see a live demo of this feature in action? Feel free to contact me or follow me for more deep dives into Power Platform and low-code!