
I'm currently working on a flow that pulls certain values out of a given pdf document using AI Builder and Power Automate. My current setup is that AI Builder identifies the tables where the values are stored in the document (it finds the balance sheet and income statement and identifies them as tables), then in a Power Automate flow I loop through each row in those tables using a For Each Balance Sheet entries block and a For Each Income Statement entries block, checking at each step of the for each loops to see if the current entry is one that I'm looking for.
However I'm encountering an issue with a couple documents where the flow seems to be ignoring the first few rows of the table that AI Builder finds. For example I have one document where the first non-header row in the income statement is "sales", then "cost of goods sold", then a table of "expenses", etc., but the for each loop is starting at the table of expenses. When I put that same document into the quick test in AI Builder it has all the rows correctly identified, so I'm thinking the issue is with power automate?
Any help would be appreciated!
Hi,
Is it possible to store your tables in a variables or just in a compose action before looping through them using the outputs of the variables or compose action?