{"id":42111,"date":"2025-08-27T15:47:05","date_gmt":"2025-08-27T10:17:05","guid":{"rendered":"https:\/\/www.inogic.com\/blog\/?p=42111"},"modified":"2025-08-26T16:34:26","modified_gmt":"2025-08-26T11:04:26","slug":"how-to-configure-and-use-the-prompt-column-in-dataverse","status":"publish","type":"post","link":"https:\/\/www.inogic.com\/blog\/2025\/08\/how-to-configure-and-use-the-prompt-column-in-dataverse\/","title":{"rendered":"How to Configure and Use the Prompt Column in Dataverse"},"content":{"rendered":"

\"How<\/p>\n

If you\u2019ve been exploring Copilot and AI features in Microsoft Power Platform, you\u2019ll notice a new column type in Dataverse: Prompt Column (Preview).<\/p>\n

This feature allows you to save natural language prompts against a table, run them on your data, and store the AI-generated response in the same record. The generated text can then be used across apps, views, dashboards, and flows\u2014just like any other field.<\/p>\n

What is a Prompt Column in Dataverse?<\/strong><\/p>\n

A Prompt Column enables you to integrate generative AI into Dataverse tables. By defining a prompt and input fields, you can generate summaries, structured data, or documents automatically.<\/p>\n

\"Configure<\/p>\n

How <\/strong>Prompt Column in Dataverse work?<\/strong><\/h3>\n

Say you store Project details in a table. You can add a Prompt column called Project Summary<\/em>. The prompt could be like:<\/p>\n

\u201cGenerate a concise summary of the project, including Project Name, Account, Contact, Start and End dates, Appointment Date, and Address. Keep it clear and professional in 3\u20134 sentences.\u201d<\/em><\/p>\n

When you set input columns such as Project Name, Account, Contact, Start Date, End Date, Appointment Date, and Address, the AI-generated summary<\/strong> is stored in the Project Summary column. This can be displayed in forms, added to dashboards, or used in workflows.<\/p>\n

\"Configure<\/p>\n

Prerequisites:<\/strong><\/p>\n

    \n
  1. Licensing<\/strong>: Prompt columns use the same model as AI Builder prompts<\/strong> (credits\/messages depending on where you use them).<\/li>\n
  2. Make sure Copilot and AI features are enabled in your environment settings before you start.<\/li>\n<\/ol>\n

    Navigate to Power Platform admin center \u2192 Environments \u2192 select your environment \u2192 Settings \u2192 Product \u2192 Features \u2192 enable Copilot and AI Builder prompts<\/em>.<\/p>\n

    \"Configure<\/p>\n

    \"Configure<\/p>\n

    Create Your First Prompt Column (Step-by-Step<\/strong>)<\/strong><\/p>\n

    1. Go to Power Apps and open your table where you want to create the prompt column.<\/p>\n

    2. Click on New \u2192 Column \u2192 give it a name and description.<\/p>\n

    \"Configure<\/p>\n

    3. Set Data type = Prompt<\/strong>.<\/p>\n

    \"Configure<\/p>\n

    4. Clear \u201cAllow form fill assistance.\u201d (Recommended because this keeps the prompt focused) and then click + Add new prompt.<\/p>\n

    \"Configure<\/p>\n

    5. Write your custom prompt (or start from the template).<\/p>\n

    \"Configure<\/p>\n

    To remove the prefilled<\/strong> prompt, either delete the text manually or use the three-dot menu next to the Model field and choose the Clear prompt<\/strong> option.<\/p>\n

    6. Add input columns<\/strong> from your table (you can add multiple).<\/p>\n

    \"Configure<\/p>\n

    7. Save<\/strong> the prompt, and then Save<\/strong> the column.<\/p>\n

    Note<\/em>:<\/strong><\/p>\n