Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
Check out the New Agent Creator Community
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Building Flows / AI Builder Dynamic Data
Power Automate - Building Flows
Unanswered

AI Builder Dynamic Data

(0) ShareShare
ReportReport
Posted on by MarsNet

 

Hello everyone,

I am currently working on a project where I need to use AI Builder to extract data from documents and then use that data to either patch or create an Excel sheet in my OneDrive for Business. The specific data I'm dealing with is 'hours worked', which is inside a table named 'wages'.

 

I'm running into an issue where I can't seem to pass the content downstream correctly. I've tried using the columns and field names like 'Hours_x12345', but it hasn't worked.

 

Could someone with experience in AI Builder and Power Automate shed some light on how to properly pass AI Builder model data downstream to an Excel sheet? How do you reference the AI Builder fields properly in Power Automate to update an Excel table?

 

Any insights or guidance would be greatly appreciated. I'm sure I'm missing something simple, but I haven't been able to figure it out on my own.

Thank you in advance for your help!

Best regards,

@MarsNet

Capture.PNG
  • rzaneti Profile Picture
    rzaneti 4,096 Super User 2025 Season 1 on at
    Re: AI Builder Dynamic Data

    Hi @MarsNet ,

     

    After the "Create table" action, add a "List rows present in a table" action, passing this just created table as input. Once you do it, replace the input from your "Apply to each" for the "body/value" from the "List rows present in a table" action.

     

    The problem seems to be the fact that your are trying to access the rows from the table before listing them. Let me know if it works, and if you find any trouble in implementing this design, tomorrow I will be able to provide you with a step-by-step 🙂

  • MarsNet Profile Picture
    MarsNet on at
    Re: AI Builder Dynamic Data

    @rzaneti Thanks for the guidance, 

     

    Encountered errors while working with a table: Error 1 - Unable to overwrite a table, and Error 2 - Invalid array for a 'for each' loop

    table.png
    error.png
  • rzaneti Profile Picture
    rzaneti 4,096 Super User 2025 Season 1 on at
    Re: AI Builder Dynamic Data

    Hi @MarsNet ,

     

    Were you able to extract the data from AI Builder about the hours worked already? If yes, great job!! Sometimes these outputs from AI Builder are tricky and difficult to navigate!

     

    About sending the values to Excel, based on the image of your first message, I'm assuming that you already have a table to store this data. The strategy to add data into this table will depends on how did you organize your data: if you just want to add a new record, use the "Add row into a table" action; if your table already have some records and you just want to insert the date into a specific column of an existing row, use the "Update row" action.

     

    For this second approach, you will need a key column that contains an unique identifier for the record that you want to update, like an id column, for example. Feel free to share an image of your Excel table structure (removing any sensitive data from that), so we can find the best solution for that!

  • MarsNet Profile Picture
    MarsNet on at
    Re: AI Builder Dynamic Data

    @rzaneti Thank you, that resource helps a great deal! I used the dynamic fields to grab the values. Is there an effecient way to send data to excel? Looking at addding row action

  • MarsNet Profile Picture
    MarsNet on at
    Re: AI Builder Dynamic Data

    Having trouble navigating the the body to extract the actual values of Hours Workes, etc. I've tried using select and compose, very novice here so I am uncertain how to write the expression. I would like to send this data to an excel sheet (OneDrive).  Thanks!

    schema.png
    hours worked.png
    sampleData.png
  • rzaneti Profile Picture
    rzaneti 4,096 Super User 2025 Season 1 on at
    Re: AI Builder Dynamic Data

    Hi @MarsNet ,

     

    Just to confirm if I understood correctly: is your main issue not finding the hours field from AI Builder into dynamic content list? If this is the case, could you please share the raw outputs from your AI Builder action? By doing that, we will be able to identify the JSON structure of your action outputs, and access the relevant field by using expressions.

     

    If you don't know how to get access to the raw outputs, refer to the steps described in this article: http://digitalmill.net/2023/06/29/how-to-access-the-raw-outputs-in-power-automate/ 

     

    Make sure to remove any sensitive content before sharing the outputs 🙂

     

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

News and Announcements

Welcome to the Power Platform Communities
Check out the New Agent Creator Community

Quick Links

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 566 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 516 Super User 2025 Season 1

#3
stampcoin Profile Picture

stampcoin 492

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans