web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Extracting the data fr...
Power Automate
Suggested Answer

Extracting the data from AI Builder GPT prompt into a dataverse table

(1) ShareShare
ReportReport
Posted on by 2
I've been trying to populate a single column in my Dataverse table. From a high level, I've built a simple power automate workflow that includes AI builder (Create text with GPT using a prompt) which is triggered manually. The GPT prompt is asked to analyze a Dataverse table and provide its recommendation on a driver assignment for each specific load. Once the workflow is triggered, it starts the GPT prompt and produces an output that recommends a driver assignment based on each driver's availability. However, I'm not able to export the data that the GPT prompt outputs. Ideally, I'd like it to populate the "Finalized Driver Assignment" column in the table which I've pictured below (highlighted). The entire output of the GPT prompt is not needed, rather just that one column (highlighted in the prompt output picture). Any help would be appreciated, thanks. See below a picture of the workflow, Dataverse table, and output of the GPT prompt.
Categories:
I have the same question (0)
  • Suggested answer
    Michael E. Gernaey Profile Picture
    53,963 Moderator on at
    HI
     
    Please open the Update a Row, and grab the inputs, the raw inputs and the error message in full please.
    Please dont just take pictures of the error, people cut them off all the time, can you like paste the text for the inputs, outputs and error as well as pictures please, then I should be able to help you np
     
    Cheers,

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 464

#2
Haque Profile Picture

Haque 416

#3
David_MA Profile Picture

David_MA 323 Super User 2026 Season 1

Last 30 days Overall leaderboard