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 / AI Builder Dynamic Data
Power Automate
Unanswered

AI Builder Dynamic Data

(0) ShareShare
ReportReport
Posted on by

 

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
Categories:
I have the same question (0)
  • rzaneti Profile Picture
    4,476 Super User 2026 Season 1 on at

    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 🙂

     

  • MarsNet Profile Picture
    on at

    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
  • MarsNet Profile Picture
    on at

    @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

  • rzaneti Profile Picture
    4,476 Super User 2026 Season 1 on at

    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
    on at

    @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
    4,476 Super User 2026 Season 1 on at

    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 🙂

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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Valantis Profile Picture

Valantis 474

#2
11manish Profile Picture

11manish 268

#3
David_MA Profile Picture

David_MA 243 Super User 2026 Season 1

Last 30 days Overall leaderboard