You’re offline. This is a read only version of the page.
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
@MarsNet The answer is actually a two fold. First you need to make sure that you specify which row first. You do this with the ''Key column'' and the ''Key value'' field. This serves as the identifier for the update action. It uses these values to identify which row should be updated.
Second, you need to set the actual value that you want to update which is the hours field. Here you simply select the ''hours'' variable from the AI builder action. I assume you have defined hours as a field or table field in AI Builder already. Eventually you will end up with a ''for each'' because your are working with a table that might have multiple wages in it. For each of the wages you can define your actions.
Share
Report
All responses (
Answers (
1,091
