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

Notifications

Announcements

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

Categories:
I have the same question (0)
  • rzaneti Profile Picture
    4,241 Super User 2025 Season 2 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!

  • 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,241 Super User 2025 Season 2 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

  • rzaneti Profile Picture
    4,241 Super User 2025 Season 2 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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 503 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 321 Moderator

#3
abm abm Profile Picture

abm abm 237 Most Valuable Professional

Last 30 days Overall leaderboard