Enrich Your Dataverse Tables Using AI Prompt Columns

Microsoft Dataverse continues to evolve as a foundational platform for building intelligent, secure, and scalable business solutions. We are excited to announce the public preview of Prompt Columns, a new way to embed generative AI directly into your Dataverse tables.  

This capability will enable dynamic business logic, context-aware responses that can summarize, classify, extract, and generate content based on your data.  

What is a Prompt Column? 

A prompt column in Microsoft Dataverse is a specialized data column designed to hold textual inputs that serve as prompts for AI models. These prompts can be anything from simple commands to complex queries. The AI model processes these prompts to generate relevant responses based on the input provided. The result is immediately stored in the prompt column, ready to be used in apps, workflows, or reports. 

This means you can bring generative AI directly into your data model without writing code or managing external services. Whether you are summarizing customer feedback, generating draft responses, extracting structured data from unstructured text, or classifying records based on context, prompt columns make it possible with just a few clicks. 

Each prompt is fully customizable and can reference one or more input columns within the same table. This business logic is powered by natural language prompts, allowing you to tailor the AI behavior to your specific business scenario.   

Available Now in Public Preview 

This feature is currently in public preview and intended for early exploration. It is an opportunity to evaluate the functionality, experiment with real scenarios, and provide feedback that will help shape future improvements. 

Versatile Use Cases 

Prompt columns are ideal for: 

Customer support: Automate responses to frequently asked questions by using AI prompts to generate accurate and timely replies based on customer inquiries stored in Dataverse.  

Content creation: Use prompts to assist in writing articles, reports, or marketing materials by generating text that aligns with the input provided.  

Data analysis: Leverage AI prompts to analyze complex datasets and generate insights, sentiments, extract and classify contents or summaries that help in making informed decisions.  

Workflow automation: Integrate AI prompts into business workflows to automatically execute tasks such as scheduling, reporting, and data entry.  

Four Easy Steps to Get Started 

Go to https://make.powerapps.com/. 

Open or create a table. 

Add a new column and select Prompt (preview) as the data type. 

Write your prompt, link input columns, and test your results. 

Your Turn: Try Prompt Columns in Dataverse

Prompt Columns make Dataverse a powerful engine for integrating generative AI directly into your business logic, so you can easily interpret, enrich, and act on your data. Learn more:

For detailed steps and best practices, check out: https://learn.microsoft.com/power-apps/maker/data-platform/prompt-column . 

Watch how prompt column is used together in agents from Build session https://youtu.be/Nx-011g0710?si=FC_SwtGsH50oujgW

Listen to a podcast about Dataverse in the Age of AI: Episode 89: Dataverse in the Age of AI (w/ Julie Koesmarno) | Low Code Approach

Watch the EPPC keynote on Building the Agentic Data Platform for Tomorrow’s Business: EPPC25 Keynote – Nirav Shah – Building the Agentic Data Platform for Tomorrow’s Business

Catch up with our latest sessions at Microsoft Build: Dataverse at Build: The Agent Platform Powering the Future of Agentic AI – Microsoft Power Platform Blog

The post Enrich Your Dataverse Tables Using AI Prompt Columns appeared first on Microsoft Power Platform Blog.
Source: Microsoft Power Platform